Re: Tool for SQL Server source code management

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mike davies (anonymous_at_discussions.microsoft.com)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 09:31:07 -0800

hello Marc,

thanks for your reply. Looked at Visual Studios way of doing things and it can be nice although it doesn't actually stop me from breaking any existing code and the editor isn't as good as Query Analyzer. The tools from both MS SQL XPress and SQL Source Control 2003 aren't quite there either, they just appear to be front ends to SourceSafe with editors that are still not as good as Query Analyzer.
This DB Ghost thing may just be what I'm looking for. It links into SourceSafe so you can extract the source from labels or build a database using the latest code and it can deploy the net code changes including my static data. Job done.

PS: I don't know what you mean by having a deployment master, around here SourceSafe is the master. This is where all our VB & .NET code is managed from, Labeled and therefore we have an Audit trail. It looks like I can now do it for my SQL code as well. I just hope DB Ghost is as good as they say it is.

Relevant Pages

  • RE: Source control to Access 2002
    ... database objects are represented by their own text file. ... VSS) called Data and Misc. ... could be added to a source control sofware, ... SourceSafe menu: ...
    (microsoft.public.vstudio.sourcesafe)
  • Replacing Visual SourceSafe (VSS)
    ... After years of being a SourceSafe user/administrator, ... to other version control systems. ... Can anyone recommend a solid source code control system for a small ... - Must support large databases - Total database size will be about 100G ...
    (comp.programming)
  • Re: Help with SQL 2005 and Sourcesafe 6
    ... that update the stored proc in the database, or do you just simply update it ... We already use Microsoft VIsual SOurcesafe 6 to store our ... Obviously the stored procedures have to be in the database for SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Re: Source control to Access 2002
    ... Add Database to SourceSafe ... >> that I created from directly running SourceSafe minutes ... But when I open SourceSafe ...
    (microsoft.public.vstudio.sourcesafe)
  • Newbie needs label scripts/script info
    ... have scripts to apply labels on not just a project but onto individual ... The following list outlines the scripts required: ... I'm relatively new to SourceSafe, and the time I've had to do any ramp ... up to learn more about SourceSafe beyond source control has been very ...
    (microsoft.public.vstudio.sourcesafe)