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


16519 posts

Uber Geek
+1 received by user: 4614

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

Uber Geek
+1 received by user: 11134

Administrator
Trusted
Geekzone
Lifetime subscriber

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

Something like TRacking changes in your database?





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

 

You can support content creators (and Geekzone) by using the Brave browser.

BDFL - Memuneh
60048 posts

Uber Geek
+1 received by user: 11134

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.




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

 

You can support content creators (and Geekzone) by using the Brave browser.

 
 
 
 


Try Wrike: fast, easy, and efficient project collaboration software


16519 posts

Uber Geek
+1 received by user: 4614

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.



16519 posts

Uber Geek
+1 received by user: 4614

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

Uber Geek
+1 received by user: 11134

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.




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

 

You can support content creators (and Geekzone) by using the Brave browser.

Infrastructure Geek
4055 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:





News »

Opera launches new mobile browser: Opera Touch
Posted 25-Apr-2018 20:45

TCF and Telcos Toughen Up on Scam Callers
Posted 23-Apr-2018 09:39

Amazon launches the International Shopping Experience in the Amazon Shopping App
Posted 19-Apr-2018 08:38

Spark New Zealand and TVNZ to bring coverage of Rugby World Cup 2019
Posted 16-Apr-2018 06:55

How Google can seize Microsoft Office crown
Posted 14-Apr-2018 11:08

How back office transformation drives IRD efficiency
Posted 12-Apr-2018 21:15

iPod laws in a smartphone world: will we ever get copyright right?
Posted 12-Apr-2018 21:13

Lightbox service using big data and analytics to learn more about customers
Posted 9-Apr-2018 12:11

111 mobile caller location extended to iOS
Posted 6-Apr-2018 13:50

Huawei announces the HUAWEI P20 series
Posted 29-Mar-2018 11:41

Symantec Internet Security Threat Report shows increased endpoint technology risks
Posted 26-Mar-2018 18:29

Spark switches on long-range IoT network across New Zealand
Posted 26-Mar-2018 18:22

Stuff Pix enters streaming video market
Posted 21-Mar-2018 09:18

Windows no longer Microsoft’s main focus
Posted 13-Mar-2018 07:47

Why phone makers are obsessed with cameras
Posted 11-Mar-2018 12:25


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.