Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
DatabaseInterBase

Importing and exporting data with IBConsole

ibimport-export

There are several options available for migrating or importing data with InterBase databases. No matter if you are migrating and need to import data into your new database or exporting your data to use in third party systems. One of those options is IBConsole. IBConsole provides you with an easy to use format for both exporting and importing data into your IB databases.

For this example, we will be using the Employee database for InterBase that is included with your RAD Studio installation.

You can locate the Employee database in IBConsole from: C:UsersPublicDocumentsEmbarcaderoStudio21.0SamplesDataEMPLOYEE.GDB

Importing data

If you’re importing data to a new InterBase database make sure that you have your schema set up. After you have created your table in IBConsole (or other tools that can execute sql statements supporting InterBase databases), then you can import your text, csv, xml or raw IB data into your table.

Exporting data

In some cases, you may need to pull data from your InterBase database for third party reporting or integration with other applications.

Take a look at this video which explains how to use IBConsole to export and import data in InterBase.


What's New for RAD Studio 11

Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

Related posts
InterBaseRAD Studio

How To Deploy RAD Server With An InterBase DB To Docker

News

Tracking Changes with InterBase Change Views

DatabaseInterBaseNews

Journaling for Disaster Recovery in InterBase

News

Hit the Ground Running with InterBase

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES