Deploying Objects Using the SQL Developer Cart

The SQL Developer Cart is a convenient tool for deploying Oracle Database objects from one or more database connections to a destination connection. You drag and drop objects from the Connections navigator into the SQL Developer Cart window, specify any desired options, and click the Deploy icon to display the Deploy Objects dialog box. After you complete the information in that dialog box, SQL Developer creates a file containing scripts (including a master script) to create the objects in the schema of a desired destination connection.

To display the SQL Developer Cart window, click View, then SQL Developer Cart. The following figure shows that window after some objects have been added.

SQL Developer Cart window (described in surrounding text)

Deploy icon (active if one or more objects are included): After you have added the objects to be deployed and specified any desired options, click this icon to display the Deploy Objects dialog box, where you can specify further options and generate the deployment scripts and a file that contains them.

Open Cart icon: Lets you open a saved cart by specifying the XML file with the cart contents.

Save Cart icon (active if one of more objects are selected): Displays the Save Cart dialog box, where you specify the File (XML) and the Encoding.

Selected Objects: Contains objects that have been selected for potential deployment. To add objects, select them in the Connections navigator and drag and drop them into the Selected Objects area.

Delete Row icon (red X): Lets you delete selected objects from the Selected Objects area.

Include: Lets you select and deselect all objects or selected objects for inclusion in the deployment.

Type: Type of database object.

Owner: Owner of the database object.

Name: Name of the database object.

Data: For tables and views, lets you include or exclude the associated data for the deployment.

Where: Optional WHERE clause (without the WHERE keyword) to filter the data rows from a table or view.

Connection: Connection from which the object was selected.

Arrow buttons: Let you move objects up or down in the order of Selected Objects. This affects the order in which objects are created in the generated scripts.

Before Script: Optionally specify a .sql script to be executed first in the generated master deployment script (before the other generated scripts).

After Script: Optionally specify a .sql script to be executed last in the generated master deployment script (after the other generated scripts).