Automated SQL source code control

25 Jul 2006 4:30 PM

Aaron S

I'm looking for a utility that will automatically extract the DDL I
specify from a database and/or SQL Server and check it into VSS if the
SQL code has changed. I've tried Bill Wunder's DDL Archive Utility, but
I'm getting errors with it that I haven't been able to resolve in two
weeks of troubleshooting. Does anyone have any other recommendations?
I/we could really use something like this around here.

Thanks,
Aaron

25 Jul 2006 6:58 PM

Andrew J. Kelly

http://www.innovartis.co.uk/home.aspx

--
Andrew J. Kelly SQL MVP

Show quote

"Aaron S" <gcsd***@yahoo.com> wrote in message
news:1153845034.848260.284990@p79g2000cwp.googlegroups.com...
> I'm looking for a utility that will automatically extract the DDL I
> specify from a database and/or SQL Server and check it into VSS if the
> SQL code has changed. I've tried Bill Wunder's DDL Archive Utility, but
> I'm getting errors with it that I haven't been able to resolve in two
> weeks of troubleshooting. Does anyone have any other recommendations?
> I/we could really use something like this around here.
>
> Thanks,
> Aaron
>

8 Aug 2006 3:46 PM

Bill Ramos [MSFT]

If your looking for a future Microsoft solution - check out the Visual
Studio Team Server Database toolset at
http://msdn.microsoft.com/vstudio/teamsystem/dbpro/default.aspx

--
Bill Ramos, Lead PM, SQL Server Manageability
This posting is provided "AS IS" with no warranties, and confers no rights

Show quote

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:uiArrxBsGHA.4732@TK2MSFTNGP03.phx.gbl...
> http://www.innovartis.co.uk/home.aspx
>
>
> --
> Andrew J. Kelly SQL MVP
>
> "Aaron S" <gcsd***@yahoo.com> wrote in message
> news:1153845034.848260.284990@p79g2000cwp.googlegroups.com...
>> I'm looking for a utility that will automatically extract the DDL I
>> specify from a database and/or SQL Server and check it into VSS if the
>> SQL code has changed. I've tried Bill Wunder's DDL Archive Utility, but
>> I'm getting errors with it that I haven't been able to resolve in two
>> weeks of troubleshooting. Does anyone have any other recommendations?
>> I/we could really use something like this around here.
>>
>> Thanks,
>> Aaron
>>
>
>

5 Sep 2006 12:18 PM

DavidRedGate

Source control support for database schemas seem to be increasingly
important to database professional and therefore Red Gate is looking to
build in source control support to its existing tool suite. If you
think you can help us fashion a solution or would like to give us your
thoughts on this topic, please email me, respond to this posting, or
post to our forum at
http://www.red-gate.com/MessageBoard/viewtopic.php?t=2980

Many thanks!

David Atkinson
Product Management
Red Gate Software

Bill Ramos [MSFT] wrote:
Show quote

> If your looking for a future Microsoft solution - check out the Visual
> Studio Team Server Database toolset at
> http://msdn.microsoft.com/vstudio/teamsystem/dbpro/default.aspx
>
> --
> Bill Ramos, Lead PM, SQL Server Manageability
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:uiArrxBsGHA.4732@TK2MSFTNGP03.phx.gbl...
> > http://www.innovartis.co.uk/home.aspx
> >
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> > "Aaron S" <gcsd***@yahoo.com> wrote in message
> > news:1153845034.848260.284990@p79g2000cwp.googlegroups.com...
> >> I'm looking for a utility that will automatically extract the DDL I
> >> specify from a database and/or SQL Server and check it into VSS if the
> >> SQL code has changed. I've tried Bill Wunder's DDL Archive Utility, but
> >> I'm getting errors with it that I haven't been able to resolve in two
> >> weeks of troubleshooting. Does anyone have any other recommendations?
> >> I/we could really use something like this around here.
> >>
> >> Thanks,
> >> Aaron
> >>
> >
> >