topic-40487

Board index FiveWin for Harbour/xHarbour COPY SQLTABLE from 1 SERVER to ANOTHER

Jack

Posts: 300

Joined: Wed Jul 11, 2007 11:06 AM

COPY SQLTABLE from 1 SERVER to ANOTHER
Posted: Fri Jun 04, 2021 01:48 PM

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

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: COPY SQLTABLE from 1 SERVER to ANOTHER
Posted: Fri Jun 04, 2021 02:35 PM

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

Code (fw): Select all Collapse

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

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

Regards

G. N. Rao.

Hyderabad, India

Jack

Posts: 300

Joined: Wed Jul 11, 2007 11:06 AM

Re: COPY SQLTABLE from 1 SERVER to ANOTHER
Posted: Fri Jun 04, 2021 02:56 PM

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

Thanks

Philippe

FiveTech Support Forums

Continue the discussion