Ask Your Question

how to import data from another database

asked 2019-03-16 19:31:20 +0100

DavidDT gravatar image

how do I import data from superbase

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-03-16 20:42:02 +0100

Ratslinger gravatar image


First some explanation. Base (LO) currently comes HSQLDB embedded v1.8 and is being replaced with Firebird 3.0 embedded. Embedded DB's are single user only and are zipped into the Base file - thus embedded. Also note, Base can connect to a variety of different DB's using various connectors (SDBC, ODBC, JDBC) or tables can be constructed from delimited files. There are others but that presents many situations.

So in your case, it is not clear what you are wanting to import to. Most likely you are wanting to move away from 'superbase' (know nothing about it). You then need a connection to Base via a connector (you need to find) or create delimited files from your tables. Now if moving to a different database, you need to create a Base connection to the DB you intend to use.

Once you have the two items in place, usually it it just a copy/paste between the two.

In some cases, and nothing to do with LO, you can use third party software to copy data from one database to another. One utility is SQL Workbench/J but it doesn't mention anything about 'superbase'. This may be the challenge for you.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-16 19:31:20 +0100

Seen: 40 times

Last updated: Mar 16