Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can bcp do binary data with -c

Status
Not open for further replies.

kaiser18au

Technical User
Joined
Oct 7, 2001
Messages
5
Location
AU
Hi all,
I was wondering if anyone can tell me this.
I am using BCP to do my data transfer from SQL65 to SQL7.

The statement is like:
bcp TableName out “outfile.txt -e "C:\Temp\bcp\sql_err.txt"
-b 10 -n -6 -q
-S "ServerName"
-U “login" -P "Password”

This will do my copy from a DB to file. Does it copy binary data as the database has some field which is binary and image type.

Also does anyone know how to compare 2 database to see if the data transfer is correct.

Thanks

Kaiser.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top