Delete specific tables and table columns when importing

Servoy already adds columns and tables if they do not exist when a solution is imported. I would like the option to be able to delete table columns and entire tables if the table or column does not exist in the solution being imported. It could be an one of the options for importing a solutiion. It would be useful when supporting the same solution and backend at multiple locations.

It would also be very useful if one could import a file.sql [a file like the one that you can run in the SQL Query Analyzer in SQL Server] which would execute after the new solution had imported. This would be useful for database maintainance when supporting the same solution and backend at multiple locations.

John McCann

idoctor, you are my man! 8)
I vote for this one too!!

Now I’m doing alle the stuff afterwards in the client, which can be very timeconsuming!
This also gives Servoy the possibility to change columnnames, varchar sizes etc.. and put this in such a sql file, and run it after a new solution import.