Creating DDL Scripts from an Enterprise Discovery Profile
Creating DDL Scripts from an Enterprise Discovery Profile
When you generate DDL script files from an enterprise discovery profile, you can choose the location where you want to save the script files. You can also choose the database type that you want to run the scripts against. Make sure that you verify and commit all the necessary changes in the enterprise discovery profile before you generate DDL scripts.
In the
Object Explorer
view, select an enterprise discovery profile.
Right-click the profile, and select
Generate DDL
.
The
Generate DDL
dialog box appears.
Click
Browse
to open the
Save As
dialog box.
The default file extension is
.sql
.
Choose a file location, and enter a file name.
Select the type of target database.
Click
OK
.
The Developer tool generates the DDL script files in the location you specified.