Migrate from SQL 2000 to SQL 2005

leetrotter · 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 · 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.