Database Administration
 		Previous Topic  Next Topic 


CutLogic 1D uses for its data Firebird database. It brings new features in terms of security, reliability, networking and data management into the program. This chapter describes how to maintain the data and the users.



Data backup and restore


To maintain the data select the menu item "Tools > Database > Data".



Following Database Administration form opens in new window:



Automatic backup of the data


Automatic backup allows you to define frequency of creation the backup files. Check one or more options in "Automatic Backup" area to match your backup strategy.


NOTE! Automatic backup works in the time loop. If you chose, for example, hourly backup only, system automatically creates new backup file every hour. After 24 hours new backup file replaces the oldest backup file, so that the oldest available backup file can not be older than 24 hours.



Manual backup and restoration of the data


You can backup or restore your data anytime as you need.



Send backup


You can send your data via email for inspection in case of any damage or other purpose to our support department.



Embedded versus Network mode of CutLogic 1D


The CutLogic 1D works after the installation with embedded Firebird database. You do not have to install database separately - it is essential part of the program. However the data saved in this embedded database is not available for other users and can not be shared. Only way how to share the data is to install the Firebird database and switch the CutLogic 1D to the network mode.



Changing CutLogic 1D to the network mode


To switch the program to the network mode, select the menu item "Tools > Database > Server" and click the button [Change].



Fill in computer name or IP address where Firebird SQL server is installed and click the [OK] button.

Program automatically restarts and new Login dialog box appears:



Fill in user name and password and click the [OK] button to start the program.


NOTE! Firebird SQL server contains default user "SYSDBA" with default password "masterkey". You can use this default user for login into CutLogic 1D or create new users and assign them as is described farther in this chapter.


See also Network Installation.



Maintaining the users


CutLogic 1D has to work in network mode to allow working with users and showing the statistics.



To add new user, select the menu item "Tools > Database > Users" and click the button to add new user.



Fill in the user name and the password, confirm the password and check the Access to CutLogic 1D option and click the [OK] button.



Statistics


The program allows showing Firebird database statistics. This feature can be useful especially for database administrators.


To show the statistics, select the menu item "Tools > Database > Stats" and click the [Show stats] button.



Click the [Show full stats] button to get detailed statistics.