Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP 10 Databas...
Microsoft Dynamics GP (Archived)

Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have a customer whose IT moved the Dynamics GP 10 databases to SQL 2012. The Dynamics release is prior to the version that can be directly updated to 2010. I can't upgrade the release due to the fact that when the SP5 patch runs it detect the wrong SQL version it fails. The only choice that I have found is to downgrade the databases. I have used the generate scripts option on SQL server and was able to get the databases created but the GL and Period Setup files didn't load.

Does anyone know a clean way to perform this downgrade to that retains system integrity?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    Got it – thanks …I will try the BCP instead.

     

    Vince

  • Hafandi Profile Picture
    Hafandi 130 on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    As Mariano mentioned, using the SQL export/import tool may result on compatibility issue, and you will anyhow need to deal with some master data created on the master tables by default when creating the empty DB, also you need to exclude all views tables when using this tool.

    Using BCP will be more efficient and with the steps mentioned on the article it will be straight foreword.

    I would recommend what Mariano and Richard suggest in case the SQL 2012 data were not used and no transaction made on it after the move. In this case you need to take the old backup you may have before the move and restore it on another SQL 2008 and do the upgrade and then move it back to SQL 2012. But, if the users already started working on SQL 2012 data and made some transactions or you don't have old backup before moving to new SQL then I don't think you will have any other than using BCP.

    Last thing, [quote user="Vince Stefanetti"] script the DBs without data as 2008 Compatible DBs [/quote] on the same SQL 2012 and without using GP utilities will not work. You need to create All GP databases on a new SQL 2008 instance using GP utilities. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    Hi Hasan, thanks for the data I am planning to script the DBs without data as 2008 Compatible DBs and then use SQL Import/Export to transfer the data instead of using command line. Thoughts?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    I would 3rd Mariano's suggestion but GP 10 is RTM and wouldn't upgrade to being with so downgrade is the only choice.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    That is true. In that case find the install media for whatever version SQL they were using and use that. I have had this problem with IT people before. They blindly come through with upgrades without any concern for the applications. Then we are stuck fixing the problems they created.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    The issue with SQL Express is, their databases may be over 10GB

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    I would normally second Mariano's recommendation but I take it IT has already moved the databases and taken their old server offline so you are stuck with just databases so this makes Mariano's suggestion not possible? Doing a bulk copy out and in is possible but incurs a lot of unnecessary work. The simplest solution is find an old WXP or W7 computer and put SQL Express 2008 on it and upgrade that copy. Then you copy everything over to the new server and upgrade to the newer version of GP. Tell IT they created this problem so they are obligated to assist in the solution.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    Not a very good idea. SQL Server 2012 treats certain things very differently from its predecessors and you might find that certain things are incompatible. Again, my recommendation is to do an in-place upgrade, then migrate the databases.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    Thanks for that. Appears I can script the schema and structures and then use x64 import/export for bring the data over? Thoughts?

    Vince

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Dynamics GP 10 Database Moved to SQL 2012 Doesn't Upgrade

    In these type of situations, I do recommend you do an in-place upgrade, before you decide to transfer databases to a new server. SQL Server 2012 is not supported with GP 10.0 therefore Dynamics GP Utilities will not recognize it as a valid database.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans