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


18236 posts

Uber Geek
+1 received by user: 5238

Trusted
Lifetime subscriber

Topic # 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
BDFL - Memuneh
61303 posts

Uber Geek
+1 received by user: 12043

Administrator
Trusted
Geekzone
Lifetime subscriber

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

Something like TRacking changes in your database?





Backblaze cloud backup (personal and business) | Geekzone broadband switch | Amazon (Geekzone aff) | MightyApe (Geekzone aff) | 

 

My technology disclosure  | Business Transformation | Enterprise Content Management | Customer Relationship Management

 

 

BDFL - Memuneh
61303 posts

Uber Geek
+1 received by user: 12043

Administrator
Trusted
Geekzone
Lifetime subscriber

  Reply # 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.




Backblaze cloud backup (personal and business) | Geekzone broadband switch | Amazon (Geekzone aff) | MightyApe (Geekzone aff) | 

 

My technology disclosure  | Business Transformation | Enterprise Content Management | Customer Relationship Management

 

 



18236 posts

Uber Geek
+1 received by user: 5238

Trusted
Lifetime subscriber

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

freitasm: Something like TRacking changes in your database?



/me eyes pop out of his head.



18236 posts

Uber Geek
+1 received by user: 5238

Trusted
Lifetime subscriber

  Reply # 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.

BDFL - Memuneh
61303 posts

Uber Geek
+1 received by user: 12043

Administrator
Trusted
Geekzone
Lifetime subscriber

  Reply # 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.




Backblaze cloud backup (personal and business) | Geekzone broadband switch | Amazon (Geekzone aff) | MightyApe (Geekzone aff) | 

 

My technology disclosure  | Business Transformation | Enterprise Content Management | Customer Relationship Management

 

 

Infrastructure Geek
4056 posts

Uber Geek
+1 received by user: 195

Trusted
Microsoft NZ
Subscriber

  Reply # 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




Technical Evangelist
Microsoft NZ
about.me/nzregs
Twitter: @nzregs

Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



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.

Alternatively, you can receive a daily email with Geekzone updates.