IBM Security i2

Expand all | Collapse all

Import data to Ibase Database in SQL from Ibase Database in Access

  • 1.  Import data to Ibase Database in SQL from Ibase Database in Access

    Posted Fri March 05, 2021 05:34 AM
    Hello.

    Is it possible to have an Ibase Database in SQL, and import data from another Ibase Database but in Access?

    I know is possible to import from a normal access database ou SQL database, but  from ibase in access is it possible?

    Or i have to export in XLS ou XML the data from the Ibase Database in access and then import from those files to the other?

    Is it possible? An if so, what the steps to do it?

    Best regards to all

    ------------------------------
    Paulo Ribeiro
    ------------------------------


  • 2.  RE: Import data to Ibase Database in SQL from Ibase Database in Access

    Posted Mon March 08, 2021 02:33 AM

    I would imagine, the following steps would make it a lot easier to migrate data from Access to SQL Server:

    1. Make a copy of the Access database
    2. Upscale the Access database copy to SQL Server using iBase Designer
    3. Either use the upscaled databse directly - or create import specs in the master database, grapping the upscaled database content via ODBC


    Regards

    Michael



    ------------------------------
    Michael Bodstrup Hansen
    ------------------------------



  • 3.  RE: Import data to Ibase Database in SQL from Ibase Database in Access

    Posted Mon March 08, 2021 04:23 AM
    You would have to 1st understand the backend database schema and table structure of an iBase access database - all of which is proprietary information to IBM.  Not something we would disclose. Instead it is far simpler to export entity/link content from an existing iBase (Access or SQL database) to excel, using the very easy, nice to use excel interface, where you can select the entity/link type and specific fields therein ; to suit your import requirements (As source data) to your other database.
    export data to excel


    ------------------------------
    KEVIN GILLIS
    ------------------------------