View Issue Details

IDProjectCategoryView StatusLast Update
0004359SymmetricDSBugpublic2024-01-25 19:11
Reportergoogol4u Assigned Toemiller  
Priorityhigh 
Status closedResolutionduplicate 
Product Version3.11.7 
Target Version3.14.1Fixed in Version3.14.1 
Summary0004359: The handling of ''(empty string) default value of varchar columns of dbexport and dbimport is not correct for mssql server
DescriptionWhen using dbexport to export the structure of a mssql database and then dbimport it to another database, if the default value of a varchar columns is '' (empty string), this value could not be passed to the new database schema. Instead, the default value for this kind of column is not defined.

the database is mssql 2008 R2 and jtds is used for jdbc driver.

Steps To Reproducedbexport --properties xxxx.properties --no-data --format XML > db.xml


dbimport --properties yyyy.properties --format XML db.xml


Tagsdbimport/dbexport

Relationships

duplicate of 0004090 closedemiller Firebird ddl/schema problem when creating tables and deferring constraints 

Activities

emiller

2022-09-08 19:34

developer   ~0002186

The fix for issue 4090 also resolved this issue.

Issue History

Date Modified Username Field Change
2020-04-22 11:08 googol4u New Issue
2020-04-22 11:24 googol4u Tag Attached: dbexport
2020-04-22 11:25 googol4u Tag Attached: dbimport/dbexport
2022-09-08 19:34 emiller Assigned To => emiller
2022-09-08 19:34 emiller Status new => closed
2022-09-08 19:34 emiller Resolution open => duplicate
2022-09-08 19:34 emiller Fixed in Version => 3.14.1
2022-09-08 19:34 emiller Note Added: 0002186
2022-09-08 19:34 emiller Relationship added duplicate of 0004090
2024-01-25 19:11 elong Tag Detached: dbexport