SQL SERVER MIGRATION

[vt100]

Hi! I need to migrate SQL data from one MS SQL 2000 to another. The problem I keep facing is that no matter how much I play with the options when using DTS export feature, I get errors regarding the user not existing on the destination server that existed on source server. I uncheck any user related export features in the options, but it still coming up. I am not sure whether I can do a physical backup and restore or detach and attach on the servers since they are on different hosting companies. So I'm wondering if there's a solution that will allow me to achieve what I need using Enterprise Manager.
Thanks in advance,
Alex

 

[markVII]

The easies way would be detaching database and attaching it to another server, of course you would need to create users first.
If you are interested in transferring data only, then DTS ought suffice.