kaiser18au
Technical User
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.
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.