question

vijay 2 avatar image
vijay 2 asked

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-2008migrationdata
10 |1200

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

Kev Riley avatar image
Kev Riley answered
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

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

Grant Fritchey avatar image
Grant Fritchey answered
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 comment
10 |1200

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

vijay 2 avatar image vijay 2 commented ·
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 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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