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

asked 08 Jun, 05:01

jobencol's gravatar image

jobencol
4125
accept rate: 0%

edited 08 Jun, 09:16

Graeme%20Perrow's gravatar image

Graeme Perrow
8.7k374112

1

> 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.

(09 Jun, 09:28) Breck Carter

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

permanent link

answered 09 Jun, 08:11

Reimer%20Pods's gravatar image

Reimer Pods
4.2k354684
accept rate: 11%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×415
×82

question asked: 08 Jun, 05:01

question was seen: 214 times

last updated: 09 Jun, 09:28