Release notes regarding the sql database for BSS Client 2.0.0.28
----------------------------------------------------------------

INTRODUCTION
============
This version (2.0.0.28) of the BSS Client software needs a new database definition,
it will not work propery with the database definition of the previous versions.
To prevent loss of data, a conversion tool is provided to migrate from the previous
database definition to the new version.


WHEN CREATING A NEW DATABASE
============================
Follow the procedure as described in the Installation guide of the BSS Server
application. The CreateDatabase utility uses an SQL script to generate the database
structure. For the new version, we have provided a new SQL Script: 
"BssSqlScript_28.sql". Use this file when creating a new database for the 2.0.0.28
version of the client.


WHEN CONVERTING
===============

About the tool
--------------
In this folder, you will find a program "BssConvert.exe". This is the conversion
program. It will perform a two-phase action to convert the database.
In the first phase, it makes the necessary changes to the database definition, as 
defined in the sql script file "BSSDBMigrateTo28.sql" (present in the same directory).
In the second phase, the data present in the tables is recreated to suit the new
database definition.

How to use the tool
-------------------
Run the program BssConvert.exe, the application window comes up. 
Fill in the Data Source Name (DSN), SQL Server Name, the name of the existing Database,
Username and password.
At last, fill in the complete path to the SQL Script for conversion (this 
is "BSSDBMigrateTo28.sql"). You can use the "..." browse button to locate the file.
Click the "Run" button to start the conversion.
Note: The conversion tool can only be run on a system where SQL Server or 
      SQL Server Client is installed. And, as this tool makes use of one of the 
      components installed by the BSS Server application, this tool can only be used
      on a system where the BSS Server application is installed.

