Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mfemenel
Professor Frink
1421 Posts |
 Posted - 2004-08-27 : 08:29:16
|
| I'm in a code distribution nightmare and there's no sign of it getting better. Right now we have new software in development. I have a development database, system test database, 2 UAT databases, a performance database a production database and a failover database. After launch there are 3 more environments coming online for pre release testing. While I do use source safe for my table and stored procedure objects, it's not helping me manage versions. It's a version control nightmare right now trying to manage what is on what server. If I have to update code, it's a pain and very easy to forget one, which of course, companies love when you get defects because of that. Does anyone know of a product to make their version control life easier with SQL? I'd love to hear the good and the bad so I can do some more research. Thanks.Mike"oh, that monkey is going to pay" |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2004-08-27 : 09:09:00
|
| Have a look at Red Gate's SQL bundle: SQL Compare, SQL Data Compare, and DTS Compare. We've been using it for sometime and I now wouldn't be without it!http://www.red-gate.com/SQL_Compare.htmMark |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2004-08-27 : 09:31:38
|
| And it comes with a 14 day full function demo....cool! Thanks!Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Code Distribution & Version Control