May 8, 2009 at 1:40 am
Hi all
we will soon be setting up a new test environment, were we will be pulling data from 1 SQL instance and manipulating it into another SQL instance, and i would like to have a tool of some sort that would allow me to go back and see all the changes made when debugging
is there anything out there that would help me in doing so ?
May 8, 2009 at 1:47 am
You could use ddl triggers to track changes in databse objects.
Take a look at this article:
http://www.sqlservercentral.com/articles/Auditing/62126/
Regards
Gianluca
-- Gianluca Sartori
May 8, 2009 at 1:49 am
Maybe you mean track changes in data. If this is what you want there's Red-Gate's SQL data compare:
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
-- Gianluca Sartori
May 8, 2009 at 1:55 am
yea i want to track changes in data - tho if possible as cheaply as possible!!:hehe:
May 8, 2009 at 1:59 am
The cheapest solution is to link the servers and set up queries to compare data by primary key.
Quite a lot of work.
-- Gianluca Sartori
May 8, 2009 at 3:00 am
sorry my question was asked very badly!
really what i want is something that will show me what tables are updated in our live ERP system if for example an order is entered - bare in mind there is maybe 50-60 various tables here,
so although i know the order header/detail tables, customer and stock tables are updated i have no idea how many other tables are getting updated at the same time! mabe zero but maybe 10!?
so if i could get a tool that would illustrate this that would be great - from first look at sql profiler i dont think that is its intended use?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply