How to use dbdeploy with SQL Server?

Question

I need help in setting up dbdeploy for my SQL Server database and MySQL Server.

The example in the dbdeploy website does not tell me how to set the drivers for SQL Server and MySQL. Am a bit lost.

Sample scripts will be appreciated.

Thanks

Answer 1

I tried to use dbdeploy for my project with MSSQL 2008 But I didn't like it and now for MS SQL we use Agile DBRIRE

Answer 2

As part of some ReadyRoll market research we commissioned a poll in the Simple Talk newsletter which revealed that DBUp is now the most adopted database migrations tool after EF migrations, so it would be worth considering this solution as an alternative to DBDeploy.

(Simple Talk's audience is primarily people who use the .NET/SQL Server stack)

Disclaimer: I work for Redgate and the research described above was focused on understanding how ReadyRoll could provide additional value on existing OSS migrations-based solutions.