This is the fifth and final article in the #GPPT GP Power Tools: What’s in each module series? of articles.
It covers what is included in the Database Tools module. This module provides tools to backup and restore specific data as well as tools to ensure that your system is working perfectly with your SQL Server.
The Database Tools module contains features for the database administrator, developer or consultant to transfer data between systems and to make sure the system is correctly setup after migrating to a new server, copying to a test server or before and after an upgrade.
Here is a quick summary of the benefits:
- Synchronize and repair Dynamics GP Companies and Users with SQL Server Databases, Logins and Database Users.
- Update Logins and passwords after moving to a new SQL Server or when creating test environments.
- Clean up system tables and validate database integrity and table structures before upgrading to minimize upgrade issues.
- Export and import selected data from multiple tables using XML for quick transfer of small amounts of data between systems or for backups.
Below is a list of the features for this module.
The following key is used to denote whether the feature is a Standard Mode (User level) feature (unmarked) or an Advanced Mode (Administrator level) feature and to what build of GP Power Tools the feature was added in parenthesis.
- (A) Advanced Mode Feature
XML Export (A)
This feature can be used to copy relatively small amounts of data between companies or systems. It is account framework independent and can be used to select specific tables (with optional SQL where clauses) to copy the exact data desired into an XML file. Use this feature to copy security settings from UAT to Live systems during new installs, or to backup data when testing code so you can restore back. Support engineers can also use this to request specific data instead of huge gigabyte sized backup files.
XML Import (A)
This feature is used to import data backed up with XML Export. You have the options to select which tables to import as well as defining whether the table should be cleared beforehand and whether to import duplicate records.
Database Validation (20) (A)
Checks Dynamics GP setup for users, companies and company access and makes sure that the appropriate settings in SQL Server for logins, databases and database users matches. It can clean up references to unwanted users and companies as well as ensuring all the security and access rights are granted correctly. It can look for and fix issues with incorrect references in the tables used by Dynamics Utilities during upgrades. It can find and fix account framework differences between the application, system database and company databases. Finally, it can validate and fix any differences in the table structures between the Dexterity Table Definitions and SQL Server. You can also use this tool to force users to reset logins or change Advanced SQL Server password options.
Build 28 adds checks for the user’s schema to ensure it is set to dbo.
SQL Login Maintenance (27) (A)
Use this window to reset passwords and check or change password policy settings. New passwords can be entered or generated and emailed to users.
Password Reset Email Settings (28) (A)
Use this window to enable/disable the sending of Password Reset emails when the passwords are changed in Database Validation, SQL Login Maintenance or from the standard User Setup window.
Copy User Settings (28) (A)
This window can be used to duplicate user settings in the system database from one user to another user. It is very useful when a new employee starts and you want them to have all the same settings as the predecessor.
SQL Trigger Control (28) (A)
Use this window to check for and enable or disable SQL triggers for maintenance or troubleshooting. Disabled triggers can also be deleted if they are no longer needed.
I hope this helps your understanding of GP Power Tools and what it can do for you. If you want more details than provided in this series, please download the GP Power Tools User Guide manual, which contains 592 pages of detailed description of every feature in the product.
You can also download and install the product, NFR (Not for Resale) Keys are available for partners and a free 30 day trial is available for customers (just install and follow the on screen instructions). GP Power Tools can also work with no registration keys if only the sample company is installed.
I firmly believe that all Microsoft Dynamics GP sites globally should have GP Power Tools installed, and the articles in this series will explain why.
12-Feb-2019: Updated after the release of build 26 of GP Power Tools.
24-May-2019: Updated after the release of build 27 of GP Power Tools.
11-Aug-2020: Updated after the release of build 28 of GP Power Tools.
This article was originally posted on http://www.winthropdc.com/blog.