Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 8, 2004

Oracle Migration Workbench - Part 4 - Page 4

By Steve Callan

After clicking OK on the setup window, returning to the ODBC Data Source Administrator window shows that the data source named Northwind is using the SQL Server driver. Click OK to dismiss the window.

Now we are ready to make Migration Workbench work with SQL Server. If you do not already have it, you will need the plug-in for SQL Server 2000. Oracle Technology Network, at the time of this writing, was reorganizing their download area, so you may get a "page not found or DNS server error" when clicking on the link at http://www.oracle.com/technology/software/tech/migration/workbench/index.html.

If you encounter this error, send an email to infomwb_ww@oracle.com and ask to have the JAR file emailed to you (it is only 542KB in its compressed state, and 575KB uncompressed). If you navigate to the download page directly, you can skip the survey.

Once the plug-in is extracted and placed in the plugins directory of your OWMB installation, you will see that the "Select Migration Source" window (what you see after starting Migration Workbench) now reflects MySQL and SQL Server. Select SQL Server and note that the previous Oracle Model for the MySQL migration will be truncated. And like before, Migration Workbench will start the Capture Wizard.

We will finish Part Four here. If you want to continue on your own, follow the instructions in the wizard. Without modifying the SQL Server data source, you will encounter a number of errors as shown below.

In Closing

At this point in the process, we are ready to create a new Oracle Model - well, almost. There is some detailed reading in the User's Guide you have to perform because the "online" SQL Server migration process requires manual adjustments or editing of some SQL Server objects (views and stored procedures in the Northwind case). In Part Five, we will perform the migration process and look at what has to be done to prepare a SQL Server database for use with Oracle Migration Workbench.

» See All Articles by Columnist Steve Callan

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM