|
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 |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 08 Jun '17, 05:01
question was seen: 1,668 times
last updated: 09 Jun '17, 09:28
> 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.