Hi Folks - I’ve realised that my export of a solution with data has only exported the tables that have a current form associated. This has left my development solution with a number of tables missing in comparison to the original!
I’m exporting from my development environment with MSSQL and importing to another development environment with MySQL.
I know there are a couple of data converters available from MSSQL to MySQL but unfortunately I don’t have an environment where they are both (servers) installed currently (a text based converter that I’ve come across needs VB6 runtime and some other attributes that I don’t have installed either).
I would imagine that I’d need to have a form related to every table in the solution to have it referenced in the repository, but is there another way to ensure these other tables in the database get exported from my dev solution?
Well, out of my head I think that creating a bunch of bogus forms is the quicker way, a good practice would be to name them like “DEV_formname” just to be sure that you’ll remember why they are there in a few months
ngervasi:
Well, out of my head I think that creating a bunch of bogus forms is the quicker way, a good practice would be to name them like “DEV_formname” just to be sure that you’ll remember why they are there in a few months
Thanks Nicola - thats really where I’m at too - at least I know I’ve not missed a point now!
Actually it exports any referenced table (form, relation, valuelist, calculation, aggregation). I don’t think there is another way to export everything.
lwjwillemsen:
Room for improvement within the Servoy solution export imho…
As you can see below there’s already a checkbox to export every table from a single referenced server. (this has been around for a while…)
So in case you have 4 databases with just any number of tables in it, you only need to reference a random table of each database and tick this checkbox.
