Is there anyone who already has the following situation.
I have a Saas-model where there is 1 solution that is used by several (for example 30) customers.
When a customer is coming using a deeplink on his login page, then a switch server is done from the source database to the customer database. Each customer has his own database.
Now the situation where in my solution a have a new table or changed columns. I can make a solution export, and then in the Saas-environment I will do a import.
The problem is that when I do a import, then import uses the DB-connection on my source database to fill the repository and also update the data-database.
How do I have to update all customer databases? These 30 customer databases will use the updated solution, but they don’t have a database fix (table added, columns changed).
How can I update all my customer databases automatically (!)?
I have posted this request right away, when the switchserver function came available!. Because we bumped into the same issue!
still it can’t be done automaticly, by Servoy!
Is there a way that Servoy provides a SQL script with changes or do I have to keep in mind the database changes myself? In that case, one day that will go wrong
There are plenty of third party tools out there that can automatically make those scripts for you.
I use DbWrench myself because it does exactly what I want (reverse-/forward engineering) for my preferred platform(s).
In fact I prefer to NOT let Servoy create any database objects for me so I have more control on the actual created data types (number vs float, etc) and of course for the database managed sequences, foreign key constraints and indexes.
Yeah, but not every customer can be updated by hand, we dont have complete access to all customers.(only servoy admin-pages)
Servoy does a good job in updating the DB. As soon they implemented the switchServer option, I think it is logic that Servoy should provide a method or function, so we can update other DB’s also, if we just do an update of our solution.
As long as you are only adding new tables or columns. Servoy will not drop any columns for you, change their data type or length, create constraints or indices. So I think there is a need for “manual” maintenance once your data model gets a bit more complex than just a few tables.
As long as you are only adding new tables or columns. Servoy will not drop any columns for you, change their data type or length, create constraints or indices.
Servoy: please give us the ability, to auto fire an SQL method before the update and/or after the update. (ofcourse a restart of the servoy server is needed than)
(maybe defining this SQL in the solution??)
that prevents us from doing it by hand now, and that gives us the possibility to update, maintain, etc… servoy servers, without installing 3th party tools at our customers.