Continuous integration for database changes

Question

I want to implement continuous integration for database changes. I want to know how to do that and what are the activities we have to do as part of CI for db(eg: create db/execute scripts/xx).

CI: Jenkins DB: SQL Server

I dont want to use any tool like RedGate... Let me know your thoughts.

Thanks

Answer 1

A nice tool that can track and maintain change sets of your DB schema is Liquibase. A friendly Apache 2.0 license, multiple formats support for storing the change sets in your VCS, a possibility to generate HTML documentation with a summary of changes and couple of other features makes this a nice match. I am currently using this tool in several projects quite effectively, good stuff...