AnyDAC uses the Northwind as a demo database. SQLite and MS Access demo databases are pre installed and does not require any additional configuration. For other DBMS you have to setup connection and create a database. The AnyDAC installer contains SQL scripts, CSV data files and BAT files. The demo database may be created:

• automatically at the AnyDAC installation;
• manually any time later.

• The demo database files will be installed only, if "Sample Databases" on the "Select Components" page is checked in the installer.
• You should have an existing database and user account. The AnyDAC installer will ask this info.
• SQLite - installer installs a ready to use AnyDAC\DB\Data\ADDEMO.SDB database file.
• Access database - installer installs a ready to use AnyDAC\DB\Data\ADDEMO.MDB database file.
• SQL Server 2000 - the Northwind DB installation may be optional, because it is part of SQL Server 2000 distribution, may be downloaded separately, and may be already installed.

The AnyDAC installer may build a demo database in automatic mode:

• Mark required DBMS's on the "Demo Database" page of installer wizard.
• On the next pages fill in the database and user account info.
• At the end the installer creates a demo databases for marked DBMS's.

To build a demo database by yourself any time later, perform the following steps:

• Run ADExplorer;
• Create a connection definition for a required DBMS. The connection definition must have a predefined name, depending on DBMS:

• Goto AnyDAC\Bin folder.
• SQL Server - to disable Northwind DB installation, open Bin\createMSSQL.bat and replace True with False. For SQL Server 2000 replace MSSQL2005 with MSSQL.
• Run create<your DBMS>.bat

Database Connectivity, Defining Connection, ADExplorer, Create (DB name).bat