Unloading the Database

Changing the Database

Loading the Database

---

Setting Up the Database

The following document guides you through changing the databaseA database is an organized collection of data including relevant data structures. and setting up a new one.

Please refer to the advices of performance optimization before setting up the database (Configuration & Performance of the Database).

All the described working  steps refer to the installation of the MS SQL Server. Apply the adequate utilities and functions for Oracle or DB2 if these databases are used. Oracle uses two tablespaces (UC4_DATA and UC4_INDEX).

For Oracle Automic strongly recommends using the tablespaces UC_INDEX and UC_DATA only, as otherwise you would have to manually adjust all SQL files during an update process.

	1.	Requirements

• DB computer
• MS SQL Server must be correctly installed and ready to run
• Installation settings:
• Use standard code page
• Standard Sorting, case insensitive (alphabetical order, regardless of case)

	2.	Creating directory structure and starting the SQL Server

• DB computer
• Create directory structure \AUTOMIC\DB
• Start SQL Server if it has not already been started (ServiceManager)

• DB computer
• Start the SQL Server Database Management Program
• Create the new database "AE". The size of the transaction log should be about 25% of the data-file size (for test systems with truncate log).

	4.	Creating the Data Source

• Admin computer
• Create data source "AE" for ODBC access (64 bit ODBC)