<< Click to Display Table of Contents >> Navigation:  Multiple Database Installation & Configuration on Single Computer > Step 2: AyaNova Database Setup

 

The steps below are for SQL Server 2005 or higher.

 

You can certainly use SQL Express 2005 or higher, but SQL Server Express Edition is NOT RECOMMENDED for shared (multi-tenant) hosting as the scale limits and memory handling do not allow it to meet the requirements of such an environment.  SQL Server Standard Edition or Enterprise Edition are the best choice for shared hosting.

 

 

NOTE: The information below is based on the assumption that you have already reviewed and are familiar with configuration  and requirements of AyaNova for network SQL use.

 

NOTE: The information below is based on the assumption that you have already performed the AyaNova Applications Setup

 

 

Create AyaNova SQL Server database:

 

1. Run the ToMSSQL as per the ToMSSQL steps in the AyaNova Help file

 

2. This creates the trial AyaNova SQL Express database AyaNova which will have its data files located in your SQL Data folder - for example C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data

 

3. Create a backup of this trial database - it is suggested that you name the backup AyaNovaTrialDB.bak so that you can easily use this trial database backup to create a new database for a new client

 

 

Continue to Set Up the Client's Database & Applications