I have to move SC plus to another server but when I do using a backup / restore process I got the following error
java.sql.SQLException: Invalid column name 'TABLE_ORDER'
I had tried almost everything, e.g.
Restore MS Sql server directly - no luck
Use clean DB (changedbserver.bat) and then restore (trimmed or not) - no luck
Attach the DB from old server to new server - no luck
I suspect that since I'm using the product several years, the DB is not compatible over upgrades and a field must be missing. Source is 7.9.32 but was upgraded several times from 7.7 to 7.9.32 while destination is installed directly to 7.9.32.
Source machine is Windows 2008R2, MS SQL 2008R2 Std..
Destination is 2012R2 & MS SQL 2008R2 (Express)
DB size is 40MB