Moving data between Microsoft Dynamics GP companies

I recently came across a question as to how to move data across Dynamics GP companies. It then became almost an instant challenge to find all the possible answers to this question and while I don’t claim to have them all, I will point out as many methods (and resources) I could think of. If you have used other methods I would certainly value your input to this post.

So here we go:

Method 1. SQL Server Backup/Restore.
This method assumes you will be creating an exact copy of the production data for either test purposes or as a simple fall back method for recovery purposes. See KB article 871973 for more information on how to create a mirrored copy of your GP data.

Method 2. Support Debugging Tool
You can use Support Debugging Tool’s XML Export and XML Import features to select specific tables to transfer. If transfering master tables, KB article 872709 lists the tables you will need to select for the transfer.

Method 3. Integration Manager
Integration Manager is still one of the best methods to transfer data between companies, especially at the end of an implementation, when you need to import master records and beginning balances into a production company that were previously recorded in a test company. Integration Manager can be found on your Microsoft Dynamics GP installation CDs. The following are links to the latest Integration Manager updates:

Microsoft Dynamics GP v9 – Click here
Microsoft Dynamics GP v10 – Click here

Method 4. SnapShot for Microsoft Dynamics GP
Written by David Musgrave, SnapShot works by copying the contents of selected tables to Ctree files in a separate folder, thus creating a SnapShot of the data. This separate folder can then be copied to a target system and the data inserted back into the actual tables. For more information on SnapShot and to download the product, visit the Developing for Dynamics GP website here.

Method 5. Company Setup Automated Solution
If the purpose is to transfer only setup information, then you will want to try the automated solution offered by Microsoft. The automated solution can be found here (CustomerSource/PartnerSource access required). For more information on Automated Solutions check out my previous article here.

Method 6. Table Import
Table Import is the forgotten tool. As many new and more robust tools are developed, this tool seems to drop to the bottom of the memory lane. Don’t forget that Table Import can bring data into specific GP tables that are not supported by the tools. Click here for more information about Table Import.

Hope you find these methods useful and contribute to the article with other methods you have used.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com

Microsoft Dynamics GP Automated Solutions

While I am a big SQL Server development fan and get a lot of support issues taken care of this way, it amazes me that many customers and partners are still not taking advantage of the Microsoft Dynamics GP Automated Solutions. This may be due to lack of understanding or simply a lack of knowledge of the existance of these tools.

What are Automated Solutions?

In Microsoft’s own terms “Automated Solutions are used to simplify certain tasks which would otherwise require knowledge of the SQL Query Language and access to the SQL Query Tools or Support Administrator Console“. In my own terms, Automated Solutions takes away the amount of SQL and Dynamics GP architecture you would need to know to resolve some very common everyday issues. The best part of it all, they are bundled with your Microsoft Dynamics GP enhancement plan and accessible via CustomerSource or PartnerSource.

*Click on image to enlarge

Automated Solutions exists for releases of Dynamics GP going back to 7.5 and are organized by product series. Some of the typical solutions include verifying whether the GL trial balance is out of balance, PO being edited by another user, SOP being edited by another user, among others.

v10 Automated Solutions – click here
v9 Automated Solutions – click here
v7.5 and v8 Automated Solutions – click here

Know that you know about Automated Solutions, be sure to check them before you run that SQL statement.

RELATED ARTICLES

KB article 935384 – Automated solutions that are available for the Financials series in Microsoft Dynamics GP

KB article 935383 – Automated solutions are available for the Distribution series in Microsoft Dynamics GP

KB article 935382 – Automated solutions that are available for the System series in Microsoft Dynamics GP

Article: Stock Batches in Dynamics GP – by Doug Pitcher at Rose Business Solutions

Until next post!

MG.-
Mariano Gomez, MIS, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Microsoft Dynamics GP Automated Solutions

While I am a big SQL Server development fan and get a lot of support issues taken care of this way, it amazes me that many customers and partners are still not taking advantage of the Microsoft Dynamics GP Automated Solutions. This may be due to lack of understanding or simply a lack of knowledge of the existance of these tools.

What are Automated Solutions?

In Microsoft’s own terms “Automated Solutions are used to simplify certain tasks which would otherwise require knowledge of the SQL Query Language and access to the SQL Query Tools or Support Administrator Console“. In my own terms, Automated Solutions takes away the amount of SQL and Dynamics GP architecture you would need to know to resolve some very common everyday issues. The best part of it all, they are bundled with your Microsoft Dynamics GP enhancement plan and accessible via CustomerSource or PartnerSource.

*Click on image to enlarge

Automated Solutions exists for releases of Dynamics GP going back to 7.5 and are organized by product series. Some of the typical solutions include verifying whether the GL trial balance is out of balance, PO being edited by another user, SOP being edited by another user, among others.

v10 Automated Solutions – click here
v9 Automated Solutions – click here
v7.5 and v8 Automated Solutions – click here

Know that you know about Automated Solutions, be sure to check them before you run that SQL statement.

RELATED ARTICLES

KB article 935384 – Automated solutions that are available for the Financials series in Microsoft Dynamics GP

KB article 935383 – Automated solutions are available for the Distribution series in Microsoft Dynamics GP

KB article 935382 – Automated solutions that are available for the System series in Microsoft Dynamics GP

Article: Stock Batches in Dynamics GP – by Doug Pitcher at Rose Business Solutions

Until next post!

MG.-
Mariano Gomez, MIS, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Microsoft Dynamics GP Automated Solutions

While I am a big SQL Server development fan and get a lot of support issues taken care of this way, it amazes me that many customers and partners are still not taking advantage of the Microsoft Dynamics GP Automated Solutions. This may be due to lack of understanding or simply a lack of knowledge of the existance of these tools.

What are Automated Solutions?

In Microsoft’s own terms “Automated Solutions are used to simplify certain tasks which would otherwise require knowledge of the SQL Query Language and access to the SQL Query Tools or Support Administrator Console“. In my own terms, Automated Solutions takes away the amount of SQL and Dynamics GP architecture you would need to know to resolve some very common everyday issues. The best part of it all, they are bundled with your Microsoft Dynamics GP enhancement plan and accessible via CustomerSource or PartnerSource.

*Click on image to enlarge

Automated Solutions exists for releases of Dynamics GP going back to 7.5 and are organized by product series. Some of the typical solutions include verifying whether the GL trial balance is out of balance, PO being edited by another user, SOP being edited by another user, among others.

v10 Automated Solutions – click here
v9 Automated Solutions – click here
v7.5 and v8 Automated Solutions – click here

Know that you know about Automated Solutions, be sure to check them before you run that SQL statement.

RELATED ARTICLES

KB article 935384 – Automated solutions that are available for the Financials series in Microsoft Dynamics GP

KB article 935383 – Automated solutions are available for the Distribution series in Microsoft Dynamics GP

KB article 935382 – Automated solutions that are available for the System series in Microsoft Dynamics GP

Article: Stock Batches in Dynamics GP – by Doug Pitcher at Rose Business Solutions

Until next post!

MG.-
Mariano Gomez, MIS, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/