SymmetricDS space in column name MSSQL source fix
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.
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.
Related categories:
Business, Accounting, Human Resources & Legal
SQL
MySQL
Database Administration
Database Programming