Products
  
  
  Crash Magic Online
  
  Intersection Magic
  
  Map Magic
  
  Knowledge Base
  
  
  
  Contact Us
  
  Meeting
  
  Shop
  
  Login
  

 

Knowledge Base Article:CMO219 


Registration keys moved to client area: Select login on the left menu bar.

Knowldegebase:
Search home page  

Upgrading the Crash Magic Online system tables

Article created: Apr 28 2010, updated: Apr 28 2010

Background:  Changes to the Crash Magic system tables may be required as new features are added to the software.

Status:  Info - "how to" article
Keywords:  upgrade,system,tables
Categories:   *Installation and setup* *Configuration* *Data*

Explanation:
Crash Magic stores configuration and user information in system tables. These tables are created when Crash Magic is first installed. As Crash Magic acquires new features additional system tables and other changes may be required to support these changes.

Solution:

The Crash Magic configuation editor is designed to make the required changes to the database schema. These steps should be performed by the database administrator.

Before beginning completing and upgrade of the Crash Magic system tables, ensure that you have completed the following:

  • Backup the Crash Magic system tables. This process will make changes to the Crash Magic system tables. A tested backup is required in case of failure.
  • The Service or application pool that is running Crash Magic is stopped.
  • Confirm that the current database drivers are installed on the server.

Check the status of the Crash Magic system tables:

  1. If the Crash Magic configuration editor screen is not open, then select Crash Magic configuration editor under Start/Programs/Pd Magic.
  2. Click on your configuration name displayed in the area on the left.
  3. Click on the SYS Database tab.
  4. Click the Maintain Database button.
  5. The status box at the bottom of the Crash Magic Configuration - Database Maintenance window will show red when the updates are needed, and the first line will read "Schema matches: False".

Update the login information if needed.

  1. With the Crash Magic Configuration - Database Mainteneance window open from the previous step click on the Updates tab.
  2. Change the login, password, role and role password if required to the owner of the Crash Magic system table schema.(This is required only if the Crash Magic system user is different than the owner. In most cases they will be the same.)

Generate the update script:

  1. With the Crash Magic Configuration - Database Maintenance window open.
  2. Click on the Compare and update schemas ... button.
  3. Enter the tablespace name in the "Tables namespace" box where the system tables are being stored in the (Leave blank to accept the default location from your database).
  4. Enter the tablespace name in the "Index namespace" box where the system tables are being stored in the (Leave blank to accept the default location from your database).
  5. If the Crash Magic system user is different than the owner, enter the name of Crash Magic system table user in the "Grant SELECT to" box(In most installations the user is the owner, and this can be left blank.).
  6. If the Crash Magic system user is different than the owner, enter the name of Crash Magic system table user in the "Grant Insert, update, delete to" box(In most installations the user is the owner, and this can be left blank.).
  7. Click the OK button to create the script

Execute the changes.

  1. Review the script that was created in the previous step.
  2. Database Administrators have the option of clicking the Execute Script button or copy the script to run from another envirnoment.
  3. Click the OK button when done.
  4. Click the Done button to close the script window.
  5. The status window should now refresh to a green and the first line will read "Schema matches: True".

Changing table structures for the Crash Magic system tables is not supported, but Database Administrators can add additional storage parameters.


January 21, 2018 5:09PM

© 1999-2018 Pd' Programming, Inc - Lafayette, CO USA