Following situation

You have already a running version 4.6.x or you have to install a new version 4.6.x and you noticed, that the configuartion settings are wrong.

You have to repair or to rebuild this part from your database and you would like use in addition your original or let say backup database from your system before.

In my following description is the name of your backup original database "Testconfig".


Conditions

  • you must have the possibility to edit your SQL server and databases with Microsoft Management Studio
  • the database was converted already to an SQL database (if the source data was from MDB, but runs minimum with version 4.5.x.)
  • you must "Attach" your original database (via mdf file) or "Restore" (via bak file) on your SQL server


Solution

  • edit your database version 4.6.x with SQL Management Studio please
  • go to the Tables via Object Explorer Details and delete all dbo.Cfg - tables, so the damaged configuration settings will be deleted now. All the other parts of this database will keep the values and settings.
  • afterwards start custodiagnostic again. Now SQL system will create new empty dbo.Cfg - tables!



  • please start the CSC of version 4.6.x, this database where you would like import the configuration from the backup database and go to the point "Database" \"Import Database"
  • go to right side in the CSC to "Add data source" and click the button "Add SQL-Server"
  • please fill out all fields to connect the instance where your backup database (Testconfig) runs and check the connection. After a successful connection continue at "OK"



  • now you get the next constellation:


  • first mark the uninteresting line and click button "Remove data source"
  • next mark the intresting line "Config" and click the button "config data source settings"
  • if you edit nothing on the source settings, then all selected points will be overtake for the import to your running database version 4.6.x

  • click "OK" on picture 1 and press the button "Start Import" in the CSC right below




  • After displayed 100 % on the bar, you can close the CSC and restart your current version 4.6.x