Command line options?

[mksql]

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?

[David Atkinson]

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

[mksql]

This will work exactly as I need.

Thanks.