Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Complete DB migration from SQL7 to SQL7.

Author  Topic  Averno Starting Member 10 Posts Posted - 2001-06-05 : 05:56:56 Hi, this is my situation: we've just completed the TEST development of our datamart databases on a Compaq 8000. Now is time to migrate ALL the "datamart" (3 DBs) with ALL of the objects (db, sp, diagrams, roles, rules, ecc..) to the PRODUCTION hw (compaq 8500, SQL7). My question is: is it better to backup and restore or manage DTS? Which of these 2 ways assures a COMPLETE migration? Is there something else i don't know i'd have to consider? Thanks a lot, bye.