Kbase P55464: How to pull new schema into schema holder after making changes within foreign db?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/04/2008 |
|
Status: Verified
GOAL:
How to pull new schema into schema holder after making changes within SQL Server?
GOAL:
How to pull new schema into schema holder after making changes within Oracle?
GOAL:
How to update existing schema holder after changes are made in foreign database?
FACT(s) (Environment):
Oracle DataServer
MS SQL DataServer
ODBC DataServer
All Supported Operating Systems
FIX:
Go into Data Administration
Go into DataServers
Select either MS SQL Server Utilities/ODBC Utilites/Oracle Utilities
Select Update/Add Table Defintions
Select appropriate tables/views or select all the tables/views (*)
This will pull all new changes that have been made to the foreign datasource into the schema holder this is because both components, the schema holder and the foreign datasource must be in sync at all times.