Kbase P24793: How to update SQL dataserver schema with new tables originated from Progress but having field names
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to update SQL dataserver schema with new tables originated from Progress but having field names with dashes not underscores?
FACT(s) (Environment):
Progress 9.1B
Progress 9.1C
Progress 9.1D
MS SQL DataServer
FIX:
1. Migrate progress database again to SQL Server
OR
2.
(1) Generate SQL statements for the new tables
(2) Run SQL files against MS SQL Server which will create the tables, indexes etc
(3) Use add/update utility to update SQL dataserver schema
(4) Use adjust schema utility to sync the schema holder with Progress database