Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Tracking Expand / Collapse
Author
Message
Posted Thursday, February 12, 2009 10:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 24, 2011 6:36 AM
Points: 2, Visits: 18
Tracking database changes becomes very important during migration.
Can some body suggest how to track the SQL database structural changes(Like store procedures,triggers etc) for a period of time.
Post #655908
Posted Thursday, February 12, 2009 1:25 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart1/523/






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #656066
Posted Thursday, February 12, 2009 1:39 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:27 AM
Points: 6,997, Visits: 8,411
I certainly advise to read Steve's article series

Off course, with sql2005 you can also use ddl-triggers to capture structural changes of tables, view, indexes, sprocs,...

Check out
Monitoring Changes in Your Database Using DDL Triggers
By David Dye at http://www.sqlservercentral.com/articles/Auditing/64176/


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #656079
Posted Friday, February 13, 2009 6:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
I couldn't agree more, change tracking is a must.

That's why some people out there bothered in creating Change Control and Version Control processes and tools ;)


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #656517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse