Update table structure

[johnnix]

Hello,

I begun adding Nexus DB on my app, firstly I created the tables I need using the Enterprise Manager and then created the source code using the Code Generator. When my app starts it will check if the tables exist otherwise it will create them using the code.

In the near future I may need to add a new field on a table or create a new index etc what is the best practice to do so? I am totally new at this so need some guidance from more experienced users

Thank you all for your time!

> I begun adding Nexus DB on my app, firstly I created the tables I need
> using the Enterprise Manager and then created the source code using
> the Code Generator. When my app starts it will check if the tables
> exist otherwise it will create them using the code.
>
> In the near future I may need to add a new field on a table or create
> a new index etc what is the best practice to do so? I am totally new
> at this so need some guidance from more experienced users

In the Source Code Generator, tick the box for "Generate database
evolution code", make sure you generate the code for the latest
database version and compile that into your program, and call the
evolution method that's created for you in the source code unit.

Note that straight field additions or deletions should be handled
automatically, but field renaming is not handled automatically
currently.

--

Eivind [NX]

[johnnix]

Thank you so much for the prompt reply!