In my exporeince the DTS is a worhtless pice of sh.t. If you transfer larg data sets, then it drops data with out telling you about it. Not mentining the slow transaction speed that drives you cracy. -----Original Message----- From: Frank M. Kromann To: Svensson, B.A.T. (HKG) Cc: 'php-windows@xxxxxxxxxxxxx' Sent: 17-3-2004 20:14 Subject: RE: 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@xxxxxxxxxxxxx > Sent: 17-3-2004 19:45 > Subject: 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@xxxxxxxxxxxxxxxx > > -- > 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
