Kbase P22283: How to add more tables in an existing SQL Server Database that was pushed from progress database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/09/2008 |
|
Status: Verified
GOAL:
How to add more tables in an existing SQL Server Database that was pushed from progress database
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
MS SQL DataServer
Oracle DataServer
FIX:
Here are the steps to accomplish the task:
1. Add the table(s) in the progress database
2. Go to the Data Administration and choose PRO/SQL Menu > Dump as CREATE TABLE Statement...
3. Choose the newly added table(s) and click OK
4. Choose the appropriate SQL flavor.
If the MS SQL Server or ORACLE is chosen, two other options is
displayed. Check the appropriate option to meet your goal and click OK.
This will create a .p for tables and fields and a .i for the indexes.
Run the .p and the .i using the appropriate SQL tool in the foreign
database.
5. Connect to the schema holder and choose "Update/Add Table Definitions..." from the DataServer > MS SQL Server Utilities to pull the newly created table in the MS SQL Server Database to the schema holder.
If the fields contains the dashes in the progress database, those will converted to the underscore in the SQL Server Database so the schema holder will contain the underscore as well. In order to fix this, you need to use "Adjust Schema..." utility under the DataServer > MS SQL Server Utilities > Schema Migration Tools menu. When this utility is used both Schema holder and the original Progress Database (in step 1) needs to be connected. The Adjust schema window will have the input text box for the original progress database; the schema image will be defaulted to the connected schema image that is already connected to the MS SQL Server database. Under the file to compare, there should be an star defaulted to it but that can be changed to the tables that need to be compared. This will convert the underscore to the dashes for the tables in the schema holder that was pulled from the MS SQL Server database.