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

All responses (15)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

RE: SQL 2012 and GP 10

I ran into this yesterday on an old install.

Order of Operation:

GP 10.0 installed pointing at a SQL 2005/2008 database.

GP 10.0 NOT updated, but SQL engine upgraded from 2005 to 2008 to 2012 (or some such).

GP 10.0 never complains, and runs fine on all three engines.

Workstation is replaced, GP 10.0 installed. At first run when client is forced to resync with database, the error mentioned in this article is thrown.

Solution:

Install GP 10.0 on new workstation. Do NOT launch Dynamics/Utilities. Rename install directory, copy entire install directory (use same paths) from old workstation. Launch Dynamics - which will think it has already sync'd, because those files have and you will run normally.

MCooper06
Community Member on at

Like (0)

Report

RE: SQL 2012 and GP 10

Derek

I did notice with SSMS: DB\Properties\Options Compatibility has a blank drop down. A colleague suggested I run the following which did in fact run successfully, however I still receive the error.

I ran

declare @str varchar(max),@db varchar(1000)

declare a cursor for select name from sys.databases where database_id>4 order by name

open a fetch next from a into @db while @@FETCH_STATUS<>-1 begin

select @str='ALTER DATABASE '+@db+' SET COMPATIBILITY_LEVEL = 110' --90=2005, 100=2008,110=2012

exec(@str)

fetch next from a into @db end close a deallocate a
Derek Albaugh on at

Like (0)

Report

RE: SQL 2012 and GP 10

Hello,

Dynamics GP 2010 is compatible with SQL Server 2012 both 32 and 64 bit as per the System Requirements so there shouldn't be any issue with launching GP 2010 Utilities on SQL Server 2012.

Dynamics GP 10.0 at the 10.00.1368 also can upgrade to any version/build of Dynamics GP 2010, so there should be no issues there either.

We may need to look at your system to troubleshoot this further, as something isn't adding up. The only thing I could think of, off the top of my head, is to check the database compatibility level, other than that, I don't know why you'd be getting this type of error message.

Thank you
Community Member on at

Like (0)

Report

RE: SQL 2012 and GP 10

The production server with Dynamics GP 10 is currently at 10.0.1368, I was only able to get it to upgrade by making a backup of SQL05 databases at 10.0.1129 then restoring to SQL 08 express, I then altered the ODBC to look at 08 Express and I was able to upgrade to 10.0.1368.

My challenge is that the new server is running SQl 2012, so I thought I would back up the 08 express at 10.0.1368 and restore to SQL 2012 then run 2010 SP4 and upgrade the tables and then make the final jump to GP 2015.

However upon trying to run utilities for 2010 SP4 on the new server I receive the same error when I try to upgrade GP 10.0.1368.

What am I needing to do at this point to continue the migration path?

Thank you

Mark
Jonathan Fear on at

Like (0)

Report

RE: SQL 2012 and GP 10

There is no way around this error in Utilities as it is hard coded.
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.
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
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!
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.
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!