Upgrading an Existing Bizview Application Database
This topic describes the process for upgrading an existing Bizview application database.
The Bizview databases specified in the opened web.config are shown in the dialogue below. Here, you have the option to upgrade each specific database according to your needs.
- Select Upgrade next to the name of the database you wish to upgrade.
- Choose the network database server you want to upgrade to. Alternatively, type the Hostname or the server IP-address.
- Choose between Windows NT Authentication or SQL Server Authentication, depending on how the database server is configured.
- Enter a username to log on with.
- Enter the password for the username.
- Select Next.
- In the next dialogue, choose which database to upgrade (the database selected in previous dialogue is pre-selected) and what snapshot version to use (what version should the database be upgraded to).
- Once you've made your snapshot selection, click Yes, I'm aware of the above and Next:
- Verify that the selected settings are correct and click Start to begin the update:
Then, select Yes:
Select Next:
The next dialogue requires you to enter your SQL information:
The upgrade operation is quite similar to how you create a new database.
Note: If you click Update data instead of Next, the database will then be updated with base data, using the preloaded data script. This option is only for circumstances when you wish to reload the application base data alone. The database must be up-to-date already! This step will also appear after Upgrade DB which is the natural process.
The DBWizard now starts a comparison between the target database and the snapshot selected. Nothing is actually upgraded yet.
The Bizview application is dependent on initially preloaded data. The next dialog asks you to update the application database base-data.
Click Finish instead of Run if you don't want to run the script. You can run the script in Management Studio by opening the path C:\Program Files\NCG Group\Bizview\DBWizard\PreloadData\
To install / upgrade this data, follow the steps below:
- Select the Data script to run (named bizview_<version>_data.sql).
- Select Run to load preloaded data into the database:
- Select Close:
- Finally, select Finish.
The next dialogue gives you a summary of updated rows.
Congratulations, you have now successfully upgraded a Bizview database!
Next step:Upgrading an Existing Bizview Datastore