Obtain all changes from database change tracking

Question

I know how to get changes from one table but what I want is to get the changes from all the tables. How can I achieve this?

Redgate SQL Compare allows you to compare two databases and see all the changes (there are data and structure comparers). It isn't free but there is a 14-day trial — Richard Pursehouse, Jul 12 '13 at 12:15
For data. I didn't try anything because I couldn't find anything on Google. I only know how to do it for one table only. — Gauri K., Jul 12 '13 at 12:16
I'm really sorry for the misunderstanding. I accidentally added the C# tag. I don't want C# code, but just a SQL script. — Gauri K., Jul 12 '13 at 12:19

Yair Nevet · Answer 1 · 2013-07-12T12:59:11.123

0

In order to make your diff operation per table in your you can list all of them using SQL, look:

USE YourDBName
GO 
SELECT *
FROM sys.Tables
GO

edited Jul 12 '13 at 12:59

answered Jul 12 '13 at 12:20

Yair Nevet

This is what I have so far: declare synchronization_version bigint SET synchronization_version = CHANGE_TRACKING_CURRENT_VERSION(); select * from changetable(changes layouts, synchronization_version )as ct – Gauri K. Jul 12 '13 at 13:26
@GauriK. What do you what to achieve? Do you want to compare your DB tables against other DB tables? – Yair Nevet Jul 12 '13 at 13:37
No, I want to see what data is changed – Gauri K. Jul 12 '13 at 13:57

1 Answers1