Exporting from OpenOffice Base database to SQL

By -

I was wanting to export the contents and design of an OpenOffice.org Base database to SQL with the intent of migrating to MySQL. I struggled to find out how to do this, but finally found out how.

To generate an SQL file that contains both the contents and the data of the database I used the following command from the “Tools –> SQL…” menu:

SCRIPT 'C:\temp\file.sql'

When I tried to write it to the C:\ root directory I got a security error, but using another directory worked fine.

Thanks to http://www.oooforum.org/forum/viewtopic.phtml?t=32333 for pointing me in the right direction.

Incidentally, on my way to the final solution I also came across the following command to generate a CSV file of a table’s contents:

SELECT * INTO TEXT "output_csv_file_name" FROM "table_name"

The version of OpenOffice I was using was OpenOffice.org 3.3.0 – OOO330m20 (Build:9567) and I running this on a Windows 7 machine.

Comments

  1. AnonymousNovember 8, 2012 at 5:29 AM

    Wow - nice job, especially SCRIPT solution.
    Just looking for that.
    And it works!

    Thanks.

    ReplyDelete
  2. AnonymousSeptember 5, 2013 at 5:01 AM

    Works great! Saved my day!
    Thanks!

    ReplyDelete
  3. AnonymousMarch 12, 2016 at 12:17 AM

    that's what i've been looking for :)
    thanks

    ReplyDelete

Post a Comment

Popular posts from this blog

Solution: Getting macOS Messages to work with Google Chat / Talk / Hangouts in High Sierra

By -
Image
The Messages application wasn't working for me on macOS and I was wanting it to work with my Google Chat / Talk / Hangouts service. It appears that with macOS High Sierra a workaround is required. After struggling to get it going I finally got it going after some searching on the Internet and trying a couple of supposed fixes. What ended up working for me were the instructions on  https://forums.macrumors.com/threads/gtalk-messages-solution-found-high-sierra.2073393/ with a couple of tweaks. The tweaks were required to support 2FA which is enabled on my account. The instructions, repeated here so that I can find them again if required and to assist others having the same problem, are as follows: Go to System Preferences / Internet Accounts and delete your google account. Open Terminal and run the following commands (Warning: This will delete your history!): find ~/Library/Preferences -name "*iChat*" -delete rm -rf ~/Library/Caches/com.apple.Messages rm -rf...
Read more

Using Raspberry Pi as a Time Capsule to backup a Mac

By -
Image
Time Machine is the built-in backup feature of OS X. It keeps a copy of all your files, and remembers how your system looked on any given day so you can revisit your Mac as it appeared in the past. Apple sells a device called a Time Capsule, but rather than buy one of these I opted for a diy approach using my  Raspberry Pi  and so far it seems to be working well. My setup consists of: Raspberry Pi Model B running Raspbian connected via network cable to a router MacBook Pro running OS X Yosemite v10.10.1 connected via Wifi to a router External 2TB drive (with separate power) attached via USB to the Raspberry Pi It was relatively easy to setup following the instructions at  http://www.raspberrypi.org/forums/viewtopic.php?f=36&t=47029  . I am reiterating the instructions here just in case the page disappears (with a couple of additions I needed): 1. Start with a clean installation of Raspbian, configured for your network 2. Power down your Pi, con...
Read more

IT & Enterprise Architecture Conference 2015 - Day 2

By -
Today was the second and final day of the IT & Enterprise Architecture Conference 2015. Below is a summary of my key notes. Going beyond IT. What EA can really mean for your organisation John Pearson, Business Architect, IAG Consider the Demand vs Supply side of architecture IAG is using traditional TOGAF domains (Information, Application, Technology Infrastructure and Security) with business architecture being used to better align with the demand from the business Enterprise Business Motivation Model (EBMM) - Accenture, Nick Malik ( http://www.motivationmodel.com/ ) anchor diagram for business architecture using to understand change impact Bake business architecture approaches in early in the architecture journey Understand the business, its priorities and where value can be added Understand architecture capabilities in service to the business Understand key stakeholder n...
Read more