How do I set up multiple databases under ROADS version 1?
First it is important to remember that there is no support for real multiple databases under ROADS version 1. However you can enable multiple logical databases by making use of the ‘Destination’ attribute in ROADS templates. The following steps should get things going. Essentially the value of the ‘Destination’ attribute is the ‘name’ of the logical database. For the purposes of this example we’ll assume that all records will go into one of two logical databases, ‘Biology’ or ‘Biochemistry’. • Make sure that there is a ‘Destination’ attribute listed for every template type in the ‘config/outlines’ directory. • Update any existing records in your database, giving them each a ‘Destination’ attribute value of either ‘Biology’ or ‘Biochemistry’. • It is important to remember that there is no way of explicitly searching for records with an empty ‘Destination’ attribute (though you can search for ‘ALL’ records) so normally you will want to add a ‘Destination’ to every record that you create.
Related Questions
- After upgrading SQL Server version 6.x databases to SQL Server 7.0 using the automatic configuration option, the resulting SQL Server 7.0 databases are smaller than their SQL Server 6.x counterparts. Does this mean that there was a problem with the upgrade?
- Can my database applications access databases that I migrated to DB2 Version 9.5?
- How do I set up multiple databases under ROADS version 1?
