[Solved] Keep ODB file & reports/forms, change DB connection

[psb777]

I've successfully prototyped a Base application with several complicated forms and reports.

Now I wish to deploy the app to a live environment which means I need to use a different database. I have been using the embedded HSQL database. I can connect to MySQL using the native driver and I have registered the database.

What I would like to do now is to keep the reports and forms I have developed but to just change the database connection to use the external data. There seems to be no way of doing this.

The Edit->Database->Properties and Connection type are greyed out. How do I change the database connection but keep my forms and reports. Alternatively, how do I import my reports and forms into a different ODB file?

[r4zoli]

Alternatively, how do I import my reports and forms into a different ODB file?

Drag and drop into new file, the properties Data tab you must set new data source for each form/report.

[psb777]

OK, thanks, that works. I had almost given up.

But whereas some tinkering is still required, I don't think I'll have to reset the data source - I have already got that working when I created the new ODB file.

And rather than drag and drop for the database itself I think the tables are better done by creating and editing the SQL script using the HSQL "script" command - there are database incompatibilities such as column types and foreign keys which must be resolved. I wish now I had started using MySQL and never bothered with HSQL.