Upgrade from GP2010 to GP2013 - what is the best practice

(0) Share

Report

Posted on by Syrus

4,156

I know there is lot of helping documents & stuff for upgradation but what I was trying to figure out, if I have GP2010 with SQL 2008 R2 and I also want to upgrade SQL 2008 R 2 to SQL 2012

Should I upgrade to SQL 2012, first and then upgrade GP2013, 2nd or
Should I upgrade GP2013, first and then SQL2012, 2nd ?
or it won't make any different in any order ?

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

Richard Wheeler 75,730 on at

Like (0)

Report

RE: Upgrade from GP2010 to GP2013 - what is the best practice

I would agree with Jonathan. I would like to add that once you are on SQL 2012 to go into SSMS and change the compatilibility level of the databases to SQL Server 2012.
Verified answer

Jonathan Fear on at

Like (0)

Report

RE: Upgrade from GP2010 to GP2013 - what is the best practice

Hi Syed,

This really depends on what builds of GP 2010 you are on. In order to use SQL 2012 on GP 2010 you need to be on at least 11.00.1914. If you have your databases in SQL 2012 and are running Utilities on a build prior to 1914 you are going to receive a SQL version error. So I would recommend upgrading to GP 2013 first and then do the server move to SQL 2012.