Kbase P149448: Progress no initial value Is Migrated to SQL Server with no "Default" Clause by Delta SQL tool
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/27/2009 |
|
Status: Unverified
SYMPTOM(s):
Progress no initial value is migrated to SQL server as null by Delta SQL tool
The Delta tool creates SQL statement like following with no "Default" clause
ALTER TABLE dbo.tablename ADD
string1 VARCHAR(16)
These fields with no "Default" clause will show as unknown (?) when queried
FACT(s) (Environment):
No initial value set for character field in Progress in delta df
Delta tool is run to generate delta SQL
OpenEdge 10.x
CAUSE:
This is expected behavior.
When no initial value is specified in Progress dictionary, delta tool does not generate "Default" clause. SQL server consider a field with no "Default" being unknown therefore the field is pulled back as "?"
FIX:
If desiring empty string "" instead of "?", the delta sql can be altered to be like following
ALTER TABLE dbo.tablename ADD
string1 VARCHAR(16) DEFAULT '' WITH VALUES
go