First time installations

SQL Server 2008 must be available or newly installed on the PC for this operation

• Copy the file StatusSetup.exe and AvdatadbSQL.exe into a network shared installation directory.  This directory must be available to all stations that will use Status.  Installation of this file from this directory, will set the path in the registry to this directory for easy future updates.
• Install StatusSetup from the above directory on the Server machine
• Install Avdatadb2SQL on Server machine
• Select a directory where the database file will be created or copied.  The default that will be configured by this installation is:
  c:\programdata\avdata\sql
  The default directory used by SQL server is:
  c:\Program Files\Microsoft SQL Server\MSSQL10.SQLExpress\MSSQL\DATA
  Different installations might have different paths to fit into their backup system, change the registry setting to your specific requirements.

If a database was provided

• Copy files adbStatus.mdf and adbStatus_log.ldf into the default directory c:\programdata\avdata\sql
• This can be moved by experienced users by changing the HKCU\Software\Avdata\Path_SQL to another directory in the registry.  Note that the directory key must end with the '\' character
• Check that the file adbStatus.mdb is in the default install directory as selected above
• This can be moved by experienced users by changing the HKCU\Software\Avdata\Path_Install to another directory in the registry. Note that the directory key must again end with the '\' character
• Run the program StatusSQL from the menu
• Connect to the server
• Select Create, which will attach the database, adbStatus, to the SQL Server
• Register online for the license key by using your unque Client ID and password to connect

If no database was provided and upgrade from dBase is required

• Check that previous installation of dBase Status is on the installation PC and that all the file structures are up to date.
• Experienced users can ensure that the registry entry HKCU\Software\Avdata\Path_Data points to the path of the dBase file directory on the installation machine.
• Run the program db2SQL from the menu Convert dBase to SQL.
• Connect to the server with a power user from the menu File|Connect
• Select the Create button to create the database adbStatus in the default directory c:\programdata\avdata\sql
• This can be moved by experienced users by changing the HKCU\Software\Avdata\Path_SQL to another directory in the registry.  Note that the directory key must end with the '\' character
• Create the file structures from the menu File|Convert dBase 2 SQL
• Select: Status
• Select: Load database
• Select: SQL
• Select: Populate
• Close the window and proceed if there were no errors.
• Create the procedures from the menu File|Stored Procedures
• Select: Status
• Select: Open catalog
• Select: Import
• Close the program
• Run the program StatusSQL from the menu
• Connect to the server if required
• Register online for the license key by using your unique Client ID and password to connect

Users Experienced with SQL Server and Management Studio

• Create an empty database adbStatus and give BUILTIN\Users db_owner access to the database
• Connect to the empty database with the db2Sql convertion program and follow the steps above

OR if adbStatus database files were provided

• Copy the database files into the server directory
• Attach the database to the SQL Server
• Open StatusSQL and configure the login from each station

Additional users

• Install StatusSetup on the PC.  Run the setup file StatusSQL from the directory on the server as defined above.   This will set the registry path for future installations.
• This can be moved by experienced users by changing the HKCU\Software\Avdata\Path_Setup to another directory in the registry.  Note that the directory key must end with the '\' character
• Run StatusSQL from the Start menu
• Connect to the server
• Use the program