AnyDAC Demo Databases

From RemObjects Software

This is a general AnyDAC topic
Feel free to add your notes to this topic below.

1 General
2 Prerequisites
3 Automatic installation
4 Manual installation

General

For demo purposes, AnyDAC uses the Northwind database. AnyDAC installer contains scripts, CSV files with data and BAT files to build demo database for any DBMS supported by AnyDAC. The demo database may be created automatically as part of the AnyDAC installation process or manually any time later.

Prerequisites

The demo database files will be installed only, if in installer is checked "Sample Databases" on "Select Components" page.
You should have created the database and the user account. For details, talk to your database administrator, or consult to the DBMS manual. AnyDAC installer will use this info to create DB object.
For MS Access AnyDAC installer will install ready-to-use MDB database file.
For MS SQL Server you, probably, does not need to install demo database, because Northwind DB may be already installed.

Automatic installation

The AnyDAC installer can build demo database in automatic mode. To do that using installer:

Mark required DBMS's on the "Demo Database" page of installer wizard.
On next pages you will be asked for each marked DBMS the database and the user account info. Installer will create a connection definition using this info.
At end of installation process, AnyDAC will create demo databases for marked DBMS's.

Manual installation

To build demo database by hands, perform following steps:"

Run ADExplorer
Create a connection definition for each required DBMS. The connection definition must have the predefined name, depending on DBMS:
- for Sybase ASA -> ASA_Demo
- for IBM DB2 -> DB2_Demo
- for Interbase/Firebird -> IB_Demo
- for MS Access -> Access_Demo
- for MS SQL Server -> MSSQL_Demo
- for MySQL -> MySQL_Demo
- for Oracle -> Oracle_Demo
Goto AnyDAC\Bin folder.
Run there appropriate create<your DBMS>.bat