RE: [PHP-WIN] copying MS SQL tables
| From: | Frank M. Kromann | Date: | Wed, 17 Mar 2004 19:14:26 +0000 |
| Subject: | RE: [PHP-WIN] copying MS SQL tables | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-23166@lists.php.net to get a copy of this message | ||
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
>