Re: version control for database settings in Workbench?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Anon (anonymous_at_discussions.microsoft.com)
Date: 02/11/04 

Date: Tue, 10 Feb 2004 21:54:54 -0800

Thank you Erland. Your reply is spot on. BTW, I have
read (and put to good use) your comments to version
control in past issues of SQL Server Professional.

I do realize that source control or Transact-SQL code is
but a subset of a complete version control practice as far
as SQL Server development is concerned since, in my
experience, the development of some functionalities entail
more than just writing code. It involves creating other
database objects or entities, as well as changing the
server's or the database's properties or attributes.

Perhaps in the next version of Yukon...or maybe XpressApps
or SkilledSoftware can add such a feature...

>-----Original Message-----
>Anon (anonymous@discussions.microsoft.com) writes:
>> Not sure if you guys are taking questions on
Yukon...but
>> if you do, I would like to know if the new Workbench
IDE
>> supports version control of database, as well as server
>> configuration settings (Services, Security,
>> Management,etc..). I think this is important since in
the
>> course of a development effort, these settings can be
>> changed to support some of the code functionality.
>>
>> I have seen a screenshot of Workbench, and it shows a
tree
>> view similar to Ent. Mgr as well as a DTS Designer from
>> inside Visual Studio, so I'm assuming that DTS package
>> development is version controlled. I hope that
database &
>> server settings are too.
>
>Yes, you can version-control stored procedures from SQL
Workbench. What
>you put under version control is simply text files, so
you can also
>put scripts for changing server settings there. However,
if you hope
>for some automatic auditing of server settings, I would
expect you
>are out of luck. After all, that is not what *source*
control is
>about.
>
>There is a web site, www.sqljunkies.com, which is devoted
to Yukon.
>I have never visited the place myself, but this is the
best place to
>ask questiont about Yukon, if you are not on the beta
progamme.
>
>--
>Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techinfo/productdoc/2000/book
s.asp
>.
>

Relevant Pages

  • Re: What does CONTROL permissions give on asymmetric key?
    ... What does CONTROL mean in the context of the key? ... with a certificate, and the grant a user created from the certificate ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • RE: SQL SERVER DATABASE CREATION ERRORS
    ... Please note I gave the EVERYONE group full control and the db did not get ... created if it was a permission issue that should have negated it shurely? ... What service accounts do you use for SQL Server? ...
    (microsoft.public.sqlserver.setup)
  • custom control and sql connection
    ... i've created a custom web control in asp.net to implement basic ... for sql database. ... the error "SQL Server does not exist or access denied" even if the sql ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: Management Studio: Omit "Set" when modifying a proc
    ... *How can I tell Management Studio that I don't want these statement in ... version control your C# code by disassembling the DLLs, ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.tools)
  • Re: minimum OS user level to operate SQL Server
    ... Just the service that runs SQL will need windows security. ... Making them a system administrator would give them full control over SQL. ... > full control of SQL Server. ...
    (microsoft.public.sqlserver.security)