Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

SQL Help Needed in Copying GP 2010 Data to GP 2013 R2

Posted on by Microsoft Employee

Hello:

You can reference my other posting, where I mention that my test GP 2013 R2 upgrade is failing for one out of sixteen databases, simply because a handful of fixed assets tables refuse to upgrade from GP 2010.

Here's the SQL help that I need.

I have backed up the data in those fixed assets tables into "backup" tables. 

I can drop these fixed assets tables.  And, I can recreate the tables, based on scripting that I created from other fixed assets tables in corresponding databases that successfully upgraded.

But, I cannot copy that data from the backup tables into these recreated GP 2013 tables because the GP 2013 tables have more columns in them than the GP 2010 tables have.

For example, the FA15000 table in GP 2010 has 11 columns, while the corresponding GP 2013 version of this table has 21 columns.

So, how do I copy the data from these backup tables into these new tables, so that GP Utilities will proceed with the upgrade?

Any ideas would be very much appreciated!  If I don't hurry along with this test upgrade, I'm going to get behind schedule.

Thanks!

John

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Help Needed in Copying GP 2010 Data to GP 2013 R2

    First, the following script needs to be run prior to the upgrade of the troubled database:  DELETE DU000030.

    Then, backups of the fixed assets tables need to be made.  Next, create scripts that will be used to recreate these four GP 2010 tables.  Afterward, drop these tables.  Run the scripts, next, to recreate the GP 2010 tables.  Continuing, restore the data from the backed up tables into the "new" GP 2010 tables.  Finally, run GP Utilties and all will be well.

  • Tom Cruse Profile Picture
    Tom Cruse 1,475 on at
    RE: SQL Help Needed in Copying GP 2010 Data to GP 2013 R2

    Great news, please do and update your answer cause I'm curious on what they said.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Help Needed in Copying GP 2010 Data to GP 2013 R2

    Hi Tom:  

    Actually, I ended up opening a support case with Microsoft.  They gave me the remedy, which I'm going to document in my other posting.

    Thanks, for your help!

    John

  • Suggested answer
    Tom Cruse Profile Picture
    Tom Cruse 1,475 on at
    RE: SQL Help Needed in Copying GP 2010 Data to GP 2013 R2

    Copying data table by table sounds a bit frightening especially as a work around for an upgrade.

    What version of GP 2010 were you upgrading from? SP1, SP2 .... etc..  My guess is that the FA module PROD 309 for that particular company did not have the same version build # as all the other companies that upgraded successfully.

    Do you have a backup of the old Dynamics DB before your upgrade? I would restore it to a local instance, even your own computer would be fine, and then investigate the DB_Upgrade and DU000020 tables and see if the db_verBuild for PRODID 309 is at a different build # or even the db_verMajor is a different version then all the other companies. My guess is that this why it's failing to upgrade.

    I've had this type of issue come up before when restoring a backup of an older version into an upgraded environment because the tables from the backup are a different version than what Dynamics thinks it is which can throw all sorts of error during an upgrade.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans