Kbase P76093: Errors during migration of a progress database to MSS database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/9/2004 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Errors during migration of a progress database to MSS database
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'function'.
WARNING Object Name: _TI_tablename - Type: Trigger not created!
Tables not created in SQL server by migration utility
Only need to load table defintions into SQL server, do not need to migrate 4GL app to SQL server
CAUSE:
In the tables that are affected, there is a field called "function", function is a reserved word in SQL server. so the SQL to create the table is failing and
the table is not created.
Further more, dataserver creats SQL server triggers to maintain progress_recid
column for each tale, because the table is not created, the code for creating triggers is failing also.
FIX:
Manully modify the generated SQL code, so the field name is not "function", then load the SQL into SQL server.