Tracking database changes

Question

Post reply

Tracking database changes

Adam Bean

One Orange Chip

Points: 26631
More actions
September 23, 2013 at 2:00 pm

#282871

Hey all,
I am in need of obtaining software or a process to automatically find DDL changes to my enterprise environment (hundreds of instances from SQL2000 to SQL2014). Years back, I used to use Bill Wunder's products (the original DTS version, then DDL AU, and finally SQL Clue). Fantastic products; however appears he has stopped development on this product, which is a shame as I found his software to be incredibly useful and insightful.
Anyway, curious to if any of you are aware of any similar products out there. The ideal world is recreating what Bill did in by scripting out all database objects to all servers (with filters), comparing and checking into a source control system with front end reporting.
Thanks!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

sharon-644450 Default port Points: 1442 More actions · Answer 1

sharon-644450

Default port

Points: 1442

September 24, 2013 at 12:24 am

#1652572

hi,

you can check Idera's - SQL Compliance Manger Tool

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

Check if Change Data Capture (CDC) feature of SQL Server may help.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Adam Bean One Orange Chip Points: 26631 More actions · Answer 3

Thanks for the responses guys!

sharon - I've used this in the past and at the time it didn't fit the bill; however I'll definitely give it a shot again.

mascot - A good idea; however keep in mind I need to track changes centrally and for 2000/2005 as well.

Vinod Pal Old Hand Points: 345 More actions · Answer 4

You could use SQL Audit or Extended Events to track your changes.

Adam Bean One Orange Chip Points: 26631 More actions · Answer 5

Hi Vinod,

Again the requirement is also for SQL2000/2005 and preferably in a central manner. Obviously yeah, I could create my own custom collectors (which I probably will), the ideal thing to do as of this time is to find a piece of software or existing process that will handle all of this and more.

I'm still trying to get a trial key for Compliance Manager to see if this will fit the bill; however at $3k an instance, I don't foresee this being a route I'll travel.

I'm amazed that I haven't found anything that resembles what Bill Wunder did years ago. It's such a great concept and I'm surprised more people aren't doing this.

Vinod Pal Old Hand Points: 345 More actions · Answer 6

For SQL 2005 you have the default trace which tracks DDL changes.

I guess our old friend MS Profiler could be used with server side traces...