SQL Server 2000 to 2005 Migration

ZackJones · Post by **ZackJones** » Thu Apr 27, 2006 2:29 pm

Do Sourcegear have a how-to guide or recommended approach for moving our Dragnet (and vault) data from SQL Server 2000 to SQL Server 2005 machine? I would like to offload some of the work being done by our 2000 machine by moving the Dragnet and Vault databases to our new SQL Server 2005 machine.

Thanks in advance for any hints/tips/gotchas to watch our for.

ZackJones · Post by **ZackJones** » Wed May 03, 2006 8:40 am

tap, tap, tap, Hello? Anyone Home???

Post by **jclausius** » Wed May 03, 2006 9:30 am

This is somewhat relevant for some background info - Moving the Vault Database.

The easiest thing to do would be to:

1) Uninstall Dragnet (Keep the database when prompted).

2) Detach / Move / Attach or Backup / Restore the sgdragnet database to the new SQL Server 2005 machine.

3) Reinstall Dragnet using the new SQL Server 2005 machine as the database (Choose to Use the existing database during the installation).

ZackJones · Post by **ZackJones** » Thu May 04, 2006 4:17 am

Thanks Jeff,

Correct me if I'm wrong but I thought when you detach 2000 database and attach to 2005 database that 2005 sets a compatibility flag indicating that the database, while running under 2005 really isn't a 2005 database. It may be no big deal - I'm just trying to ensure the best performance possible for my Dragnet and Vault users.

Post by **jclausius** » Thu May 04, 2006 5:37 am

From the reading I've done, I do not think that is the case:

SQL Server 2005 Upgrade Handbook
Questions about upgrade of SQL Server 2000 to 2005
Moving Data from SQL Server 2000 to SQL Server 2005

Personally, I always recommend backup / restore whenever moving a database from ANY SQL Server to another.

ZackJones · Post by **ZackJones** » Fri May 05, 2006 4:37 am

Thanks for the references, Jeff. I'll check 'em out.