Search code examples
mysqldatabase-migrationsqlanywhere

Import backed-up SQL Anywhere 10 .db file into MySQL 5.1

I have a backup of a database from a week ago. I need to import this into MySQL without access to the original database server. Despite my boss's knowledge that I am nowhere near a database administrator; how do I do this?

Solution

  • No one will provide an answer because (a) it is illegal, and (b) it is against the website rules.

    If you have legal access to the database server:

    • which means the first option is to get a licence for ASA, rather than using MySQL. It takes one single command to load the .DB file into it

    • legal access means both access to the building and to a licence which will allow you to access the server and the data via whatever client you use.

    Responses to Comments

    1. Annoyances are part of life in the profession. If the db group may well have decided that you are not permitted to have something; that is company security policy that you or your boss have to deal with outside the software.

    2. Why can't the ASA Team just give you access to the ASA database ? Then you can connect and do whatever you want; have a look at database; understand it better; get current data at any time, without making a copy. Making a copy of a database is a stupid thing to do (the corporation then has two copies of data that it needs to be supported, maintained, administered and synchronised). The dicsion should not be taken lightly

    If you stick with MySQL at your end:

    1. Then you need them to export the database in a format that you can import. I do not see why you have to tell them which command[s] to use, they should know their commands well. Also there are different ways of getting the same result. If they need help, give them this link. You should also read and understand this chapter:

      Link to Sybase ASA Users Guide/Ch 21 Importing and Exporting Data

      • Get them to provide you with:
        • the Data Model, so you can create your own db on the MySQL side, and understand the table sequence to load
        • each of their tables exported in a character format (usually CSV), so that you can load each into your tables
        • what command they used, so that you know what to expect and how to treat the export files they send you.
          .
    2. After you have loaded your db the first time, you can modulate your subsequent requests to the ASA Team (eg. probably request specific tables only, or some other format, etc).