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
ECTED] > 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. Roja

RE: [PHP-WIN] copying MS SQL tables

2004-03-17 Thread Svensson, B.A.T. (HKG)
Rojas To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED

[PHP-WIN] copying MS SQL tables

2004-03-17 Thread Gerardo Rojas
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: [EMAIL PROTECTED]