Page 1 of 1

COPY SQLTABLE from 1 SERVER to ANOTHER

Posted: Fri Jun 04, 2021 1:48 pm
by 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

Re: COPY SQLTABLE from 1 SERVER to ANOTHER

Posted: Fri Jun 04, 2021 2:35 pm
by 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 )
 

Re: COPY SQLTABLE from 1 SERVER to ANOTHER

Posted: Fri Jun 04, 2021 2:56 pm
by Jack
Thanks for this answer but i 'll a sample for Microsoft MS SQL Server .

Thanks

Philippe