Database upgrades

The Commerce Server Upgrade wizard handles database upgrades. The Upgrade wizard has the options of being run automatically after installation, or run independently later. The Upgrade wizard will connect to the admin database, search for all of the Commerce Server Sites and their subsystems, and check if all of the databases schemas have been updated. If databases are found with out-of-date schemas, you can choose to update some or all of the databases. The Upgrade wizard will update all schemas and preserve all data, so there is no worry about data loss.

The Commerce Server Core .dlls know the minimum database schema versions to use. If you install a new version of Commerce Server onto one server in the farm, and then run the Upgrade wizard to update the databases, then it is likely that all other servers in the farm will be broken until the same version of Commerce Server has been installed.