Lianja Server and Table management

[phabio]

Is planned to add a Table maintenance at Server Manager?
Something like SQL Server Management Studio?

In a LAN Environment, during the development lifecycle, if I need to change some table, how can I do?

From what I understand, I should use the App Builder to draw tables, then I copy everything in the folder of the server (for example: C: \ Lianja \ cloudserver \ tenants \ public \ data \).

But how do I then do maintenance?

thanks
Fabio

[barrymavin]

You currently have to write an upgrade script that uses the tableexists(), columnexists(), indexexists() functions.

We are planning to add database compare to the "Deploy" workspace that will generate the upgrade script for you. That's why those functions were implemented in fact. This will not be available until v2 unless sponsored for earlier availability.

There are other functions that can be used to get data dictionary rules, compare them and generate ALTER TABLE commands as part if the upgrade script.

[phabio]

Ok Barry.
I've also tryed with Database.net, a very usefull utility to view and manage remote DB.

After set the DNS, I can see the table... but unfortunately I cannot execute a select or modify the structure..

ciao
Fabio