hi,

 Thankz for your support,there is some errors while copying DB, Anyway i will take care of that.

Thankz

Arshad.

hi ray,

 I have gone through http://www.sqldts.com/?293,1. but the article says that the source and destination has already has the table structure and they are exporting only the datas.

In my...

hi,

 I can't understand what u said.Iam specifying primary key and identity values on a table named trans on id column. After exporting the database, on the client side when i...

thanks all for all your, suggestions and all the help u people gave me. Arshad.

Iam not sure to use via XML but anyway i will try it later , but BCP sounds useful,can u pls specify clearly how to use BCP and from where...