I am trying to migrate solution I created using PostgreSQL as back end to a server using MS SQL Server as database server.
I use UUID's as my PK's in every table.
- Code: Select all
id uuid DEFAULT uuid_generate_v4() PRIMARY KEY,
I thought that by exporting my solution with all tables & data included would allow me to import this on to new server and Servoy would automatically take care of creating the correct columns in the new database 'language' and all would work nicely.
I installed the latest MS JDBC driver for SQL Server, but on solution import, I get this error
- Code: Select all
[error] com.microsoft.sqlserver.jdbc.SQLServerException: Identity column 'id' must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, unencrypted, and constrained to be nonnullable.
If I manually create a new database in Servoy Developer on that computer, it correctly sets it to type 'uniqueidentifier' & nonnullable, but this doesn't seem to happen when migrating.
My database URL is like this
- Code: Select all
jdbc:sqlserver://localhost:1433;DatabaseName=<database_name>;SelectMethod=direct;sendTimeAsDateTime=false;encrypt=false;
Is there some parameter or something else I should be setting to make sure it creates the tables correctly??
Thanks
Rafi