Ask Your Question

Importing data from data file to a new data base

asked 2017-01-19 20:37:43 +0100

Polimorphius gravatar image

My data base got corrupted and with and I/O error, after investigating a bit and following some instructions I was able to disassemble the .ODB, the following root structure was discovered: [folder] Configuration2 [folder] database [folder] forms [folder] META-INF [folder] reports [file] context.xml [file] mimtype [file] settings.xml

A data file located under "database" folder was extracted. I have created a new .odb database and try to import the content from the data file by extracting the content of the new database file and replacing it with the content of the old database file. However, the data is not being imported using this method.

I have also opened the data file with a text editor but some of the content becomes cryptic such dates and times. Also the copy and paste feature does not work. Importing the data in three different ways has failed.

I am looking on a way I can import the data from the data file that was extracted from the .odb database. Any ideas how to accomplish this without losing any data?

Any help appreciated.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-20 02:50:41 +0100

Ratslinger gravatar image

Copying the data file is not enough. Other files in the database folder are necessary for definition. The script file contains the details of the tables used. The properties file contains the information of the HSQL being used. Your best bet is to copy the entire contents of this folder into the newly created .odb you have.

The result may not work depending on what was actually corrupted in the .odb but it can't hurt to try it.

Embedded databases are vulnerable to data loss. To help protect against this, you should use a split or external database.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-19 20:37:43 +0100

Seen: 132 times

Last updated: Jan 20 '17