To generate a report of all objects within an EPIM or EPX database for different
environments (for example, DEV or QA/PROD), perform the following steps:
-
Connect to the EPIM database using the SQL Server Management Studio
application.
-
Open a New Query window on the EPX database.
-
Load the desired compare extraction script into a new Query window.
-
Select the Results to File option:
-
Select menu option Query->Query Options….
-
Set the Maximum number of characters displayed in each column to 512 or 8192
(see table for the proper size for each compare extraction script) for
Results->Text and click OK:
-
Run the query. A prompt appears to select or specify the .rpt file to be
created. Select or enter the name of the file and click Save.
-
The Messages field will show the results of each query being run:
-
Copy the resulting .rpt file and use in comparisons and to update
CloudForge.
-
Repeat the above steps on the same database using the same script for the
second environment.
-
Run the WinMerge utility to compare the two .rpt files.