Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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.

dbwizard.8.8.upgrade

  1. Select Upgrade next to the name of the database you wish to upgrade.
  2. The next dialogue requires you to enter your SQL information:

    dbwizard.8.8.upgrade.credencials

    The upgrade operation is quite similar to how you create a new database.

  3. Choose the network database server you want to upgrade to. Alternatively, type the Hostname or the server IP-address.
  4. Choose between Windows NT Authentication or SQL Server Authentication, depending on how the database server is configured.
  5. Enter a username to log on with.
  6. Enter the password for the username.
  7. Select Next.
  8. 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).
  9. Once you've made your snapshot selection, click Yes, I'm aware of the above and Next:
  10. dbwizard.8.8.upgrade.snapshot

    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.

  11. Verify that the selected settings are correct and click Start to begin the update:
  12. dbwizard.8.8.upgrade.start

  13. Then, select Yes:

  14. Upgrade_database_proceed

  15. Select Next:

dbwizard.8.8.upgrade.complete

The Bizview application is dependent on initially preloaded data. The next dialog asks you to update the application database base-data.

  1. 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\

dbwizard.8.8.upgrade.preloaded

To install / upgrade this data, follow the steps below:

  1. Select the Data script to run (named bizview_<version>_data.sql).
  2. Select Run to load preloaded data into the database:
  3. dbwizard.8.8.upgrade.preloaded

    The next dialogue gives you a summary of updated rows.

  4. Select Close:
  5. dbwizard.8.8.upgrade.preloaded.result

  6. Finally, select Finish.

Congratulations, you have now successfully upgraded a Bizview database!

Next step:Upgrading an Existing Bizview Datastore

Published:

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.

dbwizard.8.8.upgrade

  1. Select Upgrade next to the name of the database you wish to upgrade.
  2. The next dialogue requires you to enter your SQL information:

    dbwizard.8.8.upgrade.credencials

    The upgrade operation is quite similar to how you create a new database.

  3. Choose the network database server you want to upgrade to. Alternatively, type the Hostname or the server IP-address.
  4. Choose between Windows NT Authentication or SQL Server Authentication, depending on how the database server is configured.
  5. Enter a username to log on with.
  6. Enter the password for the username.
  7. Select Next.
  8. 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).
  9. Once you've made your snapshot selection, click Yes, I'm aware of the above and Next:
  10. dbwizard.8.8.upgrade.snapshot

    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.

  11. Verify that the selected settings are correct and click Start to begin the update:
  12. dbwizard.8.8.upgrade.start

  13. Then, select Yes:

  14. Upgrade_database_proceed

  15. Select Next:

dbwizard.8.8.upgrade.complete

The Bizview application is dependent on initially preloaded data. The next dialog asks you to update the application database base-data.

  1. 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\

dbwizard.8.8.upgrade.preloaded

To install / upgrade this data, follow the steps below:

  1. Select the Data script to run (named bizview_<version>_data.sql).
  2. Select Run to load preloaded data into the database:
  3. dbwizard.8.8.upgrade.preloaded

    The next dialogue gives you a summary of updated rows.

  4. Select Close:
  5. dbwizard.8.8.upgrade.preloaded.result

  6. Finally, select Finish.

Congratulations, you have now successfully upgraded a Bizview database!

Next step:Upgrading an Existing Bizview Datastore

For an optimal Community experience, Please view on Desktop
Powered by Zendesk