Dev Hound can use either its built-in database TurboDB or SQL Server. The TurboDB database has the advantage of only consuming a small amount of resources, is compact, doesnt require additional installation or configuration and can be used on externally hosted windows boxes that do not support databases. Converting to SQL Server has the advantage of the solid support provided by Microsoft as well as speed enhancements and options for futher integration and access from other products (eg Crystal decisions or custom applications).
To convert your existing database to SQL Server first make sure you have MDSE or the full SQL Server installed on your PC. It is possible to have Dev Hound create a database on a different PC to your web server however this is not recommended for speed reasons.
You can change the data provider back to TurboDB at any time and resume using your old database however any data entered into the SQL Server database will be lost
If you have previously created multiple databases in Dev Hound it is possible convert all of these to SQL Server database but it is not automatic (yet). You will need to be familiar with SQL Server. First convert your main database to SQL Server and rename the devhound SQL Server database to something else. Then move one by one the file devhound.tdbd from the subfolders of the data folder. Click the Upgrade button to convert the database again and recreate the devhound SQL Server database. Rename the SQL Server database to an appropriate name. Repeat the process for each database then rename your original devhound SQL Server database as devhound. This process can be time consuming and requires some skill - if required please email Nexus Concepts for help
Dev Hound can access multiple Dev Hound databases either with TurboDB or SQL Server. These multiple databases are stored on the same server PC. To create a new blank database:
Converting to SQL Server
To convert your existing database to SQL Server first make sure you have MDSE or the full SQL Server installed on your PC. It is possible to have Dev Hound create a database on a different PC to your web server however this is not recommended for speed reasons.
- Click Start -> Programs -> Dev Hound -> Configuration
- Click on the Database tab
- Change the Data Provider from TurboDB to SQL Server
- Click on the Settings button and provide the SQL Server settings and click Apply
- Click on the Upgrade button and click on Next
- Your existing database will be converted to SQL Server
- You will need to restart the Web Server
Reverting from SQL Server back to TurboDB
You can change the data provider back to TurboDB at any time and resume using your old database however any data entered into the SQL Server database will be lost
Converting multiple databases
If you have previously created multiple databases in Dev Hound it is possible convert all of these to SQL Server database but it is not automatic (yet). You will need to be familiar with SQL Server. First convert your main database to SQL Server and rename the devhound SQL Server database to something else. Then move one by one the file devhound.tdbd from the subfolders of the data folder. Click the Upgrade button to convert the database again and recreate the devhound SQL Server database. Rename the SQL Server database to an appropriate name. Repeat the process for each database then rename your original devhound SQL Server database as devhound. This process can be time consuming and requires some skill - if required please email Nexus Concepts for help
Multiple Dev Hound Databases
Dev Hound can access multiple Dev Hound databases either with TurboDB or SQL Server. These multiple databases are stored on the same server PC. To create a new blank database:
- Click Start -> Programs -> Dev Hound -> Configuration
- Click on the Database tab
- Click on the New button
- Enter a database name and click Next
- An empty Dev Hound database will then be created