Generate Scripts

The following demonstrates how to generate data dictionary scripts using different filter options in SQL.

SELECT A CUSTOM OBJECT FILTER OPTION

1. Open MS SQL Server Management Studio > Right Click on any IS Database (with custom objects). The Generate Script Filter form loads.
   
   
2. Select any object in the list for scripting.
   
3. Select Save Location > Locate DataDictionaryScript.sql.
   

   The Save Location field only accepts ‘DataDictionaryScript.sql’ file. Please make sure to have the right location of the file so that the AssemblyID will be auto-generated.

   
4. Click Generate button. The Data Dictionary script will load. Verify if the script contains the object name selected in the filter form.
   
5. Click Execute or press F5.
   

   Script is automatically saved based on the path stated on the Save Location field.

SELECT ALL FILTER OPTION FOR ALL CUSTOM OBJECTS

1. Open MS SQL Server Management Studio > Right click on any IS Database (with custom objects). The Generate Script Filter form loads.
   
2. Select all objects in the list for scripting.
   
3. Select Save Location > Locate DataDictionaryScript.sql. The Assembly ID will be automatically generated and can be edited if preferred.
   

   If no custom object is selected, a message prompt will appear stating that a custom object needs to be selected.

   
4. Click Generate button. The Data Dictionary script will load. Verify if the script contains the object name selected in the filter form.
5. Click Execute or press F5.
6. Save the script. Select file location for saving.