Assigning different schemas to user databases
If you want to change the schema that a database uses,
you must first create a new database, move your existing data, and
then associate that database with the new schema.
Before you begin
Procedure
To create a new user database to prepare for a schema change:
- Start the Designer.
- In the Schema Repository Explorer view, right-click on a schema repository and click The New Database wizard opens. .
- On the Database Name and Vendor page, choose a Logical Database Name, select a Database Vendor, and record any Comments about the database.
- Select a Database Type, either Production Database or Test Database.
- Click Next.
- The options on the next page of the wizard will vary depending on the database vendor you chose. Complete the information required for your chosen vendor and then click Next.
- On the Database Timeout Option page, select the Timeout and Poll Interval for the new database, and then click Next.
- On the Initial Schema Revision page, select the schema version that you want to associate with the new database.
- Click Finish.