Post reply

Problems Migrating Database

  • May 2, 2005 at 11:16 am

    #87405

    Hi, I'm moving several databases between Sql Servers that are running Sql 2000, my problem is that the relations between tables are missing, is it possible to happen?, Im my source databse I have Relations and primary keys defined and I my target server I don't have it.

    Another thing strange that programmer team had report to me that some user pasword are missing.????

    To move database from one server to another I'm working with Import and export.

    Thanks for your help.

     

  • May 2, 2005 at 11:28 am

    #556355

    Instead of using import/export wizard (which is really DTS) to migrate the databases, you should be taking a backup from the source server and restoring the backup on the destination server.

    DTS import/export wizard will not move table constraints along with the tables when doing a copy. Plus, it takes so darn long to move data that way.

  • May 2, 2005 at 11:30 am

    #556356

    There's loads of way to move databases between servers. I personally always use attach and detach where possible but the two links should provide some more info for you.

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply