I have been tasked to migrate a database from PostgreSQL 9 to SQL Server 2008 R2, and I have found some issues I need to address. I have quite limited experiences with PostgreSQL I'm afraid.
Most keys are BigInt. In PostgreSQL a function is called to get the next ID and this is done in advance in the code for whatever reason. Can this be done in the same manner in SQL Server or am I forced to create an key index table to keep track of the current ID.
IDENTITY(1,1)will afaik deliver a new ID on the insert.
There are some stored procedures that returns
TRIGGER. What would be the equivalent in the SQL Server language?
What impact has the difference in triggers given that PostgreSQL triggers are row based?