• Created by Unknown User (baldauf), last modified on Oct 22, 2018

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »


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 have attached your original database (via mdf file) or restored (via bak file) on your SQL server


Solution

  • connect your currently faulty database with the 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.
  • start your currently version (4.6.x). Now the system will create the new empty dbo.Cfg - tables



  • please start the CSC of version 4.6.x, this database where you would like import the configuartion 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 unintrested line and click button "Remove data source"
  • next mark the intresting line "Config" and click the button "config data source settings"
  • did you edit nothing, so all selected points will be overtake for the import to your running database version 4.6.x
  • click ok in windows 1 and press the button "start Import"

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


  • No labels