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...")
 
Line 1: Line 1:
 
[[Category:How_To]]
 
[[Category:How_To]]
 
=Renaming Registry Database=
 
=Renaming Registry Database=
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 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 previously installed information in it, the Registry will detect this and simply load the remainder of the configuration from the database.
 
 
=Renaming a Data Store=
 
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.
 

Revision as of 04:29, 4 November 2020

Renaming Registry Database

The Registry database (the master database) information is stored in the 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 previously installed information in it, the Registry will detect this and simply load the remainder of the configuration from the database.