Ask Your Question
0

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

asked 2019-09-30 17:15:22 +0100

Sums gravatar image

updated 2019-09-30 17:15:48 +0100

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2019-09-30 18:06:01 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more

Comments

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?

Sums gravatar imageSums ( 2019-09-30 18:09:15 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2019-09-30 18:17:47 +0100 )edit

Thanks I'll look into that

Sums gravatar imageSums ( 2019-09-30 19:43:50 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-30 17:15:22 +0100

Seen: 31 times

Last updated: Sep 30