RE: [PHP-WIN] copying MS SQL tables

2004-03-18 Thread Svensson, B.A.T. (HKG)
: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 17, 2004 2:12 PM > To: Gerardo Rojas > Subject: RE: [PHP-WIN] copying MS SQL tables > > > In the command shell, just type "bcp"and it will output the paramters. > > Typical you should r

RE: [PHP-WIN] copying MS SQL tables

2004-03-18 Thread Gerardo Rojas
al Message- From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 2:12 PM To: Gerardo Rojas Subject: RE: [PHP-WIN] copying MS SQL tables In the command shell, just type "bcp"and it will output the paramters. Typical you should run it like this for import

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Gerardo Rojas
bject: RE: [PHP-WIN] copying MS SQL tables You can download the odbtp extension at http://odbtp.sourceforge.net, and then do the something like the following: It may not be as efficient as bcp, but I think it is what you want. -- bob On Wed, 17 Mar 2004, Gerardo Rojas wrote: > Yes, i real

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Robert Twitty
:[EMAIL PROTECTED] > Sent: Wednesday, March 17, 2004 1:14 PM > To: Svensson, B.A.T. (HKG) > Cc: '[EMAIL PROTECTED]' > 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 Transforma

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Svensson, B.A.T. (HKG)
> use the Data Transformation Service (import/export) [...] > another. Thats the fastest way to do this. How many rows is it in the tables you copy? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Svensson, B.A.T. (HKG)
My recommedation is: use bcp and ftp... that is only thing that is fast and 100% reliable. -Original Message- From: Gerardo Rojas To: Frank M. Kromann; Svensson, B.A.T. (HKG) Cc: [EMAIL PROTECTED] Sent: 17-3-2004 20:25 Subject: RE: [PHP-WIN] copying MS SQL tables Yes, i realize this

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Svensson, B.A.T. (HKG)
EMAIL PROTECTED]' Sent: 17-3-2004 20:14 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

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Gerardo Rojas
:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 1:14 PM To: Svensson, B.A.T. (HKG) Cc: '[EMAIL PROTECTED]' 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

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Frank M. Kromann
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

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Svensson, B.A.T. (HKG)
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