SQL Server 2000 to 2005 Migration

This forum is now locked, since gold support is no longer offered.

Moderator: SourceGear

Locked
ZackJones
Posts: 131
Joined: Mon Mar 08, 2004 6:30 am
Location: Warner Robins, GA

SQL Server 2000 to 2005 Migration

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
Posts: 131
Joined: Mon Mar 08, 2004 6:30 am
Location: Warner Robins, GA

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

tap, tap, tap, Hello? Anyone Home??? :)

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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).
Jeff Clausius
SourceGear

ZackJones
Posts: 131
Joined: Mon Mar 08, 2004 6:30 am
Location: Warner Robins, GA

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.

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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.
Jeff Clausius
SourceGear

ZackJones
Posts: 131
Joined: Mon Mar 08, 2004 6:30 am
Location: Warner Robins, GA

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

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

Locked