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.

.

 

.

Next Page: WebSphere V5.0 : Applying DDL scripts to a remote database - Page 2

Read Next: WebSphere V5.0 : Creating SQL statements

 

Related Topics

SOA Development - Applying Policy

Using XMLType for Handling XML Data in the Database

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Performing XSLT Transformations inside the Database

Moving All the XML Processing into the Database

 

Comments

Post Your Comment:

Members Please Login

Your Name:*

e-mail ID:(required for notification)*

Image Verification: 

 

 Subscribe