Setting Up the Database

Changing the Database

ServiceManager

---

Loading Database

Many versions of SQL scripts and databaseA database is an organized collection of data including relevant data structures. files are provided on the delivery directory. You will find them in the subdirectory of IMAGE:DB. If <vers> is specified in this document, select the appropriate folder of the Automation Engine version that you are using. If there is no separate folder of your version, the database structure has not been changed since the last version. In this case, you can use the previous version.

Example:
You are using the Automation Engine version 11.0.0 and the MS SQL server 8.0.
In this case the appropriate directory is IMAGE:DB\SQL_8\11.0.0.

	1.	Copying files for loading the database

• Admin computer
• Copy all subdirectories from IMAGE:DB to \AUTOMIC\DB.

	2.	Loading database structure

• Admin computer
• Start the SQL Query Analyzer and select your newly created database.
• Now open the file \AUTOMIC\DB\SQL_8\<vers>\UC_DDL.SQL and execute it.

	3.	Loading the current database

• Admin computer
• Change the ODBC data source to the new database.
• Enter the connection information of the new database to the INI file of the utility AE DB Load. The passwordA secret combination of characters for a Automation Engine user. can be encoded with the program UCYBCRYP.EXE.
• Then start AE.DB Load and select the previously unloaded file (from the database used up to now - standard: \DB\UC_DATA.TXT).
• The loading process depends on the size of the database.
• Now enter the new database in the INI files of the other utilities and Automation Engines.

Possible Problems

• The code conversion was not set correctly when setting up ODBC access. Correct: No code conversion takes place.