Running DDL scripts on a remote database

You can deploy the statements in an SQL DDL file by running the script on a remote database.

To run DDL scripts on a remote database:

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

2. In the Scripts folder under a database, right-click the SQL DDL script with a file name extension .sql that you want to apply, and click Deploy. If you do not see a script, ensure that scripts are not filtered from the view. Click Menu > Filter in the Data Definition view to see current filters.

3. On the Run scripts page, select the statements that you want to run on the remote database, then click Next.

4. Select the options to be used when the script runs, then click Next.

5. On the Database Connection page, fill in all of the required fields to establish a JDBC connection to the remote database. See Database Connection Page for more information.

6. Click Finish. If you selected the option to automatically commit changes, your changes are committed to the database. If you did not select this option, a window opens describing your changes.

7. If the Confirm export results window opens, click Commit Changes to save your changes and deploy the data definitions to the database server.

 

Parent topic

Deploying data objects to a database