What the Schema Update Utility Can Handle Automatically
You must examine the alter script before you run it. Decide what changes to make manually and what changes to make using the script, taking into account the kind of data in the tables. Entries that could result in data loss are commented. Remove or comment entries for changes you will make manually.
Adds
The schema migration utility handles addition of entity types and attributes. New entity types and attributes are added to the database schema.
- Changes (Drop and Add) — Assess individually
- The utility handles changes to attributes (entity properties) as DROP and ADD operations. However, DROP operations are commented in the script to avoid data loss.
- Entity Deletions
- If an entity is deleted from the TIBCO BusinessEvents Studio project, the corresponding tables are not dropped from the database schema. Existing data is not lost. Deleted entities are not mentioned in the alter script. Manually keep track of and delete such tables as needed.
- Attribute Deletions
- The schema update utility does handle deletion of entity attributes. SQL statements for deleted attributes are generated but they are commented. Examine the alter script and enable these commands if you want to execute them. Note that existing data is lost when you drop an attribute
Example Alter Script
Below is an example yourname_alter.sql script.
- Property type change
-
-- ##### WARNING : Non-alterable Ontology changes found. Please see following errors. Manual schema-migration is required. --* For Concept Concept1 field PROPERTY_1 type changed from VARCHAR2 to LONG -- ALTER TABLE D_Concept1 DROP ( Property_1 ); ALTER TABLE D_Concept1 ADD ( Property_1 numeric(19) ); New table DROP TABLE D_Book_rrf; CREATE TABLE D_Book_rrf (pid numeric(19), propName char varying(255), id$ numeric(19) not null); New property -- ALTER TABLE D_MyConcept DROP ( FOLDER_1 ); ALTER TABLE D_MyConcept ADD ( Folder_0 char varying(255) );
Copyright © TIBCO Software Inc. All rights reserved.