Deploying data definitions to a database server outside of the workbench

 

You can deploy a database or database objects to a database server. The database server can be on the local computer or remote server.

To deploy data definitions to a database server outside of the workbench:

1. In the Data Definition view, select the data definitions that you want to deploy.

2. Right-click the Data Definition view, and click Deploy. The Deploy wizard opens.

3. Select the data definitions that you want to deploy. Then click Next.

4. On the Data Export Options page, select the options for exporting data to define how the data export changes will be committed.

5. Click Next.

6. On the Database Connection page, fill out the appropriate fields to define the database that you are deploying the definitions to.

7. 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.

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

All of the data definitions that you specified are deployed to the target database.

You can then refresh the connection in the Database Explorer view to view the design there and run queries on the target.

 

Parent topic

Deploying data objects to a database