Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Migrate From SQL Server 2005 to SQL Server 2012

Created: 12 Nov 2013 • Updated: 26 Nov 2013 | 7 comments
This issue has been solved. See solution.

HI,

We are using Enterprise Vault 8.0.5 and I've been tasked with moving the databases from where they currently run, a physical Win 2003 box running SQL Server 2005 to a virtual server running Win 2012 and SQL Server 2012.

Does anyone know if there exists any document or Tech Note I need to follow, or whether there are any gotchas or issues I needed to avoid.

Is it possible to do this as part of an upgrade to the Enterprise Vault software?

Many Thanks.

Operating Systems:

Comments 7 CommentsJump to latest comment

Rob.Wilcox's picture

I would advise keeping the 'upgrades' separate. That way if something goes wrong, it'll be easier to revert, and pinpoint the problem.

 

Take a look at:

 

http://www.symantec.com/business/support/index?page=content&id=TECH35744

 

.. for more help.

SOLUTION
GertjanA's picture

Hello

Check the compatibility guide first!

EV8 does not support SQL2012.

What I advise is to upgrade to EV9SP5, then to EV10SP4. EV10 does support SQL2012.

this is the KB describing moving databases: http://www.symantec.com/docs/TECH35744

It is VERY important that the collation of both servers is the same.

 

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/vision

GabeV's picture

Hello,

I would go with the GertjanJ recommendation: upgrade to EV 9.0.5 first then to EV 10.0.4. After that, you can install SQL 2012 and move the Enterprise Vault databases to the new SQL server, since SQL 2012 is supported with EV 10.0.2 or later versions. Take a look at this documents so you can get more familiar with the EV upgrade process for each version:

Symantec Enterprise Vault 9.0.5 - Release Notes
http://www.symantec.com/docs/DOC6417

Symantec Enterprise Vault 10.0.4 - Release Notes and Upgrade Instructions
http://www.symantec.com/docs/DOC6263

“Success is not final, failure is not fatal: it is the courage to continue that counts.”–Winston Churchill

Ravi Bhandari's picture

Thanks to everyone you've been most helpful.

so best to upgrade in place to version 9 and then use the migration utility to upgrade to 10.

After that I can move the database.