Generate Scripts
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.
-
In the left column of the main window, right-click on the database from which you want to generate scripts.
-
Select Generate Scripts from the right-click menu. The Script Database dialog box appears.
-
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.
-
You can select a range of items in the list section by holding the Shift key down, clicking the object names, and then clicking Select.
-
You can 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.
-
In the Save to Folder text box, enter the path where you want to store the Access database that contains the generated scripts or use the Browse button to look up the location.
-
The default file name is YYY_Script.tsm where YYY is the database you select.
-
Click OK to generate your scripts or click Cancel to exit the dialog box.