CI on different database platforms

I want to开发者_运维知识库 test my application (especially SQL statements) against different databases. Actually I'm using Cruise Control and Oracle.

I want expand the tests with other databases.

Any suggestions?

Our software has a .config file with database configuration. If you can separate out the configuration in any way, f.eks like we do. Then you can duplicate the cruise control test project (TestsOracle, TestsMSSql) and switch the configuration in a task before the unit test task. We test for Oracle, MySql and SQL Server like that.

I also created a plugin that retrieves the code modifications from the build task, so for each test execution we can see the code modifications built into the actual unit test execution.

Hope that helps!