x

Data Migration From Oracle 9i to SQL server 2008.

Hi,

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

vijay 2 gravatar image

vijay 2
236 20 21 23

(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][1] 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.

[1]: http://www.microsoft.com/sqlserver/2008/en/us/migration.aspx
more ▼

answered Jun 14, 2011 at 04:46 AM

Kev Riley gravatar image

Kev Riley ♦♦
52.8k 47 49 76

(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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
98.1k 19 21 74

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1834
x60
x45

asked: Jun 14, 2011 at 04:37 AM

Seen: 1360 times

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