Kbase P123695: How to change EasyAsk dbms
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/05/2007 |
|
Status: Unverified
GOAL:
How to change EasyAsk dbms
GOAL:
How to change from Oracle database to SQLServer database
FACT(s) (Environment):
EasyAsk
FIX:
In order to change an EasyAsk dictionary from one dbms to another, do the following:
1. Create regression test for validating dbms changes.
2. change the dictionary properties/connection values to new values
3. go to dictionary properties/general and choose the clear tab to clear the default qualifier and default owner
4. change the dictionary properties dialect to new value
5. Save and close the dictionary
6. open the dictionary and change the default qualifier and default owner as appropriate.
7. Save and close the dictionary
8. open the dxp in notepad and verify that table names have the correct database qualifier and default owner. Manual editing may be required.
9. Any Easyask defined formulas will be redefined when the dictionary is opened. Any user defined formulas will need to be manually changed to meet the SQL rules of the new database.
10. Open the dictionary and re-validate links.
11. Run regression tests to verify searches are working correctly.
These instructions assume that the 2 database schemas are alike. If different, more changes may be needed.