I have LO 7.6.4.1 databases, and recently downloaded and installed LO 24.2. I know want to migrate or copy some of my existing databases from LO 7.6.41 to LO 24.2. I can copy the queries and forms ok, but not the tables. When I try, I get the copy table window , then select Definition and Data, Next, select all column headers/ name, but then I get message window or box which says No corresponding column type for each column in the table. each time I click OK, the said column type appears in the Apply Columns box or window, and eventually all column headers are showing. But after clicking on Create, the table does not appear.
I guess I am doing something wrong.
Why do you want to copy all the data from one Base file to another? You could use the same Base files in LO 24.2 as you have used in LO 7.6.4.
If you are getting errors by copying tables from one database engine to another database engine you have to look on the fields of the tables. It has nothing to do with LO 7.6.4 or LO 24.2. Might be there are used special field types, which are unknown in the target database.
The reason I was wanting to copy the all the data files is because I would like the LO24.2 database to connect to firebird .The LO 7.6.4.1 base file has a problem doing this, and that is the reason I installed LO 24.2, so it could be done.
Thanks
Firebird embedded or running as external database?
.
But in any case: If opening the .odb does not connect with 7.6 this is unlikely to change for 24.2
.
Or do you wish to convert a HSQLDB to Firebird?
Actually, I did manage to move or migrate 1 database file data etc over to LO24.2 earlier today, but it was a database file that was done for me using the data I provided. I don’t know which version of LO it was used to do that, so if it was 24.2, then that was probably why it did migrate??
I want to convert a HSQLDB to firebird, that was my plan, but if it won’t happen so be it. I think it is firebird external, as the database which wont copy / past the tables over is using a firebird external file :FBTest1.fdb
I really only want to use 1 LO program , rather than have an older version a well on my system.
Thanks
Data types in HSQLDB and Firebird aren’t always the same. You want to copy from HSQLDB to Firebird.
Datatype REAL in HSQLDB will be BLOB in FIREBIRD
Datatype VARCHAR_IGNORECASE doesen’t exist in FIREBIRD (use VARCHAR instead)
Datatype LONGVARCHAR in HSQLDB will be in CLOB in FIREBIRD
Datatype LONGVARBINARY in HSQLDB (used for Images) will be BLOB SUB_TYPE-9546 in FIREBIRD
The data types in the tables I want to copy are Decimal [DECIMAL], all numbers.
Are they different in firebird then?
Edit:
I found how to export and import tables, so I managed import 1 table from LO 7.6.4.1 and export or paste to LO 24.2…
Quite unlikely, as 24.2 was released only days ago…
Glad you solved your problem. It is still a mystery, why this was necessary. I’ve used different versions since StarOffice and what you describe was never necessary.
How do you mean about it is still a mystery, why this was necessary. What is.
Thanks
The problem: This has nothing to do with the version of LO (LO 7.6.4.1 and LO 24.2.0.2). Reason for the problem is: Changing the database from HSQLDB to Firebird and getting the right fieldtypes.
@avvy651 : Have a look at the decimal places, which are needed in the database. If it doesn’t work well: Copy the content to Calc first, then import it to Firebird.
1 Like
Yes that is what I found how to do it, but to me there is more than 1 way to c/p , and I chose the wrong method at first.
Anyway,due to some other problem to do with sdbc, I removed LO24.2 , deleted the new databases , and I’m staying with LO 7.6.4.1, and forgetting about Firebird.
thanks