Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- input: |-
UPDATE test SET test.c1 = 1 WHERE test.b1 = 1;
UPDATE test SET test.c1 = 2 WHERE test.b1 = 2;
UPDATE test SET test.c1 = 3 WHERE test.b1 = 3;
UPDATE test SET test.c1 = 4 WHERE test.b1 = 4;
UPDATE test SET test.c1 = 5 WHERE test.b1 = 5;
UPDATE test SET test.c1 = 6 WHERE test.b1 = 6;
UPDATE test SET test.c1 = 7 WHERE test.b1 = 7;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 1
UNION
SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 2
UNION
SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 3
UNION
SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 4
UNION
SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 5
UNION
SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 6
UNION
SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 7) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 1
column: 0
endposition:
line: 7
column: 45
- input: |-
DELETE FROM t_alias
FROM test AS t_alias
WHERE t_alias.c1 = 1;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [t_alias].* FROM test AS t_alias WHERE t_alias.c1 = 1) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 1
column: 0
endposition:
line: 3
column: 20
- input: |-
UPDATE t_alias
SET t_alias.c1 = 2
FROM test AS t_alias
WHERE t_alias.c1 = 1;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [t_alias].* FROM test AS t_alias WHERE t_alias.c1 = 1) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 1
column: 0
endposition:
line: 4
column: 20
- input: |-
DELETE FROM test
FROM test JOIN test2 ON test.c1 = test2.c1
WHERE test.c1 = 1;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [db].[dbo].[test].* FROM test JOIN test2 ON test.c1 = test2.c1 WHERE test.c1 = 1) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 1
column: 0
endposition:
line: 3
column: 17
- input: |-
UPDATE test
SET test.c1 = 2
FROM test JOIN test2 ON test.c1 = test2.c1
WHERE test.c1 = 1;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [db].[dbo].[test].* FROM test JOIN test2 ON test.c1 = test2.c1 WHERE test.c1 = 1) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 1
column: 0
endposition:
line: 4
column: 17
- input: |-
DELETE FROM test1 WHERE c1 = 1;
UPDATE test SET test.c1 = 2 WHERE test.c1 = 1;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test1_db] FROM (
SELECT [db].[dbo].[test1].* FROM test1 WHERE c1 = 1) AS backup_table;
sourceschema: dbo
sourcetablename: test1
targettablename: rollback_test1_db
startposition:
line: 1
column: 0
endposition:
line: 1
column: 30
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [db].[dbo].[test].* FROM test WHERE test.c1 = 1) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 2
column: 0
endposition:
line: 2
column: 45
- input: DELETE FROM test WHERE c1 = 1;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [db].[dbo].[test].* FROM test WHERE c1 = 1) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 1
column: 0
endposition:
line: 1
column: 29
- input: UPDATE test SET c1 = 1 WHERE c1=2;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [db].[dbo].[test].* FROM test WHERE c1=2) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 1
column: 0
endposition:
line: 1
column: 33
- input: |-
UPDATE test SET test.c1 = 2 WHERE test.c1 = 1;
UPDATE test SET test.c1 = 3 WHERE test.c1 = 5;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
SELECT [db].[dbo].[test].* FROM test WHERE test.c1 = 1
UNION
SELECT [db].[dbo].[test].* FROM test WHERE test.c1 = 5) AS backup_table;
sourceschema: dbo
sourcetablename: test
targettablename: rollback_test_db
startposition:
line: 1
column: 0
endposition:
line: 2
column: 45
- input: DELETE FROM employees WHERE department_id = 10;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_employees_db] FROM (
SELECT [db].[dbo].[employees].* FROM employees WHERE department_id = 10) AS backup_table;
sourceschema: dbo
sourcetablename: employees
targettablename: rollback_employees_db
startposition:
line: 1
column: 0
endposition:
line: 1
column: 46
- input: UPDATE positions SET title = 'Senior Engineer' WHERE position_id = 1;
result:
- statement: |-
SELECT * INTO [backupDB].[dbo].[rollback_positions_db] FROM (
SELECT [db].[dbo].[positions].* FROM positions WHERE position_id = 1) AS backup_table;
sourceschema: dbo
sourcetablename: positions
targettablename: rollback_positions_db
startposition:
line: 1
column: 0
endposition:
line: 1
column: 68