How to use bpc to transfer data between databases on SQL
server?
Thnaks.

-Tom

You don't use BCP to transfer data. It is strictly a means to export or
import data. See BCP in BooksOnLine for more details.

--

Andrew J. Kelly
SQL Server MVP


"Tom Torain" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

1. BCP OUT the data to a test file from ServerA
2. BCP IN The data to table from Text file to ServerB.

Sample format

BCP dbname..tablename OUT
c:\data\tablename.txt -Sserver -Uuser -Ppassword -c -t ","

BCP dbname..tablename IN
c:\data\tablename.txt -Sserver -Uuser -Ppassword -c -t ","

Please remove the Indexes in tables in ServerB , so as BCP IN will be much
faster. AFter the load you can recreate the indexes.
Use -b option (batch size ) in BCP incase the data volume is huge.

Thanks
Hari
MCDBA


"Tom Torain" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Be sure to use native SQL Server format since it is much faster. There is a
switch for that.

"Hari" <hari_prasad_k (AT) hotmail (DOT) com> wrote