Upgrade Vault from SQL2000 to SQL2005

[prodsac]

Hi,

we installed Enterprise Vault 7 on a SQL2000 DB.
What is the procedure to move the DB to a new SQL2005 server?

Thanks,

Marc

[MirrorSphere · Accepted solution]

Exactly the same as moving to another SQL 2000 server.

http://seer.entsupport.symantec.com/docs/273272.htm

There is one very important thing to bear in mind here.  Your SQL 2000 database will have a different collation type than that of your SQL 2005 server.

So when you upgrade to V7.5 (EV 2007) then the upgrade might fail because of this.

See this technote:  http://seer.entsupport.symantec.com/docs/293475.htm

Hope this helps.