I’m designing a Servoy front end to an existing MS SQL backend. The backend has some reserved words, some violations of data rules, etc. in it. In 2.1.2 I can import a new release of the solution using the override option. In 2.2b1 I cannot import, even using the override. This means I cannot upgrade from 2.12 – I do not have total control over the backend.
The error i get is as follows:
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]The scale (24) for column 'bidquantity' must be within the range 0 to 19.
Reserved words used as table or column names: columns: comment other month year;
The server version of the column 'contractfirm_id' of table 'tblrelatecontractfirmpeople' in server 'urs' has 'servoy seq' sequence type while the import version has 'none' sequence type.
The server version of the column 'firmuser_id' of table 'tblrelatecontractfirmpeople' in server 'urs' has 'servoy seq' sequence type while the import version has 'none' sequence type.