Re: SQL Server and VSS

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

From: Ron Talmage (rtalmage_at_prospice.com)
Date: 02/01/05 

Date: Mon, 31 Jan 2005 19:12:55 -0800

Igor,

The main problem with a full integration is that there is no way to mark an
object as checked out, or read only, in a database. Therefore most
development teams I've worked with will stipulate that all database objects
must be edited from text file T-SQL scripts, which are stored in a source
code control system and checked out locally.

Ron 

-- 
Ron Talmage
SQL Server MVP
"Igor Marchenko" <igormarchenko@hotmail.com> wrote in message 
news:e1SbCgACFHA.2568@TK2MSFTNGP11.phx.gbl...
> Hello!
>
>   I was wondering if there is a tool on the market that seamlessly 
> integrates SQL Server and VSS. I would like to be able to check-out/check 
> in stored procedures so that only one person can edit it etc. Does 
> Microsoft plan to have SQL server integrated with VSS in the next version?
>
> Thanks,
> Igor
>

Relevant Pages

  • How to migrate SQL 2000 stored procedures and UDFs to VS 2005?
    ... VS 2003 + SQL Server 2005 ... The migration went smoothly, and the application and database are working ... I have 100+ stored procedures and UDF's inside my database. ... Manage stored procedures and UDF's inside VSS ...
    (microsoft.public.vstudio.development)
  • Re: Help with SQL 2005 and Sourcesafe 6
    ... Pardon my jumping in here in the middle of the conversation, but I have used the VSS integration from SSMS quite extensively. ... As Erland has correctly noted, ... As for using the integration, simply load the VSS client on your workstation and you will get the VSS options added to Management Studio. ... Senior Database Administrator ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Server and VSS
    ... AFAIK, there is no integration. ... Nor does the road map of VSS ... Books Online for SQL Server SP3 at ... "Igor Marchenko" wrote in message ...
    (microsoft.public.sqlserver.tools)
  • RE: Integration of MS SQL Server with VSS 6.0
    ... VSS can store files of almost any type, including SQL Server .SQL files, or ... check in/out your .SQL files from there. ... VSS and compile them into SQL Server. ... > I want to know about integration of SQL Server 2000 integration with VSS ...
    (microsoft.public.vstudio.sourcesafe)
  • RE: Visual Source Safe requires SQL Server?
    ... Don't get confused when thinking about the VSS "database"; this is not a database in the sense that SQL Server or Oracle is. ...
    (microsoft.public.vstudio.sourcesafe)