How I Copy Table From One Database And Save Ti To Another Database

For something so 'simple' , there are probably dozens of ways of doing this . And the one chosen will depend on a) How often you want to do this and b) Is it worth spending lots of time learning them .

For SQL I would either use 'select into' ( see w3 schools for syntax) or generate a create script ( this builds all the indexes and triggers unlike 'select into' ) Then edit it for the new db then I would run an export and import from Sql Manager ( assuming its MSSql , other DBs have similar tools) . Ask a DB and they will talk of SSIS jobs or similar. You can write a query to do the same task but normally I wouldn't bother . Such a query would typically be slow , and you might get issues on large numbers of rows , the syntax of the query would change depending on what id columns you are using .

Alternatives include several tools that can synchronise DBs/Tables . E.g microsoft Sql Azure synch . Although these tools can be a pain in the backside when you have large tables and want to make column changes .

In c# you have the option of many ways of basically replacing the SQL script with C# code . You could use entity framework to emit the code , or use a migration framework such as fluent . Or you could write your own to create the table . I think you then have to iterate over the data using your data access technology of choice and write each one to the new table .

BUT if its a one off job then you are probably better off using sql . All the above have their advantages and disadvantages , but for just moving data around SQL is still the tool to go to most of the time.

It does beg the question though as to why you want company and school tables in the same db ( homework question ?)