Home » RDBMS Server » Backup & Recovery » database migration from MS SQL Server 7.0 to Oracle Database 9i.
database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #408850] Thu, 18 June 2009 01:14 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi All,

Have you ever done a database migration from MS SQL Server 7.0 to Oracle Database 9i.

Thank you,
Dirish
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #408854 is a reply to message #408850] Thu, 18 June 2009 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #408859 is a reply to message #408850] Thu, 18 June 2009 01:55 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
do you have any idea of how to do it, is it possible
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #408876 is a reply to message #408859] Thu, 18 June 2009 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it is possible.

From the data point of view, it is easy using SQL Developer, see SQL Developer Supplementary Information for Microsoft SQL Server and Sybase Adaptive Server Migrations

From the application point of view, locking and transaction management are very different in both databases, so you have to also migrate the code, that is rewrite some parts.

Regards
Michel
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #409492 is a reply to message #408876] Mon, 22 June 2009 22:38 Go to previous messageGo to next message
llaszews
Messages: 6
Registered: June 2009
Location: New Hampshire
Junior Member

I have been involved with hundreds of SQL Server to Oracle Migrations. The free Oracle SQL Developer Migration Workbench mentioned on the previous posting does a very good job. It migrates the SQL Server database objects (tables, views, triggers, stored procedures etc.) to an Oracle database, as well as migrating the data. As far as the application is concerned, this is usually as trivial as changing the ODBC and JDBC drivers and changing some of the non-ANSI standard SQL in the application.
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #409777 is a reply to message #409492] Tue, 23 June 2009 23:51 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hello,

Thank you for the replies.

I have read about this tool, is it possible to migrate sql server 7.0 from windows NT 4.0 to Oracle 9i with this tool.


Thank you,
Dirish
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #410302 is a reply to message #408850] Fri, 26 June 2009 01:10 Go to previous messageGo to next message
nitinkumarbe
Messages: 8
Registered: June 2009
Junior Member

Hi

I think you can use SwisSQL - SQL Server to Oracle Migration Tool to migrate from SQL Server to Oracle Database

Nitin
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #410307 is a reply to message #410302] Fri, 26 June 2009 01:22 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://www.orafaq.com/forum/t/141993/80704/
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #410432 is a reply to message #409777] Fri, 26 June 2009 23:54 Go to previous messageGo to next message
llaszews
Messages: 6
Registered: June 2009
Location: New Hampshire
Junior Member

Oracle SQL Developer Migration workbench supports 7, 2000, and 2005. Does not matter what operating system the SQL Server database is on. SQL Developer needs to reside on a Windows box. The version of Oracle and OS it is on does not matter either.
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #411755 is a reply to message #408850] Mon, 06 July 2009 10:18 Go to previous messageGo to next message
Groutad
Messages: 4
Registered: June 2009
Junior Member
What you can use is an ETL tool. There are open source tools available for free.

Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #411789 is a reply to message #411755] Mon, 06 July 2009 14:28 Go to previous messageGo to next message
llaszews
Messages: 6
Registered: June 2009
Location: New Hampshire
Junior Member

Never heard of this tool. Pretty much any ETL tool (Oracle Data Integrator, Informitca, Pervasive etc.) can be used for SQL Server to Oracle migrations. However, even the lowest cost ones are two expensive for a one time data migration. Unless you will be doing on going replication between the two databases a free tool like Oracle SQL Developer SQL Server Migration Workbench does the job. Plus, it does the stored procedures, triggers, views etc. that ETL tools do not touch.
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #411849 is a reply to message #411789] Tue, 07 July 2009 02:41 Go to previous messageGo to next message
Groutad
Messages: 4
Registered: June 2009
Junior Member
llaszews wrote on Mon, 06 July 2009 14:28
However, even the lowest cost ones are two expensive for a one time data migration.


You are right. If you are using the tool only once, it needs to be unexpensive / free. Talend is free to download and use. Source is open. And you might want to keep using the tool after the migration as its an interesting ETL.

Thanks!
Re: database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #419224 is a reply to message #408850] Thu, 20 August 2009 09:54 Go to previous message
wonn1377
Messages: 3
Registered: August 2009
Location: ny
Junior Member
I think u should use a third party help to resolve this problem, i use dbload to solve it when i was migrated my data, it can migrate almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. i found it on google search.


Download Free : www.dbload.com
Previous Topic: OUT OF MEMORY error message
Next Topic: restoring backup
Goto Forum:
  


Current Time: Thu Nov 27 22:21:44 CST 2014

Total time taken to generate the page: 0.10098 seconds