does bcp do binary data?

[kaiser18au]

Hi all,

I have set up a bcp process. This is bcping between a SQL65 to SQL7. I noticed that the database has a few image field and binary field. Does bcp copy over binary data also?

I used the following
bcp filename out -c -6 ....

the -c is to say I will be using char type to transfer instead of native format. Would this option copy over binary data?

Also does anyone have any idea how i go about verifying if the database has been transfereed completely and correctly.


Thanks in anticipation.

Kaiser

 

[RickCole]

Only my personal choice here as I hate bcp. But I would link the servers and use SQL queries to bring over the data. I always feel I have more control this way and can use Select counts () where necessary to make sure everything is okay.

If this wasn't viable I would then choose to use DTS.

Rick.