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.
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. :
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.