View Issue Details

IDProjectCategoryView StatusLast Update
0004359SymmetricDSBugpublic2020-04-22 11:25
Reportergoogol4u Assigned To 
Priorityhigh 
Status newResolutionopen 
Product Version3.11.7 
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


Tagsdbexport, dbimport/dbexport

Activities

There are no notes attached to 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