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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted Dec 8, 2004

Oracle Migration Workbench - Part 4 - Page 3

By Steve Callan

Oracle Migration Workbench and SQL Server

Two preliminary steps that must be completed prior to starting the Migration Workbench utility are creating a new ODBC data source and installing the executable JAR file for SQL Server 2000.

If you are using Windows XP (and this is probably true for Windows 2000 as well), the version of the DLL file on your PC will be new enough (it must be version 3.70.06.23 or higher). You can find the DLL file in C:\WINDOWS\SYSTEM32. Right-click the file and select the Version tab, then look at the Product Version information.

Follow the instructions in Chapter 3 of the User's Guide (the "Before Migrating From Microsoft SQL Server" section) to create a new data source. The series of screen shots that follow are what you will see in a step-by-step order. Access the ODBC Data Source Administrator via Administrative Tools (from the Control Panel or Start>Programs if that is enabled on your PC). Click Add while in the User DSN tab view to start the addition process.

Scroll down the list until you see SQL Server. Highlight it and click Finish.

Complete the fields as shown below (assuming you want to use the Northwind database; you can use pubs or whatever else you want).

My user "Steve" is set up to use OS authentication.

Click Next and select the Northwind database.

Accept the default settings as shown and click Finish.

Review the setup information and test connecting to the data source if desired.

I opted to test and the test completed successfully.



Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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