RE: [PHP-WIN] copying MS SQL tables
| From: | HKG) | Date: | Wed, 17 Mar 2004 19:03:07 +0000 |
| Subject: | RE: [PHP-WIN] copying MS SQL tables | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-23165@lists.php.net to get a copy of this message | ||
How many rows do you have in the tables?
If many use bcp.exe to bulk copy out data form source server,
ftp the file to the other server and then bulk copy data into the
target server. That should be the fastets way if you have a lot
of data to copy.
-----Original Message-----
From: Gerardo Rojas
To: php-windows@lists.php.net
Sent: 17-3-2004 19:45
Subject: [PHP-WIN] copying MS SQL tables
Is there a quick way to copy an entire table from one MSSQL server to
another using PHP. These servers are accessed remotely. I have all
required permissions.
--
Gerardo S. Rojas
mailto: grojas@strategicinc.com