SymmetricDS space in column name MSSQL source fix

Job ID: 36285809

Budget: €250 – €750 EUR

Hello,

We have setup a replication from MSSQL to MySQL. SymmetricDS auto creates the schema, but one table in source (MSSQL) contains trailing space => 'Artikelnr '. This gives an error with MySQL.
This project is about fixing this issue so it automatically corrects it and creates the table.

<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
<table name="">
<column name="Artikelnr " type="VARCHAR" size="50">
<platform-column name="mssql2016" type="varchar" size="50"/>
</column>

Must be future proof so no one time manual fixes.
A pastebin log file can be supplied for more info.