I want to import data from one DB1 (Oracle) to DB2 (SQL Server). I need to manipulate the data from DB1 quite a lot before I can put it into DB2 but I often need to maintain the primary keys. How can I achieve the equivalent of

SET IDENTITY_INSERT table ON

// Do LLBLGEN Insert

SET IDENTITY_INSERT table OFF

using LLBLGEN?

Cheers, Pete

Option #1: (not sure of its applicability) Don't define the Identity on these columns till you migrate the data.

Option#2: Create 2 Stored Procedures to wrap these calls, and call them from LLBLGen Pro.

Option#3: Emit them from LLBLGen Pro (check the following thread) http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=3487