schema changes between versions

Classic Servoy
1

Hi

Could someone please enlighten me as to how far Servoy (v2) will go to migrate schema changes between different releases. For example, if I make schema changes in MySQL in development, add columns, create indexes etc using an external tool, run Servoy developer, export the solution with a new release, will all my schema changes including indexes be migrated when I deploy it on the server?

I’d just like to know if I need to maintain some SQL scripts that I can rerun on the server to recreate my indexes, schema changes etc, or will Servoy handle all changes.

Thanks in advance.

Sham

2

Hi Sham,

Servoy only takes care of any table and column changes.
Any foreign key constraints, database sequences, indexes, functions, stored procedures, triggers, etc. used in the database are not handled by Servoy with deployment.

So yes, if you use one of the aforementioned objects you need to maintain some SQL DDL (Data Definition Language) scripts for deploying your solutions.

3

Many thanks Robert for the quick reply.

Sham