If we right click on Converted Database objects and choose generate, we can generate DDL to create the Oracle Schema and Objects.
The wizard appears again with the introduction screen. Clicking next takes us directly to the Target database Screen.
Click on offline to choose generation of files. For specifics of how the files get generated, click on advanced options
We also get the master.sql file opened in SQL Developer which looks like this
SET ECHO OFF SET VERIFY OFF SET FEEDBACK OFF SET DEFINE ON CLEAR SCREEN set serveroutput on COLUMN date_time NEW_VAL filename noprint; SELECT to_char(systimestamp,'yyyy-mm-dd_hh24-mi-ssxff') date_time FROM DUAL; spool democapture_&filename..log -- Password file execution @passworddefinition.sql PROMPT Creating Role @role.sql prompt creating user Emulation @@Emulation/user.sql prompt creating user dbo_Northwind @@dbo_Northwind/user.sql prompt creating user dbo_pubs @@dbo_pubs/user.sql prompt Building objects in Emulation @@Emulation/master.sql prompt Building objects in dbo_Northwind @@dbo_Northwind/master.sql prompt Building objects in dbo_pubs @@dbo_pubs/master.sql
Now, lets try and run this file and create the users and objects. Firstly, we choose a connection to run the script. This user must have the privileges to create users and all their ancillary objects.
We can run this script to create the users. Notice the worksheet output showing the output of the files.
Once this is complete, we can create a connection in SQL Developer to one of the users created, dbo_Northwind, dbo_pubs and emulation.
Now, we have created the schema from the DDL which was generated. In the next and final episode of this, we will visit the data move. We will run the data move scripts on SQL Server and extract the data which we can load via SQL Loader or external tables.