Difference between revisions of "Change Database"

From FMR Knowledge Base
Jump to navigation Jump to search
(Created page with "Category:How_To =Renaming Registry Database= The Registry database (the master database) information is stored in the Registry_Properties_File|Fusion Registry properties...")
 
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
[[Category:How_To]]
 
[[Category:How_To]]
−
=Renaming Registry Database=
+
[[Category:How_To V11]]
−
The Registry database (the master database) information is stored in the [[Registry_Properties_File|Fusion Registry properties file]].  If the database name has been changed, or the connection details modified, the properties file can be manually edited to change the connection details accordingly. If the password has changed, the properties file can be deleted, and the Registry will redirect to the install page once the application server has been restarted.  If you are unsure how to edit the properties file, a safe option is to simply delete it and allow the Registry to reinstall itself.  On install if the Registry is connected to a database with previouly installed information in it, the Registry will detect this and simply load the remainder of the configuration from the database.
+
The database details are configured via the Database option on the Settings Menu. You can use this option to change the Database but be aware that the Registry database information is stored in the Registry properties file.
  
−
=Renaming a Data Store=
+
If the database name has been changed, or the connection details modified, the properties file can be manually edited to change the connection details accordingly.
−
If a database containing data has had its connection details modified, the Fusion Registry database 'sql_data_source' can be directly modified - after which the application server should be restarted.
 
−
 
 
−
Another approach is to log into the Fusion Registry as an administrator, navigate to the datasources page, and edit the data source to change the connection details.
 

Latest revision as of 06:48, 5 September 2022

The database details are configured via the Database option on the Settings Menu. You can use this option to change the Database but be aware that the Registry database information is stored in the Registry properties file.

If the database name has been changed, or the connection details modified, the properties file can be manually edited to change the connection details accordingly.

Retrieved from "https://fmrwiki.sdmxcloud.org/index.php?title=Change_Database&oldid=6369"