t2c_schema_analyzer_report

The Multi-Site data_share utility supports bulk migration of data between different Teamcenter releases, for example when moving from an earlier on-premises Teamcenter release to a later cloud-based release. You can run the t2c_schema_analyzer_report utility before the migration to analyze the data model templates of the two installations to identify any changes needed for the source site data to be compliant with the target site's data model. Addressing those changes enables you to avoid the need to upgrade the source site to the same version as the target site before the migration. You can run t2c_schema_analyzer_report from either the source or target site. Both sites must be running Teamcenter 11.6 or later with TC XML-based Multi-Site installed. See Migrating Multi-Site Teamcenter data to a newer version of Multi-Site for more information. Running t2c_schema_analyzer_report produces .csv and .xml reports showing the business object and attribute changes needed for the data to be compatible with the data model of the later version of Teamcenter. The .xml report summarizes the changes. The .csv report contains a more detailed breakdown of the needed changes. See Understanding the results for more information on the schema analyzer reports. Running t2c_schema_analyzer_report also produces a script that programmatically addresses certain data compatibility issues between the Teamcenter versions. Run this script after migrating your data. Other data changes may require you to modify the data model at the source site. Syntax t2c_schema_analyzer_report -version=from_version -target_version=from_version -report_folder=report_path {-source=source_template_path | -target=target_template_path} [-db_profiling_file=profiling_file] [-help] Arguments -version Specifies the version of Teamcenter on the source site. Use the form TCmajor.minor. For example, TC12.3 and TC 13.1. You can further include patch version numbers if the site has been patched. For example, TC12.3.0.1. When running Teamcenter, select Help > About to verify the version of Teamcenter. -target_version Specifies the version of Teamcenter on the target site. Use the same form as described for -version. -report_folder Specifies the folder in which the report and batch files are saved. -source Required when you a running the utility on the target site. Specifies the directory containing the source site's template files. These files are stored in the source site's TC_DATA\model directory. -target Required when you a running the utility on the source site. Specifies the directory containing the target site's template files. These files are stored in the target site's TC_DATA\model directory. -db_profiling_file Specifies the data profile .csv file containing the object count for each type of business object in the database. Optionally create this file using the steps in Create a profile of the source site's data in Performing the analysis. -help Displays help for this utility. Environment This utility works on any Linux or Windows platforms with Perl installed and in the path. Restrictions Use this utility in preparation for using the Multi-Site data_share utility to migrate data between different Teamcenter releases. Examples Run from the target site to analyze a local copy of the source site release 12.1 templates against the current site's templates in its \TC_DATA_MODEL folder. Copy t2c_schema_analyzer_report.bat -version=12.1 -report_folder=c:\temp\report -source=c:\temp\source_templates -db_profiling_file=c:\temp\tc121object_20230621.csv If a value for -db_profling_file is not provided, all business objects in the source schema (including unused business objects) are analyzed. Run from the source site to analyze the source site's current templates against the target site's templates available using a mapped drive. Copy t2c_schema_analyzer_report -version=12.1 -report_folder=c:\temp\report -db_profiling_file=c:\temp\tc121object_20230621.csv -target=m:\tc14\TD\model Related Topics TC XML and PLM XML Configuration for Data Import and Export Multi-Site Collaboration