Migrate from SQL 2000 to SQL 2005

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
leetrotter
Posts: 1
Joined: Sat Aug 18, 2007 12:29 pm

Migrate from SQL 2000 to SQL 2005

Post by leetrotter » Sat Aug 18, 2007 12:36 pm

Hello,

I have SQL Server 2000 and SQL Server 2005 installed on the same server as difference instances. I would like to move my Vault database currently in SQL Server 2000 to the SQL 2005 instance.

What is the best method to do this?

My thoughts are to detact the DB in 2000 and re-attach it in 2005. Has this been done or is there a supported migration path?

I am using Vault 4.0.4

Thanks

Lee

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Sat Aug 18, 2007 8:08 pm

My thoughts are to detact the DB in 2000 and re-attach it in 2005. Has this been done or is there a supported migration path?
Yes, this should be fine. A backup and restore will also work.
Linda Bauer
SourceGear
Technical Support Manager

Locked