November 6, 2009 at 8:48 am
I would like to create an app that would compare procs in a VSS environment with actual production procs and check for differences. Has anyone found a 3rd party tool that does this or know a way (in .net I presume) to build this? I would like to run it every day and make sure all is in sync. Not everyone has the habit of using VSS.
November 6, 2009 at 8:53 am
If I were you, I would look in a 3rd party that already have that kind of product.
Look into redGate, or DBGhost, both products work really nicely. I don't know for redGate, but I know you can build a database from SourceSafe with DBGhost...
Hope that helps,
Cheers,
J-F
November 6, 2009 at 8:57 am
I think RedGate has a product for that. ApexSQL, too.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 6, 2009 at 9:00 am
Hi
If you have Visual Studio (Database Professionals or Team Suite) you can create SQL Server Database projects which can handle all these things. You can configure a database and Visual Studio automatically creates a update script containing all schema differences between your project and the database.
Greets
Flo
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply