Add possibility to add CHANGE_TRACKING_CONTEXT to deployment script
Provide an option (in gui and command line) to add a CHANGETRACKINGCONTEXT to the generated deployment script.
This is helpful when using sql change tracking for synchronization to manage whether the changed made under a provided CHANGETRACKINGCONTEXT need to be synchronized or not.
When enabling change tracking we have to make sure that the data in the tables are identical on both sides. Thats were we use SQL Data Compare, but the changes made for that "initial sync" shouldn't be recognized by change tracking for later synchronization.
This would be very easy if you could just add an option to generate that context to the statements in the deployment script like this:
DECLARE @contextString NVARCHAR(100) = 'SomeStringAsInput';
DECLARE @context VARBINARY(128);
SET @context = CAST(@contextString AS VARBINARY(128));
WITH CHANGETRACKINGCONTEXT (@context)
INSERT INTO dbo.Table (TableName, Text)
VALUES
(
'TableName'
'Test'
)