Data Migration From Oracle 9i to SQL server 2008.


I have a task like migrating database from oracle 9i to Sql server 2008.

Volume of the oracle dump is around 175 GB.

Please let me know the best possible solution with steps.

I have a little bit idea on Microsoft SSMA tool.But my problem is whether the tool will work for huge volumes?.

Thanks, Veejay.

more ▼

asked Jun 14, 2011 at 04:37 AM in Default

avatar image

vijay 2
236 21 21 26

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Veejay, there is lots of information available on the Microsoft website about migrating from Oracle. I would suggest reading some of the whitepapers to get yourself comfortable with the steps.

175Gb is not a huge volume, and SQL Server will cope admirably with that.

more ▼

answered Jun 14, 2011 at 04:46 AM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(comments are locked)
10|1200 characters needed characters left

For a large data set like this, I'd suggest you get familiar with SQL Server Integration Services. It's the extract/transform/load (ETL) tool for SQL Server. Simply automating a migration from Oracle won't work well, so you're probably going to have to build it. Might as well build it based on the best available tool. Plus, learning how that tool works now will help you when you have to perform ETL processes on your SQL Server system later.

more ▼

answered Jun 14, 2011 at 07:47 AM

avatar image

Grant Fritchey ♦♦
137k 20 46 81

Thanks Grant,

My question is whether ssis will work for migrating full database to sql server. All the objects like tables,sps,logins,views,functions..etc.

Thanks, Veejay.

Jun 14, 2011 at 11:14 PM vijay 2
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 14, 2011 at 04:37 AM

Seen: 1712 times

Last Updated: Jun 14, 2011 at 04:47 AM

Copyright 2018 Redgate Software. Privacy Policy