Installation Package

U2MigrationWizard.exe.config is the configuration file of the Migration Tool.

It contains the list of the scripts, the possibility to execute a “cleaning”, the query timeout in ms, the version range of allowed Sage XRT Treasury database, and the version target for Sage XRT Solution database.

The Scripts folder gathers the migration scripts.

The following table compares the scripts of the previous version of Migration Tool with those of the current version.

Previous Version	Current Version
00_Preparation_xxx.sql 01_Configuration_xxx.sql 02_Setups_xxx.sql	SetupScript	00_Setup_Base_2024 (8.7.2.xx).sql	The 3 scripts of the previous version are merged to one script ensuring creation of stored procedures, temporary tables and migration of general setup elements.
	SetupScript	01_Setup_Reconciliation_2024 (8.7.2.xx).sql 01a_ReconciliationRules_2024 (8.7.2.xx).sql	New scripts dedicated to Reconciliation rules and elements.
	SetupScript	02_Setup_Cash_2024 (8.7.2.xx).sql 02a_TreasuryTransfers_2024 (8.7.2.xx).sql	New scripts dedicated to setup elements specific to Cash.
	RecScript	03_Reconciliation_2024 (8.7.2.xx).sql	No changes except naming.
	CashScript	04_Cash_2024 (8.7.2.xx).sql	No changes except naming.
	CleanScript	99_Clean_2024 (8.7.2.xx).sql	No changes
	CleanScript	100_FinalOnSXA_2024 (8.7.2.xx).sql	No changes

Scripts are properly versioned and reorganized to ensure “data only” migration.

The SXS.EmptyDatabase.2004 folder contains the empty Sage XRT Solution databases used as target during the migration:

• ES_SXS_EmptyDatabase_2024-SQL2019.bak

• ES_SXS_EmptyDatabase_2024-SQL2022.bak

• FR_SXS_EmptyDatabase_2024-SQL2019.bak

• FR_SXS_EmptyDatabase_2024-SQL2022.bak

• PO_SXS_EmptyDatabase_2024-SQL2019.bak

• PO_SXS_EmptyDatabase_2024-SQL2022.bak

These various backups are now provided for both SQL Server 2019 and SQL Server 2022, with the collation strings used in France, Spain and Portugal.

The SXT.Upgrade Scripts folder contains the update scripts for Sage XRT Treasury.

Sage XRT Treasury database update scripts are located in the installation folder: SXS.EmpyDatabase.2024. They enable you to update your Sage XRT Treasury database to the version 4 without installing Sage XRT Treasury, nor the dbInstaller tool.

U2MigrationWizard.exe is the executable file of the Migration Tool.

The unins000.exe file executes the uninstalling process.