Data Migration From Oracle 9i to SQL server 2008.

Question

question

vijay 2 asked Jun 14, '11

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.

sql-server-2008 migration data

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-06-14T04:46:40Z

Kev Riley answered Jun 14, '11

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

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2011-06-14T07:47:08Z

Grant Fritchey answered Jun 14, '11

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.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

vijay 2 commented · Jun 14, 2011 at 11:14 PM

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.

0 ·

question