Re: Howto get a EDB database to mysql format?
- Posted by DerekParnell (admin) Jun 01, 2010
- 1423 views
Hello,
I have a edb database(the EDS System), wich i would like to export to text, csv, or mysql format.
I found a few tools in the user contributions, but cant get any of them to work.
Does someone have a tip wich tool i could use for this?
Thanks in advance!
The short answer is that there is no tool already written to do this.
The reason is that EDS databases have capabilities that are difficult to express in TEXT or CSV formats, and maybe be impossible for relational D/B like MySQL. Also, EDS does NOT have some capabilities that are assumed in traditional D/B, such as storing information about the records in the data base itself, eg. field names and indexes.
Thus there is no generic tool to do this. Instead, each case needs to be dealt with on its own basis.
Why do you need to export it? Is it going to be used by some non-Euphoria application? If so, what format would that application prefer to use?
Is your EDS database one of the simpler types in so far as it has fixed format records that do not have nested sequences? If so, this can be exported without too much effort.
The choice between TEXT, CSV, and SQL is very important as the approach to exporting the data will depend a great deal on that.
For TEXT, you need to decide on how to delimit fields, records and tables. For example, you could use XML or JSON formats, or devise your own.
For CSV, you need to decide on whether to supply field names or not.
For SQL, is it just the data you need or are you going to build a new SQL database from the exported data? In which case, you need to supply meta-data about the fields, records, and tables.
It comes down to knowing more about what is going to use the exported data and making it easier for that to happen. Once you know that, it makes your choices easier.
But in the end, you (or someone) will have to write some custom exporting tool for your particular EDS database.
