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.


networkn

Networkn
32349 posts

Uber Geek

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

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

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




Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup




freitasm
BDFL - Memuneh
79250 posts

Uber Geek

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.




Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


networkn

Networkn
32349 posts

Uber Geek

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

Uber Geek

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

Uber Geek

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.




Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


Regs
4066 posts

Uber Geek

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




Create new topic





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.



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.