Generate Scripts

Use the Generate Scripts function to generate scripts from the objects in an existing database. In effect, this re-creates the whole database structure and any individual database objects.

When you generate scripts, Traverse Server Manager looks within Microsoft SQL Server for objects you specify. This script can be used later to create another SQL database or to send information to OSAS support for help with a problem.

For example, if you create modifications for Traverse, you can generate scripts so that you can use these modifications when installing Traverse elsewhere. Using the scripts, you can set up new databases based on the modifications.

To generate scripts for a company database, follow these steps:

Note: To generate scripts for the System (SYS) database, select Generate System Scripts from the right-click menu. The rest of the steps are the same for both functions.

  1. Right-click on the database from which you want to generate scripts.
  2. Select Generate Scripts or Generate System Scripts.

  3. Select the objects to include when generating scripts. There are several ways to select objects:
    • In the Select Object Type section of the dialog box, select an object type such as All Tables and checks appear next to those items in the list section of the dialog box.
    • Use the list section of the dialog box to select individual objects, such as tables, stored procedures, views, and user-defined data types.
    • Select a range of items in the list section by holding the Shift key down, clicking the object names, and then clicking Select.
    • Select objects scattered throughout the list by holding down the Ctrl key, clicking the object names, and then clicking Select.
    • Use the Filter Containing text box to search for specific text included within an object name. For example, enter tmp and press Tab to bring to the top of the list all objects containing the letters tmp in the object name.
  4. Select the location in which you want to save the scripts file in the Save to Folder field.

    Note: The default file name is DDD_Script.tsmx where DDD is the database you select.

  5. Click OK to generate the scripts, or click Cancel to exit the dialog box.