|
WebSphere V5.0 : Applying DDL scripts to a remote database |
|
Page 1 of 2
WebSphere V5.0 : Applying DDL scripts to a remote database
In this tutorial you will learn about, WebSphere V5.0 : Applying DDL scripts to a remote database and Run on Database Server.
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

.
4. Select the statements that you want to execute against the remote database.
.
|