Newbie - Way to See data changed in SQL DB

Welcome Guest.

You haven't logged in yet. If you don't have an account you can register now.

Forums › IT Pro and developers › Newbie - Way to See data changed in SQL DB

networkn

Networkn
32349 posts

Uber Geek

ID Verified

Trusted

Lifetime subscriber

#113847 29-Jan-2013 21:24

Hi There!

I need to get a record of what has changed in a SQL DB between two steps in an application. I don't have a lot of experience with SQL so I am hoping this is reasonably straightforward thing to do.

Thanks very much in advance. There are about 200 tables, most of which are small.

freitasm

BDFL - Memuneh
79250 posts

Uber Geek

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#752941 29-Jan-2013 21:41

Something like TRacking changes in your database?

freitasm

BDFL - Memuneh
79250 posts

Uber Geek

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#752943 29-Jan-2013 21:43

Or perhaps this SQL Server Change Tracking on Table which has some examples and queries showing how to track it.

networkn

Networkn
32349 posts

Uber Geek

ID Verified

Trusted

Lifetime subscriber

#752944 29-Jan-2013 21:44

freitasm: Something like TRacking changes in your database?

/me eyes pop out of his head.

networkn

Networkn
32349 posts

Uber Geek

ID Verified

Trusted

Lifetime subscriber

#752947 29-Jan-2013 21:47

freitasm: Or perhaps this SQL Server Change Tracking on Table which has some examples and queries showing how to track it.

I don't think this would work for me, since it requires tables to be specifically tracked individually.

I was kind of hoping for a snapshot and compare solution.

freitasm

BDFL - Memuneh
79250 posts

Uber Geek

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#752948 29-Jan-2013 21:49

There are compare products around, but I don't know any that are free. Check Idera and RedGate for this kind of software.

Regs

4066 posts

Uber Geek

Trusted

Snowflake

#752949 29-Jan-2013 21:51

is this a one-off debugging sort of thing, or are you looking to log changes and do something with them?

If its a debugging sort of thing, use SQL Profiler, point it at a sql server and tell it to capture queries and stored procedures. http://msdn.microsoft.com/en-us/library/ms181091.aspx

Sales Engineer
Snowflake
www.snowflake.com

about.me/nzregs
Twitter: @nzregs

News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00

eero Pro 7 Review
Posted 23-Jul-2025 12:07

BeeStation Plus Review
Posted 21-Jul-2025 14:21

eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01

WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32

RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26

Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24

Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05

Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01

Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01

Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22

Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46

Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42

D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34

Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15

Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

RSS feeds: Main feed; Forums feed

Site features: Geekzone BI dashboard; Geekzone Badges; Geekzone Status Page

Affiliate links: Samsung; AliExpress; Wise; Sharesies; GoodSync

Site Information: Subscribe to Geekzone; Privacy Statement; Forum Usage Guidelines (FUG); Advertising; Trademark and copyright