OraFAQ Forum: Backup & Recovery » database migration from MS SQL Server 7.0 to Oracle Database 9i.

Home » RDBMS Server » Backup & Recovery » database migration from MS SQL Server 7.0 to Oracle Database 9i.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database migration from MS SQL Server 7.0 to Oracle Database 9i. [message #408850]

Thu, 18 June 2009 01:14

dirish
Messages: 232
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

Report message to a moderator

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

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No.

Regards
Michel

Report message to a moderator

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

dirish
Messages: 232
Registered: November 2006

Senior Member

do you have any idea of how to do it, is it possible

Report message to a moderator

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

Michel Cadot
Messages: 68645
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

Report message to a moderator

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

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.

Report message to a moderator

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

dirish
Messages: 232
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

Report message to a moderator

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

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

Report message to a moderator

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

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

http://www.orafaq.com/forum/t/141993/80704/

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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!

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	OUT OF MEMORY error message
Next Topic:	restoring backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:04:51 CDT 2024