sqlines
sqlines copied to clipboard
Oracle to MSSQL: SQLines Data unexpectedly transfers SEQUENCES, and fails on large values
While migrating Oracle to MSSQL I noticed that SQLines Data (v3.1.337) also transfers any SEQUENCES. While I suppose this may or may not be useful in any particular scenario, this came as a surprise to me, as the user interface only ever mentions it will transfer TABLES, and SEQUENCEs are clearly not tables. My table definitions don't depend on the existence of these sequences, so I don't really understand why they were transferred. At minimum the user interface should make clear(er) that it will transfer these object too.
On top of that, any sequences that have a current value (LAST_NUMBER in Oracle) larger than the max value of INT will fail to transfer because the SQL statements that create them do not specify a datatype, so they get created as INT.
Failing SQL was: CREATE SEQUENCE [MyTable] START WITH 1000000000000000000000042112 INCREMENT BY 1;