Menu
How do I export a database from Isis to SQL?
I can export the database from Isis to iso. I believe that I could convert iso to dBase 3 and then dBase 3 to SQL, but I haven't found a way to do this yet.
405
SQLite is very lightweight compared to other database management systems like SQL Server, or Oracle. It has an in-memory library that you can call and use directly without installation or configuration. You do not require any dedicated server to store database. The database is stored in the hard disk of a computer.
File system is the simplest database.
Today, SQLite, MySQL, and PostgreSQL are the three most popular open-source relational database management systems in the world.
1) Use one of the following two lines - the 2nd (MODE) if you have repeatable subfields:
'"',v10,'","',v20,'"'/
mhl,'"',v10,'","',v20,'"'/
2) Save this format and use it to print to a file through the standard PRINT option (Menu database -> print)
3) Choose “Output to: ASCII file (Windows)” and select the correct print format from the list. Then click “Print”.
4) Give a name to the TXT file and click OK.
5) Either:
A) Run MS Excel and open the TXT file. Then import the data from Excel to SQL Server, OR
B) Load the flat file directly into SQL Server
Answered with help from David Strachnan's comment and the UNESCO CDS/ISIS FAQ
117
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
