SQL Server 2000 to 2005 Migration

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

Moderator: SourceGear


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

Posts: 131
Joined: Mon Mar 08, 2004 6:30 am
Location: Warner Robins, GA
PostPosted: Wed May 03, 2006 8:40 am
tap, tap, tap, Hello? Anyone Home??? :)

Posts: 3484
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
PostPosted: 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

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

Posts: 3484
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
PostPosted: 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

Posts: 131
Joined: Mon Mar 08, 2004 6:30 am
Location: Warner Robins, GA
PostPosted: Fri May 05, 2006 4:37 am
Thanks for the references, Jeff. I'll check 'em out.

Return to Gold Support (Dragnet) -- Read-only

Who is online

Users browsing this forum: No registered users and 1 guest