Kbase P5484: How to create two schema images of the same foreign database in one schema holder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/05/2009 |
|
Status: Verified
GOAL:
How to create two schema images of the same foreign database in one schema holder?
GOAL:
How to create multiple schema images of the same foreign database in one schema holder?
GOAL:
How to create two identical logical databases in one schema holder that points to the same foreign database
FACT(s) (Environment):
MS SQL DataServer
ODBC DataServer
Oracle DataServer
All Supported Operating Systems
FIX:
Here are the steps to accomplish this:
1. Connect to the schema holder
2. Dump the .df from the current schema image.
Please note that there is no need to be connected to the foriegn database when dumping. All you have to do is make sure the foreign database within the schema holder (under Data Admin/Databases/Select Working Database) is selected.
3. Open the .df file
4. Change the logical name in the .df file under the following section:
Example:
ADD DATABASE "oratest" TYPE ORACLE
ADD DATABASE "msstest" TYPE MSS
ADD DATABASE "odbctest" TYPE ODBC
5. Save changes to new .df file
6. Load the new .df file into the current schema holder
This allows you to have identical schema images with different names (connecting to the same foreign database) in one schema holder.