Where did the *.cmp and *.sys files go?

Every once in a while, perhaps after a GP upgrade, you needed to rebuild a certain stored procedure or table in the company or Dynamics database.  You could open the SQL folder in the GP client directory and find the tables.cmp, procs.cmp for objects in the company databases and tables.sys, procs.sys for objects in the Dynamics database.  You could search the file for the object you wanted, copy and run the script to re-create the object.  Before running the scripts, you would also replace the %SysDBName% variable with DYNAMICS.

I recently had the need to rebuild the stored procedures for a company database and found the procs.cmp file, however the file was empty.  After talking to support, they gave me the following steps to extract the real sql resource files into a usable format:

1.  Open the dex.ini file and add the following line:

duExtractSQLResources=TRUE

2.  Close and save changes to the dex.ini file.

3.  Open GP Utilities, login and you will notice the SQL Resource Extraction window pictured here (this was for V10).

4.  Open your GP client folder, look in the SQL folder and you should find four new folders – Install, Lesson, Upgrade, Utility – each loaded with the script libraries for the various GP products and purposes. 

5.  Be sure to go back into the dex.ini file and remove the duExtractSQLResources=TRUE line.

6.  In the original case, working with GP V9, I first had to delete the Install, Lesson, Upgrade, and Utility folders before I could get the SQL resources to extract. 

Comments

[rutvij]

I thought you could use Database Maint utility for this purposes beginning GP 10. This allows you to create/drop objects directly into SQL.