Yesterday, I received an email from a customer that I met in Reno at the GPUG Summit 2016 conference. He asked a technical question on GP Power Tools and mentioned that he had purchased the tool to be used once he had completed the upgrade to Microsoft Dynamics GP 2015.
The question I had to ask was …
- Why wait till you upgrade to install GP Power Tools?
The reason I ask the question is fairly simple.
By running the GP Power Tools’ Database Validation feature against your system BEFORE you upgrade, you can avoid many upgrade issues before they even occur.
Database Validation can be used to validate that the system’s user and company settings match the SQL Server Logins, Databases and Database Users as well as comparing the data structures of all tables against their definitions in the Dynamics GP Product dictionaries.
Note: For more details on what checks Database Validation makes, see the first article in the links below.
You can also use Database Validation to fix SQL Logins (passwords) and Database Users when moving the system to a new server, which often happens during upgrades.
Even if not moving to a new server, it is common practice to do a test upgrade on a test server. Running Database Validation on your test environment can remove references to users and companies that are not included in the test system.
Database Validation has many features that will help you before and during the upgrade process, so why not get some help now… before you upgrade?
If you already have registered GP Power Tools, your license will be valid for all versions GP Power Tools (for Microsoft Dynamics GP 2010, GP 2013, GP 2013 R2, GP 2015 & GP 2015 R2).
For more information see:
- #GPPT What’s New: Database Validation, copying databases and upgrades
- #GPPT 21 Reasons why you should upgrade to GP Power Tools
- #GPPT What’s New: Series summary for GP Power Tools build 20
- GP Power Tools Portal
You have no reason to wait.
PS: Database Validation is new to GP Power Tools and is not included in the Support Debugging Tool.
This article was originally posted on http://www.winthropdc.com/blog.