RE: [PHP-WIN] copying MS SQL tables

Yes, i realize this. (this requires, to many mouse clicks) But, what i want is to have it all hidden. I select the remote server on a web page, give it a table and presto! Table copied. -- Gerardo S. Rojas mailto: grojas@strategicinc.com -----Original Message----- From: Frank M. Kromann [mailto:frank@kromann.info] Sent: Wednesday, March 17, 2004 1:14 PM To: Svensson, B.A.T. (HKG) Cc: 'php-windows@lists.php.net' Subject: RE: [PHP-WIN] copying MS SQL tables If you install the MSSQL server Client tools on your PC you will be amle to use the Data Transformation Service (import/export) to copy data and structure from one SQL server to another. Thats the fastest way to do this. - Frank > 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 > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php