Generating SQL scripts for custom objects

You can generate a SQL script for custom forms and objects, using this procedure:

Launch FormSync (either the form or the stand-alone utility).
If you have not already done so, open the Configurations page and specify the Source or Target configuration for which you want to generate and save a list of custom objects.

Note: To script licenses for forms, the Source configuration must include an application database that contains license records for the forms.
Access the FormSync Utilities page:
- In the form version, click Utilities on the main page.
- In the stand-alone version, click the Utilities icon on the Toolbar.
Use the Filter tab to set filter criteria to retrieve the custom objects for which you want to generate SQL scripts.
Click Refresh List.
In the Custom Objects grid, the Include check box is selected for each object by default. Clear the check box for any object that you do not want to script.
Select the Script tab.
(Form version only) Specify whether you want to Save the output to a file on disk or View the output in a temporary display page.
To include the names of custom objects in a list of comments in the header of the script, select the Include objects list in script header check box.
To exclude the list, clear the check box.
To generate a separate script for each object selected, select the Generate separate scripts per object check box. To generate a single script for all selected objects, clear the check box.
To [do what?] select the Preserve locked by [form version]/Preserve "LockedBy" check box.
For the first Filename, perform one of these actions:
Note: In the stand-alone version of FormSync, this field is labeled Object file name.
- Accept the default filename and path specification.
- (Stand-alone version only) Use the ellipsis (•••) button to locate, name, and select the filename and path.
- Enter the path and file name manually, using standard Windows path formatting.
To generate a script containing definitions of license records associated with new forms and copies of vendor-licensed forms, select the Script form license check box. To skip generation of a license script, clear this check box.
For the second Filename, perform one of these actions:
Note: In the stand-alone version of FormSync, this field is labeled License file name.
- Accept the default file and path specification.
- (Stand-alone version only) Use the ellipsis (•••) button to locate, name, and select the filename and path.
- Enter the path and file name manually, using standard Windows path formatting.
Click Generate.
At the prompt, click Yes.

You can now export the SQL scripted customizations to your SQL Server forms database.

Note: (Stand-alone version of FormSync only) To open and view the scripts from the Utilities dialog box, click the Open File button to the right of the ellipsis button. FormSync uses whatever program (such as SQL Server) that you have set as the default program for SQL script (*.sql) files.