Tools for automated deployment of database changes

[Former Member]

What tools are people using for automated deployment of database changes to development and production database, like added tables and stored procedures?

For SQL Server there are tools from Red gate for achieving continuous integration and continuous deployment of databases, their tools also integrate with build severs like visual studio team services, so it will fit in with the build and release workflow for the application that uses the database

Is there anything similar for SQL Anywhere?

If not, any suggestions how to achieve automated database updates with scripts?

I started trying to do something simple with dbisql, but am having difficulties with running scripts conditionally (e.g. if database version < 1 run script 1.sql) and doing things like creating tables in a transaction

[Breck_Carter]

> creating tables in a transaction

There are some fundamental differences between SQL Anywhere and other products, and the fact DDL statements have COMMIT as a side-effect is one of them.

[reimer_pods]

You may get some ideas from the answers to this question: "How do yo version control your schema"