View Issue Details

IDProjectCategoryView StatusLast Update
0004359SymmetricDSBugpublic2022-09-08 19:34
Reportergoogol4u Assigned Toemiller  
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 --no-data --format XML > db.xml

dbimport --properties --format XML db.xml

Tagsdbexport, dbimport/dbexport


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



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