|
Collection of Useful Microsoft Dynamics GP Sql Scripts, Tips and Tricks
A nifty way to reverse engineer data manipulation in MS GREAT PLAINS applications
Long Description:
** This is a sponsored post from GP-DYNAMICS.COM**
Helpful Tip for MICROSOFT GREAT PLAINS developers and/or programmers:
Most of the time, our requirements as developers revolve around pulling rows of data by querying the fields or columns of a known table. It's easy right?
But what if what you have are the literal values or data in a database but you don't know what tables and columns they are stored in? This is a typical scenario when developing add-on modules to an existing application such as Microsoft Great Plains Applications. What is the best way to sort of reverse engineer the data flow in these programs so you can pinpoint the actual database objects that you will manipulate on your custom modules?
MSSQL DEEPSEARCH is a very handy utility program that will scan an entire database and give you the exact table and column names that hold a particular literal value that you entered. You basically just provide the connection parameters to any MSSSQL database and it will do the rest for you.
Try it, it's called MSSQL DEEPSEARCH. A demo version is available for download at http://www.gp-dynamics.com/mssql-deep-search.asp
|
IMPORTANT:
Commands with UPDATE, DELETE or DROP can ruin your data! Please use these queries with caution.
We highly recommend that you backup your database before trying out these commands and to load them up first on a test server. Use at your own risk.
Associated SQL Command:
Viewed: 9362 times
Submitted by:
GP-Dynamics
About GP-Dynamics
|
Did you find this script useful?
Please reciprocate by submitting your own script
or any proven advice regarding Dynamics GP use. Click here.
Send the script above to a friend
|
|
|