Kbase P7645: Is it possible to use dash in the table/field names when using MS SQL DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Is it possible to use dash in the table/field names when using MS SQL DataServer?
FACT(s) (Environment):
MS SQL DataServer
FIX:
When a progress database is migratged to SQL server via dataserver migration utility, the table names that have hyphens in them are converted to underscores ( _ ) in the schema holder. The reason is MS SQL Server treats dash (-) as a one of special characters for internal use.
Do not manually change table names in the schema holder from underscore (_) to dash (-).