There are two ways to add a database: create a new database or attach an existing database.
Creating a New Database
The Administration Tool provides the functionality to create a basic database on the server. However, it is recommended that you create your own databases using the Enterprise Management tools that come along with your database software. This has the advantage of enabling you to fully control the preparation, deployment, and configuration of the database.
To create a new database, perform the following:
Right-click the required database registration node and select New, then click Database.
In the dialog box that appears, enter the name of the new database.
Note: You cannot use any SQL reserved keyword such as Select, Where, Break, Continue, From and so on as a database name. For example, if you use "Select" keyword as the database name, the following error message is displayed and the tool may crash: “Select:- "Incorrect syntax near keyword 'Select’" Refer to https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15 for more information on SQL keywords.
Click OK.
Attaching an Existing Database
To add an existing database, you must attach it to the new Windows Runtime environment using the Administration tool. An existing database can be:
A SQL server database
An AB Suite 2.0, 3.0, 4.0, 5.0, 6.1, or 7.0 Runtime environment database
An AB Suite 2.0, 3.0, 4.0, 5.0, 6.1, or 7.0 Runtime database to be used as a new debugger database
An AB Suite 2.0, 3.0, 4.0, 5.0, 6.1, or 7.0 debugger database created by another user to be used as a new debugger database
To attach an existing database, perform the following:
Right-click the registration node, point to All Tasks, and select Attach Existing Database.
The Attach a Database dialog box appears with a list of databases that can be attached.
Notes:
The list includes AB Suite 2.0, 3.0, 4.0, 5.0, 6.1, or 7.0 Runtime environment databases and existing SQL server databases.
Only the AB Suite Runtime database names are appended with “(AB Suite),” which are available and can be attached.
In the Attach a Database dialog box, select from the available databases list.
Click OK.
After attaching the database you can start the AB Suite system.