I am trying to migrate the content for our teamcity server (3.1.1 enterprise license) from hsqldb to MySql. I ran into an issue when running migratedb.bat - 'value too large for column', I tracked down the issue to a database column(Requestor) in 'history' table with a max width of 64 and the data file having a 'requestor' value of size>64.
I tried running 'migratedb.bat migrate-preserve' and then modified targetschema.sql to increase the column width for 'requestor' in history table, and then ran 'migratedb import <data-dir>', It seems that import command attempts to recreate the schema file thus overwriting my changes. At the moment, the only way I can get this to work is by modifying the offending data in the data file(history.csv) to a length < 64 and then running the import command. Is there a way I can get the data imported with the modified targetschema.sql and prevent the migration tool from recreating this file everytime I run 'migratedb import'?