Today, we'll show you how to use scripts to convert SQL Server. First we need to start up SQL Developer and choose the Tools menu, then select Migration and Create Offline Capture Scripts
When the dialog appears, choose the SQL Server and the appropriate version you want. You will also need to choose a directory to put the scripts into.
Now, lets go to SQL Server and run the scripts against the SQL Server database. Looking below, I have opened up a command window and created a directory called blog and moved the sqlserver.zip file into that directory.
Now, we have the scripts on the SQL Server box and ready to run. Its important that when you run the scripts on a server, that you always run it from the same place. The script which is run takes a number of parameters to run.
OMWB_OFFLINE_CAPTURE sa superuser_password databasename server
OMWB_OFFLINE_CAPTURE sa saPASSWORD DBNAME_TO_CAPTURE SQLSERVER_SERVER
This will unload the metadata from the database to flat files. You need to run this script once for each database you want to migrate. You'll see something like these as you go.
Ok, for those of you who are doing this right now, read on.
When you have the capture.zip file transferred, unzip it into a clean directory. We will use SQL Developer on this to convert these metadata files into DDL to create the new Oracle schema and the data move scripts which can be used to unload the data from SQL Server and load it into Oracle.
Now, we use SQL Developer to load this data. We will need access to an Oracle database to create a schema to use as a repository. The repository is used to hold the source database information and the converted data.
The next post will walk through SQL Developer loading these files and converting the metadata to an Oracle equivalent.