When upgrading from Mars 7 running on SQL Server to Mars 8, there is a required database upgrade. The upgrade is performed by a script that needs to be run on the SQL Server or any networked machine that has the SQL Server Client software installed. A zip file is included in the Mars 8 installation materials or can be downloaded from the www.nbds.com website. The zip file includes several SQL command files along with a script used to perform the upgrade. The script will run all of the necessary SQL command files to perform the upgrade.
THIS UPGRADE SHOULD BE RUN ONCE AND ONLY ONCE. The database upgrade deletes and reformats several tables. Some of these operations will disable established user logins and require re-initialization of all users.
Prior to running the upgrade script, the file must be edited and the following parameters filled in as appropriate to the target database:
@SET SQLSERVER=[Your server address - no brackets]
@SET SQLDB=[Your Mars 7 database name (wmarsnet or wmars) - no brackets]
@SET LOGIN=nbds
@SET PW=mars
The LOGIN/PW entries should match the SQL Server login of the existing Mars 7 database owner.
When upgrading from Mars 7.x MS ACCESS version to Mars 8 there are two choices:
Install a blank Mars 8 database (New Install) and manually refresh the data from your host system
Contact NBDS support for a database conversion. The NBDS team can take your current ACCESS database and import the existing data to the SQL Server backup file supplied in the New Install.
