Geekzone: technology news, blogs, forums
Guest
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
32862 posts

Uber Geek
+1 received by user: 15453

ID Verified
Trusted
Lifetime subscriber

#113847 29-Jan-2013 21:24
Send private message

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.

Create new topic
freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41029

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #752941 29-Jan-2013 21:41
Send private message

Something like TRacking changes in your database?





Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 



freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41029

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #752943 29-Jan-2013 21:43
Send private message

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




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 

networkn

Networkn
32862 posts

Uber Geek
+1 received by user: 15453

ID Verified
Trusted
Lifetime subscriber

  #752944 29-Jan-2013 21:44
Send private message

freitasm: Something like TRacking changes in your database?



/me eyes pop out of his head.



networkn

Networkn
32862 posts

Uber Geek
+1 received by user: 15453

ID Verified
Trusted
Lifetime subscriber

  #752947 29-Jan-2013 21:47
Send private message

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
80646 posts

Uber Geek
+1 received by user: 41029

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #752948 29-Jan-2013 21:49
Send private message

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




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 

Regs
4066 posts

Uber Geek
+1 received by user: 206

Trusted
Snowflake

  #752949 29-Jan-2013 21:51
Send private message

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

Create new topic








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
Copyright
©2002-2026 Geekzone®
Site features
Geekzone BI dashboard
Geekzone Badges
Geekzone Status Page

 

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