Greetings,

I am running AOO 4.1.12 under Slackware Linux 14.2 (K4.4.301), with Mariadb 10.0.38 and mysql-connector-java 5.1.42.

I have two databases (separate mariadb database files and separate AOO .odb files) which I would like to work on and I have two questions about that work:

1. I would like to import the table structure (_Not_ the data), SQL
   queries, data entry forms, and maybe as a bonus, the reports, from
   one of the databases into the other database. Does Base have
   functions to do that (i.e. Ctrl-C / Ctrl-V across database lines) or
   do I need to reinvent the wheel and recreate the structures in the
   destination database?

2. If and when the above is done: within the same destination database,
   can I merge (i.e. copy-append) data within one table into the new
   database table created in #1 above?

I am pretty sure this can be done in Mariadb (MySql), but I think it would be more time-consuming and difficult without a GUI. The answers to these two questions will determine my procedure.

Thanks.

Girvin


Reply via email to