Importing Visual FoxPro Databases and Tables

Under Construction

See Also

Getting Started

Overview

This article explains how to import Visual FoxPro databases and tables for reuse in your Lianja Apps.

Importing Databases

Visual FoxPro databases (.dbc files) can be quickly and easily imported into the Lianja format for use in your Apps. To import a Visual FoxPro database, select the Data Workspace and make sure no database is open. You then have two ways to import your database: drag and drop import or the Import VFP database command.

Drag and Drop Import

Drag 'n' drop VFP database

To use drag and drop import:

• Open the .dbc file location in Windows Explorer
• Click on the .dbc file and drag it into the Databases explorer in the Sidebar

Open database

To open your imported database. double-click its name in the Databases explorer or select Open in the right-click context menu.

If you double-click the database name, the Tables explorer will be automatically selected. You can switch between the explorers using the tabs at any time.

Close database

Use the Close option in the right-click context menu or under Additional commands to close the database.

Import VFP database command

Import VFP database

To use the Import VFP database command:

• Using the right-click context menu or the Additional commands, click Import VFP database....
• Select your .dbc file from the popup Select a Visual FoxPro Database dialog.

Open tables

To open your imported database, double-click its name in the Database explorer.

In the Tables explorer, double-click a table's name to open it in the Data Editor.

Each open table will appear in its own tab.

Command Window

From the Lianja/VFP command window in the Console Workspace you can access your imported data using SQL statements or USE and other NoSQL commands.

Note that Lianja has automatically built the indexes for the imported tables.