Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
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 ?
Solved! Go to 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.
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.
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!
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: