Windchill 9.1: Oracle to MS SQL

[DanWolf]

I'm looking for any feedback on using Windchill 9.1 with MS SQL vs. Oracle, including switching from Oracle to MS SQL. We're considering moving from Oracle 10g to MS SQL 2005 and I'd like to know if anyone has any experience, good or bad, using Windchill with MS SQL and/or moving from Oracle to MS SQL (performance, stability, etc.). I searched the forums and found a couple similar questions over the past couple years, but didn't find any responses.

Thanks in advance,

Dan

[ScottOwen]

Dan,

We migrated from Intralink 3.4 to PDMLink 9.0/SQL Server 2005 about a year ago and have seenno perfromance issues as of yet. We have around 15 heavyand 45 light users on the system right now. The only real issue we faced at that time was the lack of migration tools so we contracted an offshore firm to migrate our data for us. I heard that 9.1 has an Oracle to SQL Server migration tool but I don't know much about it.

[ChrisCollinson]

There is also a migration tool and guide from Microsoft