MSSQL Server migration of AUTO_INCREMENTing IDENTITY column to SEQUENCE



Any recommendations for using the including migration tools to get MSSQL data into NuoDB while switching from an auto-incrementing PKID/identity column to a NuoDB sequence? I have at least a couple hundred tables with millions to billions of record, so if there's a good way to do this I would love to hear it! I assume I can add a column that uses sequences, enable identity_insert, and update the new column based on the old PKIDs? I haven't tested it yet because I haven't looked at how to find constraints/drop constraints in NuoDB yet.


Thanks much,


1 comment

Please sign in to leave a comment.