Applying DDL scripts to a remote database

You can apply the statements defined in an SQL DDL file by running the script against a remote database.

1. Switch to the Data perspective's Data Definition view.

2. Locate the SQL DDL script that you want to apply. The SQL DDL script has the file name extension .sql. If the script is not showing up in the Data Definition view, check your Data Definition filter preference (Menu button in Data Definition view and then click Filters) to make sure it is not being filtered out.

3. From the script's pop-up menu, click Run on Database Server to open the Run Script wizard.

Run on Database Server

 

.

 

5. Click Next to open the Run Script Options wizard.

.

 

6. Select the options to be used when running the script.

.

 

.

Prev - Next >>