Any idea on how long it takes to run Oracle to SQL server data migration ? Oracle DB is 100GB

[vmhala]

We have a oracle 11g R2 DB around 100 GB with Windchill PDMLink10.2 M030. Need an estimate of the data migration time needed for TEST and PROD environment conversion ?

[GaryMansell · Accepted solution]

I suspect that this could be like asking how long is a piece of string because all windchill systems have different data sets in them with differing relationships in the DB and also different Oracle and SQL servers will have differing performance, but for what it is worth, our 60GB Oracle database migrated to our MS SQL Server in about 4 hours.

[vmhala]

Thanks Gary,

As you suggested this is dependent on type of data & servers; yet this is really helpful as I needed an high level overview of the duration.  Is it an iterative operation ?

Any tips / pit falls you would like to suggest should we go ahead with oracle to SQL migration ? We do not have much customization and DB health is good.

Again, Thanks for your help!

[GaryMansell]

I found it to be a pretty simple process following PTC's documentation - but you must run install and run the pre-migration utility on your Oracle DB server beforehand as this will identify any issues with your source DB before the migration is run.

A couple of things that occur to me:

• I reduced the amount of memory dedicated to SQL server in order to be able to run the migration (as the tool needs RAM as well) and then put the SQL Server allocation back up to recommendations after the migration had completed.
• Manually create the additional PTC recommended Windchill SQL Indexes and then importantly check for and delete any duplicate Indexes (as SQL server allows them to be created which Oracle does not): https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS98135&art_lang=en&posno=4&q=sql%20server%20indexes&ProductFamily=Windchill%7CWPA&source=search