Re: Version Control

Paul,

Microsoft is poised to release Visual Studio Team Edition for Database Professionals which will allow (or perhaps force) your developers to work in a disconnected fashion while developing and testing databases, stored procedures, etc. I think this, along with Team Foundation Server for source control will provide exactly what you are looking for.

I've written a few recent posts about this new product.

http://codebetter.com/blogs/jeff.lynch/archive/2006/10/17/Visual-Studio-Team-Edition-for-Database-Professionals.aspx

http://codebetter.com/blogs/jeff.lynch/archive/2006/10/20/More-Thoughts-on-Visual-Studio-Team-Edition-for-Database-Professionals.aspx


--
Jeff Lynch
MVP Windows Server System - Commerce Server
http://codebetter.com/blogs/jeff.lynch


"Paul Daly" <PaulDaly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:128B144B-3EFD-4130-8E22-D079F56288E7@xxxxxxxxxxxxxxxx
I have inherited a sql server that all developers can connect to and develop
against. I would prefer that we copy the database from the test server onto
our local computers, develop on our local copy of the database (scripting all
of our changes), and once we feel that are changes are complete, run the
script on the test server. Some developers aren't happy about this because
they don't want to have to make sure they have the latest changes on their
local database. I don't want them making changes to the server via
management studio and never knowing what the update was (which is the reason
why I want to force them to script their changes).

I'd like to collect feedback from others on how one could implement version
control for database schema / stored proceedures / user-defined functions...
basically anything but the data itself. What tools, best-practices do you
use to handle this senario?

Thanks in advance for your help,

Paul Daly

.

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Need help on how to organize users and objects
    ... I could assign a custom database role to them though. ... In 2005, if a user creates an sp, which schema does it belong to? ... Security is a huge subject in SQL Server 2005, so I'd suggest you to spend ... the sysadmin; developers and viewers. ...
    (microsoft.public.sqlserver.security)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)