Skip to main content
R
Robert-Altman10-Marble
10-Marble
September 29, 2011
Question

Oracle or SQL

  • September 29, 2011
  • 13 replies
  • 4141 views
Are there in Pros or Cons regarding using Oracle or SQL Database for a
Windchill installation?



In the past I have only used Oracle, members of the IT department here
are more familiar with SQL and would feel more comfortable with it.



Thanks in advance,




13 replies

Show previous replies
P
ptc-28783571-Visitor
1-Visitor
December 20, 2013
Undoubtely Oracle ...
B
BrianToussaint19-Tanzanite
19-Tanzanite
December 20, 2013
So does that mean PTC has a SQL to Oracle converter?

Brian Toussaint
CAD Administrator

Hoshizaki America, Inc.
"A Superior Degree Of Reliability"
618 Hwy. 74 S., Peachtree City, GA 30269
P
patrickchin20001-Visitor
1-Visitor
December 20, 2013

The funny thing is when I performed the migration from Oracle to SQL Server. At the time, PTC was only supporting the migration tools from SQL Server 2005. I successfully used the migration tools from SQL Server 2008 and found the issue of SQL Server not supporting multiple methodservers with SPID/transaction errors. It's more like if PTC supports the Oracle migration tools from SQL Server to Oracle. Most likely Oracle will definitely support it and its just a question of PTC now supporting it. I don't recal ever running any tool from PTC to perform the migration from Oracle to SQL Server. I believe the same will apply for SQL Server to Oracle.


You just have to test everything after migrating.


http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm


Terms & ConditionsAccessibility statement