Database Schema Upgrading

At startup the WorkflowFirst application will compare the current schema of the database with the required schema, create a script to update the database schema and then run that script. 

This update of the database schema will run automatically if you are upgrading to a newer version, and even if you are downgrading to an older version. Simply running the older version will automatically downgrade the database to the version and schema it expects.

Note: If you are downgrading to an older version, the database schema update may involve deleting some columns and tables. If you are concerned about data loss before downgrading, please back up the content of your database.

Note: In MongoRAD, only indexes are created or deleted at startup, collection data itself is not changed as MongoDB is a schemaless database. 

This operation occurs when the application is first run after a publish, and while the text 'Please Wait' is displayed on the screen. The scripts can sometimes be quite complex but this rarely causes any significant delay at startup, or any problems. 

If you are using Microsoft SQL Server, because this server runs as a separate process there may be some times when this operation fails. If this occurs then a different screen will be displayed instead of the application screen, and it will call on the user to contact the system administrator. 

If this does occur there are two possible options to pursue:

  • Review the recent changes to the data model. Undo those changes and republish to see if the system now starts. 

  • Contact RiaForm Support for assistance. 

In either case it's recommended that you contact RiaForm Support to notify them of the problem so it can be remedied or handled better in a future release.


Next Topic:
v4.2.0.956 (beta)
Up Since 2/29/2024 12:02:23 AM