Cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Database encoding conversion from latin1_bin to Unicode

Siemens Genius Siemens Genius
Siemens Genius

Database experts,

Please I have a request which I cannot sort it out myself, never done this yet:

Is it possible to change DB encoding from latin1_bin to Unicode?

Customer is on Tc 11.2

 

They were solving lots of issues with GTAC, and these ended up with the resolution to migrated the DB encoding.

Unfortunately GTAC could not help further.

(We have reviewed your IR and this question you have about how to change the database character set is out of scope for GTAC.)

Does anyone have this experience with such migration/conversion?

The customer expectation is to order such experienced SPLM person for training to assist with the DB conversion.

Please let me know your thoughts on this.

 

TIA

Mila

 

Best regards,
Miloslav Weitz, Teamcenter Consultant, Siemens PLM Software
Production: Teamcenter 11.5, NX 12, Geolus 9.1
Development: N/A Testing: Teamcenter 12.2, NX 1872, Geolus 10.0
2 REPLIES 2

Re: Database encoding conversion from latin1_bin to Unicode

Solution Partner Esteemed Contributor Solution Partner Esteemed Contributor
Solution Partner Esteemed Contributor
The accepted path for your scenario is through a data migration using low-level TCXML (LLTCXML). Specifically, the Site Consolidation tools which requires someone with a site consolidation key which can be obtained by attending the Site Consolidation training. Or hire SPLM.

Basically, you create the new database instance (Target) using the DB encoding desired, then migrate the meta-data using LLTCXML from the Source to the Target DB. Hopefully, you won't have to do anything with the files since that would be a tremendous effort and not something that can be done in a timely manner.

Hiring SPLM is a wise choice unless you intend to perform site consolidations for a living.

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Database encoding conversion from latin1_bin to Unicode

Siemens Genius Siemens Genius
Siemens Genius

Many thanks Randy!

I have received from my colleagues basically the same direction to go with - Site Consolidation.

Best regards,
Miloslav Weitz, Teamcenter Consultant, Siemens PLM Software
Production: Teamcenter 11.5, NX 12, Geolus 9.1
Development: N/A Testing: Teamcenter 12.2, NX 1872, Geolus 10.0