Prev: Help! Cannot delete an orphaned merge push subscription
Next: Moving SSRS Server not the database
From: Charles on 9 Feb 2010 09:26
Hi Dan

I have seen TS mentioned, but the price is prohibitive for us at the moment.
I'm looking for a way to use SVN if possible.

Charles


"Dan Guzman" <guzmanda(a)nospam-online.sbcglobal.net> wrote in message
news:9988EFB8-7FE6-44F8-A860-F6E250DCA000(a)microsoft.com...
> We use Visual Studio Team System 2008 (VSTS 1010 coming soon) with TFS
> source control for database development. This provides version history
> with branching capabilities, along with schema compare and deployment
> script generation tools.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
> http://weblogs.sqlteam.com/dang/
>
>
> "Charles" <blank(a)nowhere.com> wrote in message
> news:uUx56LNqKHA.556(a)TK2MSFTNGP02.phx.gbl...
>> When creating a sproc in SSMS, a simple code header is automatically
>> inserted that I can use to save change history, for example. When
>> creating a view this does not happen as far as I can see, although I can
>> manually enter one.
>>
>> When creating a table there is no header and it seems no possibility to
>> create one; if I create the table from script comments are not retained.
>>
>> Firstly, I am wondering why the inconsistency, and secondly how can I
>> save comments where developers enter change history when something in the
>> table schema is updated? I realise I can use extended properties, but
>> these appear horribly cumbersome, and not really fit for this purpose.
>> How does everyone else do it?
>>
>> [I'm going to try and second guess here, but is is that I should be
>> maintaining the script and not the database objects?]
>>
>> TIA
>>
>> Charles
>>
>>
From: bill on 9 Feb 2010 21:48
On Feb 9, 7:26 am, "Charles" <bl...(a)nowhere.com> wrote:
> Hi Dan
>
> I have seen TS mentioned, but the price is prohibitive for us at the moment.
> I'm looking for a way to use SVN if possible.

I am quite sure that the Redgate tool (can't remember the name) will
integrate with SSMS *and* can use SVN as the repository. I'd be
interested to hear what you find out on this front.

Thanks,

Bill
From: dvdtknsn on 14 Feb 2010 14:49
On Feb 10, 2:48 am, bill <billmacle...(a)gmail.com> wrote:
> On Feb 9, 7:26 am, "Charles" <bl...(a)nowhere.com> wrote:
>
> > Hi Dan
>
> > I have seen TS mentioned, but the price is prohibitive for us at the moment.
> > I'm looking for a way to use SVN if possible.
>
> I am quite sure that theRedgatetool (can't remember the name) will
> integrate with SSMS  *and* can use SVN as the repository.  I'd be
> interested to hear what you find out on this front.
>
> Thanks,
>
> Bill

Hi,

The tool is SQL Source Control and it's still in its Early Access
phase, but you can sign up to try it out in the meantime:

http://www.red-gate.com/Products/SQL_Source_Control/index.htm

This integrates into SSMS and will allow you to commit changes made to
a development database to creation scripts in source control
(currently SVN, although TFS support will be coming soon). Let me know
if you have any questions.

Thanks,

David Atkinson
Red Gate Software
First  |  Prev  | 
Pages: 1 2 3
Prev: Help! Cannot delete an orphaned merge push subscription
Next: Moving SSRS Server not the database