cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

Oracle Enterprise to Microsoft SQL

snichols
2-Guest
2-Guest
‎Jul 16, 2014 09:02 AM
‎Jul 16, 2014 09:02 AM

Oracle Enterprise to Microsoft SQL

Hi everyone,

I am looking at moving our Windchill database from Oracle Enterprise to Microsoft SQL. Currently we are running PTC/IntraLink 9.1_M070 with 200 heavy users. Has anyone moved the database to Microsoft SQL? What problems are you seeing running Microsoft SQL?

Thanks,
Stephen Nichols
CAE Application Support
HARRIS Corporation
Government Communications Systems Division
email: -<">mailto:->


Labels:
0 Kudos
Notify Moderator
1 REPLY 1
alonkar-2
1-Newbie
1-Newbie
(To:snichols)
‎Jul 17, 2014 03:15 AM
‎Jul 17, 2014 03:15 AM

Hi Nichols,

We have three separate instances of Windchill PDMLink 9.1 M070 which have databases migrated from Oracle to MSSQL 2008R2. Running fine without any issues.

We actually migrated Windchill 9.1 M060 database from oracle to MSSQL 2005, which was disaster as in M060 was missing required database table instances and we ended up with performances issues.
So we first upgraded from MSSQL 2005 to MSSQL 2008 R2. And searched out to find missing indexes. (I can tell you the process) After applying missing indexes problems resolved.
Later when we updated from Windchill 9.1 M060 to Windchill 9.1 M070, we found most of the indexes were there in M070.

Again there are guidelines available in PTC site about configuring MSSQL server for best performance.



Best Regards,
Amit Lonkar
0 Kudos
Notify Moderator
Top Tags