SQL 2012 and GP 10

(0) Share

Report

Posted on by Ceejay

445

Hi To All,

I know GP 10 do not support SQL 2012 but we had a server crash. We have moved our database to SQL 2012 which automatically upgraded the databases. We are still able to use GP 10 on SQL 2012.

Now, we are planning to move from GP 10 to GP 2010 and I've read that SQL 2012 is supported in the GP 2010 environment.

The problem that we are having now is how do we move from GP 10 to GP 2010 if we have SQL 2012 as an unsupported version for GP 10? Running the GP 2010 Utilities to upgrade GP produces an error which is: "Your current SQL Server is not a supported version."

Questions:

1. What options are available so that we can upgrade from GP 10 to GP 2010?

2. Can GP 2010 Utilities upgrade our GP 10 tables with a SQL 2012 database? Is there a workaround for the error?

Thank you!

= CJ =

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

Syrus 4,156 on at

Like (0)

Report

RE: SQL 2012 and GP 10

You have mentioned that you able to use GP 10 with SQL 2012 and that was the concern.

Then why there will be an issue for moving GP10 to GP2010.

I don't there will be be any issue not becasue of SQL 2012 if I understood your question correclty, I hope.

Was this reply helpful? Yes No
Ceejay 445 on at

Like (0)

Report

RE: SQL 2012 and GP 10

Hi Syed,

GP 10 data is still on SQL 2012. All new tables, added columns, stored procedures, etc. of GP 2010 are still not on the SQL 2012 database since we are using GP 10. So, there is still a need to upgrade the database. Thanks!

Was this reply helpful? Yes No
Syrus 4,156 on at

Like (0)

Report

RE: SQL 2012 and GP 10

So what you are saying, " If you upgrade GP10 to GP2010 with SQL2012, the GP Unitlities will produce an error and fail"?

How about setting the compatibility mode of SQL2012 to SQL 2008 ?

Was this reply helpful? Yes No
Mariano Gomez 26,225 on at

Like (0)

Report

RE: SQL 2012 and GP 10

Hotfix KB 2654242 Version 11.00.1914 or later for Microsoft Dynamics GP 2010 is required for compatibility with SQL Server 2012. You can download the latest DVD image for Microsoft Dynamics GP 2010 from CustomerSource or PartnerSource. Once you download the latest image, you can begin installing and upgrading your GP 10.0 databases that are currently on your SQL Server 2012 server.

Was this reply helpful? Yes No
Derek Albaugh on at

Like (0)

Report

RE: SQL 2012 and GP 10

Hello CeeJay,

Please let us know if the information provided above doesn't resolve your questions or issues.

Thank you,

Was this reply helpful? Yes No
Ceejay 445 on at

Like (0)

Report

RE: SQL 2012 and GP 10

GP 10 RTM version with SQL 2012 and upgrading it using GP 2010 with Hotfix KB 2654242 Version 11.00.1914 or even Service Pack 5 installed will not help on this situation. The same error will persist.

Note: Please know that at least GP 10 1368 (SP4) is needed/required and it will go through the GP 2010 Utilities but not with GP 10 RTM version. If I had upgraded to SP5 for GP 10 before I used SQL 2012 then everything should run smoothly for the upgrade. But, we weren't able to upgrade our GP 10 with the latest Service Pack so this is the dilemma.

If I install SP5 for GP 10, the same SQL error will appear. GP 10 will not upgrade my RTM version to SP5.

Setting Compatibility Mode to anything: SQL 2005, SQL 2008 or SQL 2012 doesn't work either.

I am still stuck.

Any help is appreciated.

Thank you!

Was this reply helpful? Yes No
Derek Albaugh on at

Like (0)

Report

RE: SQL 2012 and GP 10

Ok, if you're not on at least SP5 for Dynamics GP 10.0, which is required to be compatible with even SQL Server 2008 R2, then yes, you are going to get an error.

Dynamics GP 10.0 Utilities is not going to run on SQL 2012 regardless of what version/build you're on.

If you're able to upgrade to 11.00.1914 or higher for Dynamics GP 2010, you could launch that version of Utilities against SQL 2012.

You're also correct in that changing the compatibility level won't trick Utilities into thinking you're on the correct version.

Unfortunately, we don't have a way to trick GP 10.0 Utilities into not realizing you're on SQL 2012, which is why you're getting the error.

Was this reply helpful? Yes No
Ceejay 445 on at

Like (0)

Report

RE: SQL 2012 and GP 10

Hi Derek,

GP 10 with SP5 and SQL 2012 WILL work on the GP 2010 with 11.00.1914.

GP 10 RTM and SQL 2012 WILL NOT work on the upgrade even if I have 11.00.1914.

Do you recommend anything that will help? Or am I stuck and will never be able to use GP 2010 utilities to do the upgrade knowing my GP 10 is on RTM version on SQL 2012?

Thanks!

Was this reply helpful? Yes No
Verified answer

Derek Albaugh on at

Like (0)

Report

RE: SQL 2012 and GP 10

Well, you have to be on at least 10.00.1368 to upgrade to any version of Dynamics GP 2010, so if you're on Dynamics GP 10.0 RTM, then no, you won't be able to upgrade to Dynamics GP 2010 regardless of what SQL version the databases are on.

mbs.microsoft.com/.../hottopic_mdgp2010_update.htm

You need to be on at least 10.00.1368 (SP4) to upgrade to Dynamics GP 2010, and have to be upgrading to at least 11.00.1914 or higher to be compatible with SQL 2012.

If you're on GP 10.0 RTM and have to upgrade to 10.00.1368 or higher, you'll need to take the databases back to SQL 2008 or 2005 in order to be able to run GP 10.0 Utilities.

Thanks

Was this reply helpful? Yes No
Ceejay 445 on at

Like (0)

Report

RE: SQL 2012 and GP 10

Hi Derek,

Yes, I do not see any other option but to downgrade.

Thank you for the confirmation and for the help.

Was this reply helpful? Yes No