How do I Intagrate a new company's restored database into GP2016

(0) Share

Report

Posted on by OldCityCat

We upgraded from GP2013 to GP2016 a few months ago, we also did a purge on GP2013. Now I would like to make the Archived GP2013 data available as another company (ARC) in GP2016.

Without going into great details, I created the new company (ARC) in GP2013, backed up the ARC database using SQL 2012, and restored ARC database to GP2016 using SQL 2016 without issues.

The question now is how to get GP2016 to recognize ARC as a new company and upgrade it to 2016?

Thank you in advance for any and all suggestions.

OldCityCat

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

kassab 660 on at

Like (0)

Report

Hi OldCityCat

Typical solution would be as follow:

1- install the old environment on a separate server (SQL 2012 and Dynamics GP 2013) , also create the ARC company from the GP utilities and restore your backup on it.

2- Upgrade the SQL to 2016

3- Upgrade GP 2013 to GP 2016

4- take a backup from the ARC company

5- Go to the live server and Create the ARC Company from GP utilities

6- restore the backup taken from the upgraded environment to the live environment.

The thing is you must upgrade the Company Database from the Dynamics GP 2013 to GP 2016, if you restored it without upgrading it wont work and will generate errors.

Thanks and Regards,

Was this reply helpful? Yes No
Suggested answer

OldCityCat 25 on at

Like (0)

Report

Ahmed,

Thanks for responding and sorry for the delay in responding.

Some of your steps I had already done

1. Was already in place

2. Was installed

3. Upgrade was completed

4. Had a backup

5. Not done

6. Had issues that required help from GP Support. A table was missing some data, so the upgrade didn't complete cleanly

Once again thanks for all your suggestions

OldCityCat

Was this reply helpful? Yes No
Tim Wappat 5,711 on at

Like (0)

Report

Also for others finding this through Google, you should also renumber your restored database

After the archived company database has been restored, the archive company contains references that have the same COMPANYID and INTERID information that the live company has (if indeed it originated from there). So follow from point 6 on this reference document...

support.microsoft.com/.../set-up-a-test-company-that-has-a-copy-of-live-company-data-for-microso

Tim

Was this reply helpful? Yes No
Perry Smith - CRi 1,692 on at

Like (0)

Report

OldCityCat,

Did you delete the company in GP 2016? If so you will need to use utilities to create the archive company, then restore the backup. It must be a GP 2016 backup not GP 2013.

Was this reply helpful? Yes No