how can we copy the SQL tables from one system to another system.?

Question

how can we copy the SQL tables from one system to another system.?

Answer 1

'the SQL tables' - MySQL or SQL Server? Which version? are the two systems connected? are the software versions identical or different between systems? IF the 'vendor' is the same, even though the versions are different, and Export / Import or Backup/Restore should work. Otherwise, you will need to export the tables into a common format (eg, csv) and also export the table and index definitions. Then (re)build the table definitions, import the data into the new tables, and build your indexes (as opposed to indices).



Want more explicit guidance? Give us more explicit information. What are the from and to platforms, database engines, and versions?

Answer 2

Is this for Microsoft SQLSERVER?



If so, you can use a command line utility, bcp (bulkcopy) to export the table into a file (out) and bulk-copy it "in" on the other system. You would still nees to export the sql script to create the table to a file and then run that against the other server (CREATE TABLE). This can be found under "create sql script for create table).



There are more complex table movers around, such as DTS (for SQL server up to SQL server 2000) or Integration Services for SQL 2005. There are also commercial products from RedGate that automate lots of things, but they cost $$.

Answer 3

use the export utility provided by Oracle.