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:
The Community Team is working with PTC Product Management to provide status updates to ideas in all the PTC Community Idea boards.
To learn about status descriptions, please visit Community Welcome & How-To's
Rehost utilies have bad performance while doing a rehost of an Oracle's base larger than 500 GB.
When using the parameters "ChangeHome", it can take a lot of time performing SQL Request, so we suggest that :
-Can we bind thoses request to have better performance?
-Is it possible to have "auto-commit" mode ? for exemple after 10000 requests.
-Is it possible to put "out of the box" the update of the table "ApplicationData" from the ChangeHome part of the rehost? (if we want to update this table after the rehost)
... View more
New IdeaSubmitted on11-29-201807:10 AMSubmitted bytkriegeron11-29-201807:10 AM
This idea is based on the PTC answer:
“actually importing to db is a different thing, when we do it through WQS, we may have some logic implemented where we insert related records in other tables while inserting records for system tree item table tables seen on UI of WQS don't relate directly to data base table present in sql server or oracle”
Since I figured out, that the Import Manager of PTC Windchill Quality Solution is not able to handle more than a few thousend System Tree item via the EXCEL import and the EXCEL import is not ideal for a lot of data anyway, I suggest to implement in the Windchill DB an additional table admin.import; This table rows should be identical to the import wizzard, but however, there should be no check on this table.
Whoever wants to load now data from one DB (ERP...) to Windchill can transfer them directly into admin.import (SQL DB; POSTGRES... to Windchill SQL) without using EXCEL; A routine or manager can than fetch the data easily into the Windchill tables with whatever logic is required.
... View more