| Author |
Topic |
|
cshekar
Starting Member
49 Posts |
 Posted - 2005-01-31 : 16:34:24
|
| Hi,Please help me is there any Thrid part Toll .Where it can keep track all the users's changes or Schema changes in SQL serever Database, My company asking me. find out the tool where it can keep track all the DAtabaswe changes..Thanks in Advance .shekarchandra shekar |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-01-31 : 17:45:57
|
| Duplicate of a duplicate post.http://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-31 : 18:46:28
|
Dupes have been fixed  I do all my changes as scripts and put them into CVS. I use intimidation tactics to make sure anyone working on a team with me does the same.Damian |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-01-31 : 22:07:08
|
quote:
Originally posted by Merkin
Dupes have been fixed I do all my changes as scripts and put them into CVS. I use intimidation tactics to make sure anyone working on a team with me does the same.Damian
Could you give me a few legal pointers on "intimidation tactics"; I am having rotten luck getting my co-workers to use source control.Tim S |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-31 : 22:32:09
|
| Here's a great way to start:-Script out the current version of all your stored procedures from the database-Check them into your Source Control-Every day, re-create them on the server FROM your Source ControlGreat fun to watch when someone hasn't checked in 3 days worth of changes, but a good idea to stay out of arm's reach for the first couple of days. It's actually more fun than denying them permission to the database server, cause even if they FUBAR something you can always put it back. No, I don't use this at work, wish I did. I did hear it from some people at our SQL Server user group meetings though...and it does actually work. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-31 : 22:39:35
|
quote:
Could you give me a few legal pointers on "intimidation tactics"; I am having rotten luck getting my co-workers to use source control.
What Rob said is pretty much how it happens.I tell people that if their code isn't in CVS, it doesn't exist, and I will (and do) rerun the entire directory of procs on a regular basis and kill their changes.On the bigger projects, I use an automated build system that deploys change scripts and wipes and recreates all procs to a dev / staging server. The install scripts are generated from the staging server (automated of course). So work is done on a local workstation, the only way code gets deployed to the server is via the build process.If I catch people pointing EM at the server, they get yelled at  What has happened, is someone made a change on the server, it gets messed up and they go into a panic because they lost work. Then I get to really rub it in as I help them fix things. "This wouldn't happen if you followed the process".To make this work, you need to also be helpful, I'm available at a moments notice to help people write a change script rather than try to make changes in EM.This is where most DBA's just alienate people, "all stick and no carrot"I'm lucky where I am at the moment, I have full support from people higher than me to bring these sorts of processes in. I can tell anybody, "this is the way we do things here", and it will get backed up.Damian |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-02-01 : 02:00:18
|
User -->  <-- Merkin |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-02-01 : 13:38:00
|
| Tim SI believe that the Smith and Wesson method works very well. You can get your co-workers to do all sorts of things with that method.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-02-02 : 15:14:38
|
| Thanks for the Idea, I may use it.I have to get one of the fellow developers OK, since he is above me in rank.But, since he almost always uses source control it should not be an issue.Tim S |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-02 : 19:42:48
|
quote:
since he almost always uses source control it should not be an issue.
Be on the lookout for a episode where he DOESN'T use source control, and take full advantage of it. |
|
|
|
|
ANY for DB Change Tools(SQL SErver)