Upgrading from FR V10 to FR V11 - Revision history

Vmurrell at 10:32, 12 November 2025

2025-11-12T10:32:59Z

Vmurrell at 17:01, 13 October 2025

2025-10-13T17:01:46Z

Vmurrell at 16:59, 13 October 2025

2025-10-13T16:59:16Z

Vmurrell at 15:52, 4 September 2023

2023-09-04T15:52:53Z

Vmurrell: /* Checking that Structures were Migrated */

2022-06-06T15:47:30Z

‎Checking that Structures were Migrated

Vmurrell: /* Migrating Structural Metadata History and Settings */

2022-06-06T15:46:59Z

‎Migrating Structural Metadata History and Settings

Vmurrell: /* Starting the Version 11 Fusion Registry */

2022-06-06T15:44:28Z

‎Starting the Version 11 Fusion Registry

Vmurrell: /* Starting the Version 11 Fusion Registry */

2022-06-06T15:43:57Z

‎Starting the Version 11 Fusion Registry

Vmurrell: /* Backing Up an Existing Registry */

2022-06-06T15:43:38Z

‎Backing Up an Existing Registry

Vmurrell: /* Edit the generated SQL file */

2022-06-06T15:42:43Z

‎Edit the generated SQL file

← Older revision		Revision as of 10:32, 12 November 2025
Line 1:		Line 1:
	[[Category:Updating_Fusion_Registry]]		[[Category:Updating_Fusion_Registry]]
−	~~[[Category:How_To]]~~
−
	== Overview ==		== Overview ==

@@ Line 1: / Line 1: @@
 [[Category:Updating_Fusion_Registry]]
 [[Category:How_To]]
-[[Category:Fusion Registry Install]]
 == Overview ==

← Older revision		Revision as of 16:59, 13 October 2025
Line 1:		Line 1:
		+	[[Category:Updating_Fusion_Registry]]
	[[Category:How_To]]		[[Category:How_To]]
	[[Category:Fusion Registry Install]]		[[Category:Fusion Registry Install]]

← Older revision		Revision as of 15:52, 4 September 2023
Line 1:		Line 1:
	[[Category:How_To]]		[[Category:How_To]]
		+	[[Category:Fusion Registry Install]]
	== Overview ==		== Overview ==

@@ Line 149: / Line 149: @@
 * The front page of the Regsitry should now be shown.
-=== Checking that Structures were Migrated ===
+=== Checking that Structures were migrated ===
 Once you have performed the above you should find that the structures and individual history have been migrated over. Please check your web server log file "FusionRegistry.log" and look for any unusual errors.  To check the structures and settings have been migrated and are available, please check the following pages:

@@ Line 47: / Line 47: @@
 == Migrating Structural Metadata History and Settings ==
-When migrating from FMR 10 to version 11 it is simpler to migrate metadata via an exported SDMX JSON file (as described earlier in the page). However it is possible to preserve the following information from FMR 10:
+When migrating from FR 10 to version 11 it is simpler to migrate metadata via an exported SDMX JSON file (as described earlier in the page). However it is possible to preserve the following information from FR 10:
 * All metadata structures
 * The individual history of each structure
@@ Line 53: / Line 53: @@
 * Some of the audit information
-The instructions are detailed below. Please take care with your database names to not apply changes against the old version 10 database. The database for FMR 11 should be an empty database.
+The instructions are detailed below. Please take care with your database names to not apply changes against the old version 10 database. The database for FR 11 should be an empty database.
-For information about the purpose of each table in FMR, please refer to [[Explanation_of_Registry_Tables|this page ]].
+For information about the purpose of each table in FR, please refer to [[Explanation_of_Registry_Tables|this page ]].
 === Instructions ===
-To achieve this task we want to copy particular tables from the FMR 10 database to a clean database for FMR 11 and then make modifications to those tables '''before''' attempting to start FMR 11.  The following instructions detail how to make an intermediary SQL file and edit that file.
+To achieve this task we want to copy particular tables from the FR 10 database to a clean database for FR 11 and then make modifications to those tables '''before''' attempting to start FR 11.  The following instructions detail how to make an intermediary SQL file and edit that file.
 === Create a SQL file of database tables ===
-Using the database tool of your choice (for example SQLYog) connect to your FMR 10 database.  Create a file which is the SQL Dump of the table Structure and Data for the following tables (note the spelling of particular tables):
+Using the database tool of your choice (for example SQLYog) connect to your FR 10 database.  Create a file which is the SQL Dump of the table Structure and Data for the following tables (note the spelling of particular tables):
 * registry_audit
 * registry_maintainable_sdmx
@@ Line 85: / Line 85: @@
 Any occurrences of your FR version 10 database within the file will need to be changed to reference the FR version 11 database. It is important to change these values otherwise when you execute the SQL file it will operate against the wrong database. Once these changes have been made save the file.
-By way of example, generating a file from SqlYog will create a file containing 3 occurrences of the FMR version 10 database. These are:
+By way of example, generating a file from SqlYog will create a file containing 3 occurrences of the FR version 10 database. These are:
 * In an intial comment
 * In a "CREATE DATABASE" statement
 * in a "USE" statement
-It is important to change these to the new FMR 11 database otherwise the script will run against the wrong database.
+It is important to change these to the new FR 11 database otherwise the script will run against the wrong database.
 === Load the SQL file into your database ===
@@ Line 101: / Line 101: @@
 === Make final modifications to the tables and data ===
-Before starting FMR the following modifications to the tables will need to be performed.  Again how this is achieved is down to the tools you are using.
+Before starting Fusion Registry the following modifications to the tables will need to be performed.  Again how this is achieved is down to the tools you are using.
-'''NOTE:''' ensure that you are operating on your FMR 11 database. If necessary prepend SQL commands with a USE statement for your database. For example:
+'''NOTE:''' ensure that you are operating on your FR 11 database. If necessary prepend SQL commands with a USE statement for your database. For example:
 <pre>
-USE `FMR_11_DB`;
+USE `FR_11_DB`;
 </pre>
@@ Line 111: / Line 111: @@
 It is important that particular information is removed from the Registry Settings table. This information is:
-* Any stored passwords - FMR 11 uses a stronger encryption technique than FMR 10, so previous passwords cannot be used.
+* Any stored passwords - FR 11 uses a stronger encryption technique than FR 10, so previous passwords cannot be used.
-* The "installed version". By doing this FMR will start on the Install Wizard.
+* The "installed version". By doing this FR will start on the Install Wizard.
 * The Registry "Server URL" - this needs to be specified on the second page of the Install Wizard anyway, but removing it ensures it needs to be re-entered.
@@ Line 126: / Line 126: @@
 === Modify the Transaction Item Table ===
-The structure of the table '''sdmx_transaction_item''' has changed in FMR 11.  This table has a column "id" which in version 10 was of type "number". This must be changed to be of type VARCHAR(255) and also should not be null.
+The structure of the table '''sdmx_transaction_item''' has changed in FR 11.  This table has a column "id" which in version 10 was of type "number". This must be changed to be of type VARCHAR(255) and also should not be null.
 How you achieve this change varies depending on your database and your tool. The following commands are supplied for the following database types and are supplied for your reference.
@@ Line 139: / Line 139: @@
    ALTER TABLE sdmx_transaction_item MODIFY id VARCHAR(255)
-=== Start FMR 11 ===
+=== Start Fusion Registry 11 ===
-Your FMR database for version 11, should now contain 10 tables and you should have made the modifications specified above. It is now time to start the Tomcat that will be running FR11 and which will re-direct you to the install wizard.
+Your FR database for version 11, should now contain 10 tables and you should have made the modifications specified above. It is now time to start the Tomcat that will be running FR11 and which will re-direct you to the install wizard.
-* Start the Tomcat running your FMR version 11.
+* Start the Tomcat running your FR version 11.
-* On step 1 of the Install Wizard specify the details for your version 11 FMR database.
+* On step 1 of the Install Wizard specify the details for your version 11 FR database.
 * The Registry should now show install page 2. If it doesn't then the wrong database has been supplied.
 * On install wizard step 2 enter the "server url" and credentials password for the root user.

@@ Line 26: / Line 26: @@
 * Deploy the war file into your existing Java WebServer (e.g. Apache Tomcat).
-* Start the Java Web Server and wait for the FMR to fully deploy
+* Start the Java Web Server and wait for Fusion Registry to fully deploy
 * Using your browser navigate to the front page of FR.
 * Step 1 of the install wizard will be shown. Supply the details of your new database.

@@ Line 17: / Line 17: @@
 * Download the structures and store them safely as these will be used to upload in your Fusion Registry version 11
-You may now stop the Apache Tomcat running this instance of FMR.
+You may now stop the Apache Tomcat running this instance of Fusion Registry.
 == Starting the Version 11 Fusion Registry ==

@@ Line 83: / Line 83: @@
 View the generated file in an editor of your choice. Notepad will be sufficient for this, but feel free to use any editor you choose.
-Any occurrences of your FMR version 10 database within the file will need to be changed to reference the FMR version 11 database. It is important to change these values otherwise when you execute the SQL file it will operate against the wrong database. Once these changes have been made save the file.
+Any occurrences of your FR version 10 database within the file will need to be changed to reference the FR version 11 database. It is important to change these values otherwise when you execute the SQL file it will operate against the wrong database. Once these changes have been made save the file.
 By way of example, generating a file from SqlYog will create a file containing 3 occurrences of the FMR version 10 database. These are: