Skip to main content
A
Anonymous
March 31, 2017
Solved

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

  • March 31, 2017
  • 1 reply
  • 3768 views

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 ?

Best answer by GaryMansell

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.

1 reply

G
GaryMansell12-AmethystAnswer
12-Amethyst
March 31, 2017

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.

A
Anonymous
April 7, 2017

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!

G
GaryMansell12-Amethyst
12-Amethyst
April 7, 2017

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:

Terms & ConditionsAccessibility statement