COPY SQLTABLE from 1 SERVER to ANOTHER

[Jack]

Hi,
How can i copy one table from a database located on one server to another database located on an other server .

Thanks for your help and samples ,

Philippe

[nageswaragunupudi]

Very easy if you use FWH built-in MySql library.

Code: Select all | Expand

oServer1 := maria_Connect( .... )
oServer2 := maria_Connect(....)

// now copy from oServer1 to oServer2
oCn:CopyTableToServer( cTableName, oServer2 )
 

[Jack]

Thanks for this answer but i 'll a sample for Microsoft MS SQL Server .

Thanks

Philippe