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 › Development › Newbie - Way to See data changed in SQL DB


4858 posts

Uber Geek

Trusted
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
44238 posts

Uber Geek

Administrator
Trusted
Geekzone
Subscriber
  Reply # 752941 29-Jan-2013 21:41 Send private message

Something like TRacking changes in your database?






Mauricio Freitas (Geekzone Admin, Devil's Advocate, my blog, technology disclosure, my tweets, Web Performance Optimization) 

Geekzone Price comparison | Amazon Kindle order page | How to get the best out of Geekzone | New Zealand IT Jobs | Geekzone News | Jinglebugs 

BDFL
44238 posts

Uber Geek

Administrator
Trusted
Geekzone
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.





Mauricio Freitas (Geekzone Admin, Devil's Advocate, my blog, technology disclosure, my tweets, Web Performance Optimization) 

Geekzone Price comparison | Amazon Kindle order page | How to get the best out of Geekzone | New Zealand IT Jobs | Geekzone News | Jinglebugs 



4858 posts

Uber Geek

Trusted
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.



4858 posts

Uber Geek

Trusted
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
44238 posts

Uber Geek

Administrator
Trusted
Geekzone
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.





Mauricio Freitas (Geekzone Admin, Devil's Advocate, my blog, technology disclosure, my tweets, Web Performance Optimization) 

Geekzone Price comparison | Amazon Kindle order page | How to get the best out of Geekzone | New Zealand IT Jobs | Geekzone News | Jinglebugs 

10100111001
3209 posts

Uber Geek

Trusted
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




Need help implementing Microsoft CRM? Give OA Systems a shout. 
Winners of CRM Solution of the Year at the 2010 Microsoft NZ Partner Awards

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 new jobs are posted to our jobs board:



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




News »
Investor Rowan Simpson backs Timely
Posted 19-Jun-2013 14:36

Orcon Genius Go app set home lines free
Posted 19-Jun-2013 14:26

New Slingshot "Global Mode" gives access to world of content
Posted 19-Jun-2013 13:00

Symantec 2013 Global SMB IT Confidence Index shows top ANZ challenge is keeping up with IT trends
Posted 19-Jun-2013 12:37

Major update to Adobe Creative Cloud now available
Posted 19-Jun-2013 12:15

Geeksphere TV: Episode 23.1
Posted 19-Jun-2013 11:45


Trending now »
Hot discussions in our forums right now:

Sky outbid for EPL rights (Premier League Pass discussion)
Created by JonnyCam, last reply by JamesL on 19-Jun-2013 20:08 (214 replies)
Pages... 13 14 15

Orcon Genius Go discussion
Created by freitasm, last reply by Chrisbexsta on 19-Jun-2013 20:16 (43 replies)
Pages... 2 3

Slingshot Global Mode announced
Created by freitasm, last reply by nickb800 on 19-Jun-2013 20:09 (39 replies)
Pages... 2 3

I am been sued - HELP!
Created by BaaaaD, last reply by sidders80 on 19-Jun-2013 20:18 (31 replies)
Pages... 2 3

Condenser Dryer: anyone has one?
Created by joker97, last reply by graemew on 18-Jun-2013 21:08 (31 replies)
Pages... 2 3

Slow YouTube Response
Created by SneakerPimps, last reply by mercutio on 18-Jun-2013 21:34 (23 replies)
Pages... 2

Anyone else watching paint dry?
Created by gnfb, last reply by DravidDavid on 19-Jun-2013 19:53 (40 replies)
Pages... 2 3

Suggestions for good Windows FTP client please?
Created by freitasm, last reply by Regs on 19-Jun-2013 17:17 (19 replies)
Pages... 2


Geekzone Jobs »
Most recent NZ jobs in technology:

Senior Business Analyst
Posted 19-Jun-2013 19:38

Java Developer
Posted 19-Jun-2013 19:38

RF Tester
Posted 19-Jun-2013 19:38

Motivated Systems Administrator
Posted 19-Jun-2013 19:38

Senior ASP.Net Developer
Posted 19-Jun-2013 19:38

Senior Business Analyst
Posted 19-Jun-2013 19:38

Senior BizTalk Developer
Posted 19-Jun-2013 19:38


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.