Mimer SQL Documentation PREV NEXT

Mimer Developer Site

www.mimer.com/developer


4.2 Upgrading a Mimer SQL Database


When upgrading between major versions, for example from 7.3 or 8.1 to 8.2, existing databases must be upgraded using a database upgrade utility.

The interactive method of upgrading Mimer SQL databases is by using the Mimer Administrator. Upgrade is one of the menu alternatives when right-clicking a local database.

You can also upgrade a database from a program using the ODBC routine SQLConfigDataSource.

The following C example will upgrade the MyLocalMimer database where the system administrator password is SYSPSW:

rc = SQLConfigDataSource(NULL,ODBC_CONFIG_SYS_DSN,"MIMER", 
     "DATABASE=MyLocalMimer\0" 
     "UPGRADE=-pSYSPSW MyLocalMimer\0\0"); 
 

Always remember to carry out a proper backup before upgrading a database.

Mimer SQL version 8.2 supports a number of new data types and other features, that can easily be brought into use through the ALTER TABLE statement.

See the Mimer SQL Reference Manual for further information about ALTER TABLE.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation PREV NEXT