Command line options?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Command line options?

Postby mksql » Tue Aug 03, 2010 4:25 pm

In the past I have used other homegrown SCC mechanisms with a nightly diff and checkin job to get a report of changes to DB schema.

Is it possible to use Red-Gate Source Control to checkin detected changes in an automated fashion, with a static checkin comment?
mksql
 
Posts: 6
Joined: Fri Mar 05, 2010 10:35 pm

Postby David Atkinson » Tue Aug 03, 2010 6:29 pm

Yes, this should be straightforward.

You would use the SQL Compare Pro command line to synchronize your database to a scripts folder. Using your source control command line tool, you would then commit the scripts folder to your source control repository.

Please give this a go and let us know if you come across any problems, as we'd be very pleased to help.

Kind regards,

David Atkinson
Product Manager
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby mksql » Tue Aug 03, 2010 7:17 pm

This will work exactly as I need.

Thanks.
mksql
 
Posts: 6
Joined: Fri Mar 05, 2010 10:35 pm


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests