DTS Import Problems 1

[webmigit]

I'm moving a database between two servers and I need to use DTS, unfortunately, when I run the operation, I get all my tables and data, but the identities and default values are gone. Is there any way to copy these too? I have too many tables to go through one by one to set the identity fields and default values.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[SQLDenis]

Why not doing detach and attach or backup and restore?


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[webmigit]

Denis,

Thanks for the tip... I'm trying to do this without interrupting my site behavior and for some reason, my host didn't give me access rights to access the backup location, which I've just emailed them about.

Tony