How can I move my database from LibreBase to Sql Server 17?

How can I move my database from LibreBase to Sql Server 17.

Ive tried Google search but i cant get a definitive answer.

Thanks for any help offered.

Hello,

There is no ‘definitive’ answer.

You do not specify which database you are using with Base. Base is just a front end to connect to a database. LO ships with HSQLDB embedded and Firebird embedded databases. You can choose to connect to one of these or through connectors to a variety of other databases.

How data is moved can be through a spreadsheet, a utility program or even just copy tables from one Base connection to another. There are field types to consider. They could match up nicely but they could, depending on types you already use, be of different names. Then there is SQL such as queries. There could be differences which need to be modified manually.

Have moved data between various databases in many ways but no two were identical. Used different methods depending upon the databases involved.

This is really not an LO situation but rather a database question and databases vary in many ways. Discussion of this type could become lengthy and overly involved - not something this site is designed for.

Thanks for reply, Im using an HSQLDB Database. Would I need to copy it from Base to Excel and then Import the Tables into Sql?

Haven’t used SQL server (any version that I can remember) so it is not my knowledge as to how it accepts data in creating tables. Am currently on Linux and abandoned M$ some time ago.

Personally, I would attempt to create a connection to SQL server (using JDBC or ODBC connector) with Base. With that you should be able to copy/paste from one to another with limited problems. Have done this with HSQLDB embedded to Firebird, MySQL and PostgreSQL servers.

Thanks I’ll look into that