Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

4.4 KB
Raw Blame
- input: |-
    UPDATE t_generated SET b = 1 WHERE a = 1;
    UPDATE t_generated SET b = 2 WHERE a = 2;
    UPDATE t_generated SET b = 3 WHERE a = 3;
    UPDATE t_generated SET b = 4 WHERE a = 4;
    UPDATE t_generated SET b = 5 WHERE a = 5;
    UPDATE t_generated SET b = 6 WHERE a = 6;
    UPDATE t_generated SET b = 7 WHERE a = 7;
  backupdatabase: bbarchive
  backuptable: prefix_t_generated
  originaldatabase: db
  originalschema: dbo
  originaltable: t_generated
  result: |-
    /*
    Original SQL:
    UPDATE t_generated SET b = 1 WHERE a = 1;
    UPDATE t_generated SET b = 2 WHERE a = 2;
    UPDATE t_generated SET b = 3 WHERE a = 3;
    UPDATE t_generated SET b = 4 WHERE a = 4;
    UPDATE t_generated SET b = 5 WHERE a = 5;
    UPDATE t_generated SET b = 6 WHERE a = 6;
    UPDATE t_generated SET b = 7 WHERE a = 7;
    */
    MERGE INTO [db].[dbo].[t_generated] AS t
    USING [bbarchive].[dbo].[prefix_t_generated] AS b
      ON t.[a] = b.[a]
    WHEN MATCHED THEN
      UPDATE SET t.[b] = b.[b]
    WHEN NOT MATCHED THEN
     INSERT ([a], [b]) VALUES (b.[a], b.[b]);
- input: |-
    UPDATE t_generated SET a = 1 WHERE b = 1;
    UPDATE t_generated SET a = 2 WHERE b = 2;
    UPDATE t_generated SET a = 3 WHERE b = 3;
    UPDATE t_generated SET a = 4 WHERE b = 4;
    UPDATE t_generated SET a = 5 WHERE b = 5;
    UPDATE t_generated SET a = 6 WHERE b = 6;
    UPDATE t_generated SET a = 7 WHERE b = 7;
  backupdatabase: bbarchive
  backuptable: prefix_t_generated
  originaldatabase: db
  originalschema: dbo
  originaltable: t_generated
  result: |-
    /*
    Original SQL:
    UPDATE t_generated SET a = 1 WHERE b = 1;
    UPDATE t_generated SET a = 2 WHERE b = 2;
    UPDATE t_generated SET a = 3 WHERE b = 3;
    UPDATE t_generated SET a = 4 WHERE b = 4;
    UPDATE t_generated SET a = 5 WHERE b = 5;
    UPDATE t_generated SET a = 6 WHERE b = 6;
    UPDATE t_generated SET a = 7 WHERE b = 7;
    */
    MERGE INTO [db].[dbo].[t_generated] AS t
    USING [bbarchive].[dbo].[prefix_t_generated] AS b
      ON t.[b] = b.[b]
    WHEN MATCHED THEN
      UPDATE SET t.[a] = b.[a]
    WHEN NOT MATCHED THEN
     INSERT ([a], [b]) VALUES (b.[a], b.[b]);
- input: DELETE FROM t_generated where a = 1;
  backupdatabase: bbarchive
  backuptable: prefix_1_t_generated
  originaldatabase: db
  originalschema: dbo
  originaltable: t_generated
  result: |-
    /*
    Original SQL:
    DELETE FROM t_generated where a = 1;
    */
    INSERT INTO [db].[dbo].[t_generated] ([a], [b]) SELECT [a], [b] FROM [bbarchive].[dbo].[prefix_1_t_generated];
- input: UPDATE t_generated SET a = 1 WHERE a = 2;
  backupdatabase: bbarchive
  backuptable: prefix_1_t_generated
  originaldatabase: db
  originalschema: dbo
  originaltable: t_generated
  result: |-
    /*
    Original SQL:
    UPDATE t_generated SET a = 1 WHERE a = 2;
    */
    MERGE INTO [db].[dbo].[t_generated] AS t
    USING [bbarchive].[dbo].[prefix_1_t_generated] AS b
      ON t.[b] = b.[b]
    WHEN MATCHED THEN
      UPDATE SET t.[a] = b.[a]
    WHEN NOT MATCHED THEN
     INSERT ([a], [b]) VALUES (b.[a], b.[b]);
- input: DELETE test FROM test, test2 as t2 where test.id = t2.id;
  backupdatabase: bbarchive
  backuptable: prefix_1_test
  originaldatabase: db
  originalschema: dbo
  originaltable: test
  result: |-
    /*
    Original SQL:
    DELETE test FROM test, test2 as t2 where test.id = t2.id;
    */
    INSERT INTO [db].[dbo].[test] ([a], [b], [c]) SELECT [a], [b], [c] FROM [bbarchive].[dbo].[prefix_1_test];
- input: UPDATE test SET test.c1 = 1 WHERE test.c1 = 1;
  backupdatabase: bbarchive
  backuptable: prefix_1_test
  originaldatabase: db
  originalschema: dbo
  originaltable: test
  result: |-
    /*
    Original SQL:
    UPDATE test SET test.c1 = 1 WHERE test.c1 = 1;
    */
    MERGE INTO [db].[dbo].[test] AS t
    USING [bbarchive].[dbo].[prefix_1_test] AS b
      ON t.[a] = b.[a]
    WHEN MATCHED THEN
      UPDATE SET t.[c1] = b.[c1]
    WHEN NOT MATCHED THEN
     INSERT ([a], [b], [c]) VALUES (b.[a], b.[b], b.[c]);
- input: UPDATE test SET c1 = 1 WHERE c1 = 1;
  backupdatabase: bbarchive
  backuptable: prefix_1_test
  originaldatabase: db
  originalschema: dbo
  originaltable: test
  result: |-
    /*
    Original SQL:
    UPDATE test SET c1 = 1 WHERE c1 = 1;
    */
    MERGE INTO [db].[dbo].[test] AS t
    USING [bbarchive].[dbo].[prefix_1_test] AS b
      ON t.[a] = b.[a]
    WHEN MATCHED THEN
      UPDATE SET t.[c1] = b.[c1]
    WHEN NOT MATCHED THEN
     INSERT ([a], [b], [c]) VALUES (b.[a], b.[b], b.[c]);