Amazon

Monday, September 4, 2017

Teamcenter Oracle to SQL server Migration



Well, I am going to start by saying that this was a challenge to begin with. Primary reason being the absence of any Siemens supported tool that helps migrate TC Oracle DB to SQL server. On top of that GTAC does not support the process. You are on your own for the whole process.  If you dare ask GTAC any question about Oracle-SQL server migration they are going to send you a standard template answer which has all the migration steps in a nut shell. You are not supported any further for this process by GTAC.
There is an old white paper on the internet from Microsoft which gives the process of migration. This process applies to SQL server 2008 and it’s no longer valid. We tried to implement this process and we were left with a bunch of issues.
In TC 10 there are about 1500+ tables. You need to understand their DDL very accurately with Respect to SQL server. Besides the Table information, the Views/Indexes need to be redefined. Finally there are multiple settings that needed to be changed in the TC Profilevars and the DB needs to be reconnected to the TC instance.
The key aspect of this migration is that you need to validate all areas of TC including the ones that are not used by the end user very often to make sure that all functions work correctly on the new DB.

Post edit: These are the maximum level of details, that I can provide on this article here. We do not share any other details. We provide only Migration services.

3 comments:

  1. Hi,
    Were you able to successfully migrated from oracle to SQL Server?
    if you have any reference document could you please share?

    ReplyDelete
  2. we were not only able to do it but also converted it to a product..cheers

    ReplyDelete
  3. Can you share where I can purchase the product or instructions?

    ReplyDelete