User guide

REAL DBF2SQL

User guide.

Installation:

Unzip the compressed file in any folder, that’s all. Along with the executable program there are three more files, none of the 4 files should be modified.

Using the program.

When you start the program for the first time you will be prompted to select the language. You can then change the language while the program is running at any time. The next time you run the program, it will be displayed with the last selected language.

The program functions can be accessed from the menu or from the button bar.

You can select in the dialog box to open or save, view all files or just a certain type of files.

It is very common to have dBase files with another extension, the program will open them regardless of the extension they have, as long as they are files of type dBase. For example, clearly goods.txt is not a dBase file, the rest are.Once opened the file dBase COMPRAS.DAT besides being displayed can be edited, changes are saved automatically, so there is no “save” option. With the navigation buttons you can scroll, delete, edit and add only files of the dBase type.

You can change the decimal separator of the file being displayed and it will be applied to all numeric fields in the table.

You can apply predefined numeric formatting by selecting one from the list and then clicking on the title of each column to apply that format. You can also customize the format , just place the cursor in the text box below “Customize”, write the format and click on the titles of the columns. The same for the format of dates. To deselect the columns, press the “Clear Marked” button. The formats do not affect the database or the export.

Applying date format.

You can also change the width of the columns and change their position (drag and drop).

Exporting the dBase database open to SQLite:

Direct method: read and write log per record, approximately 10 records per second are processed, resulting in a SQLite database with a table that is open dBase file. For large databases (thousands of records) there are other methods much faster and will be described after explaining this method that for small files is possibly more comfortable.

You must specify the folder and the name and extension of the SQLite database to be created.

Notice that the operation is slow.

Export progress is displayed with a slash and the number of records processed.

You are notified when the export is complete.

Creating a SQLite script is an extremely fast export method, then the program can create an SQLite database of that script which is even faster, for example, creating a SQLite database through a 10 MB script With 50,000 records in just 2 seconds (or less).

This option will generate the script for the open dBase file.

Once the export is finished, the script created with its default flat text editor will open.

The generated script can quickly become a SQLite database by pressing this image or also from the menu or the button bar:

Only the script should be indicated, then the “Save as SQLite” button will be enabled from which you should indicate, as usual, the folder, name and extension of the SQLite database to be created. Finally the “Export” button will be enabled and the estimated time for the process to be delayed.

In a test run, a SQLite database was created from a SQL script (generated with this same program) of 278 MB with more than one and a half million records with more than 20 tables in less than one minute. This SQLite database was also successfully opened in this program.

Open a SQLite database:

We can view any SQLite database, not just those created by this program.

When you open the SQLite database you will be prompted to choose the table to view. This can be done by selecting and then clicking on “Open” or directly with a double click on the name of the table.To see another table in the SQLite database open, just select the table in the list of tables and click on “Open Table” or double click on the name of the table.

Batch Export:

It allows you to export one, hundreds or thousands of dBase files to both a SQL script and a SQLite database. You can convert hundreds of dBase files to a single SQLite database and / or SQL script. You can also create an SQLite database and / or SQL script for each of the selected dBase files.

All dBase files must be in the same folder, so it is recommended to create a folder and copy or move the files to be processed there. These dBase files are only read, not modified or deleted.

This export method is very fast.

Batch export is done through an export wizard consisting of 4 stages:

1. Information: as the name implies, the rules to follow and the results to be obtained are detailed.

2. File selection:

You must select the folder where the dBase files are located, then select the folder where the export will be saved, it can be the same but it is not recommended. Once the folders have been selected, the files must be selected, a file can be dragged and dropped from the source list to the destination list. You can also select multiple files and press “Add” or without selecting any file use “Add all”. “Remove” and “Remove All” deletes selected files.

Multiple selection (Click + Shift + Click) for contiguous files or click + Control + click for non-contiguous files.

Always use the bottom buttons to move around the wizard. Cancel: Closes the wizard.

3. Selection of the result:

“Export all to a single SQLite database and / or SQL script”: You can check the two boxes to get both the database and the SQL script. You can specify both the name and the extension of the database and the script. If you selected “Generate a single script” you can also select the option “Open Script when export ends” which will be done using your default flat text editor of your operating system.

“Export and generate a SQLite and / or Script database for each dBase file”: The SQLite databases created will have the same name as the dBase file but with the sqlite3 extension. The scripts will also retain the name of the dBase file but with the sql extension. The two options can be selected.

4. Confirmation:

The details of the export are detailed, if everything is correct you can start the export, otherwise you can use the “Back” button to make changes.

The process is very fast, in fact there is a 0.2 second pause between files.

SQL script generated by the program.

Message that appears when the export is finished.

To verify the database created you can use the database viewer SQLite that owns this program.

Create a SQLite database through a SQL script:

Although this feature has already been discussed, some screenshots will be shown that show how a SQLite database was created through a 278 MB SQL script with more than 1.5 million (1,500,000) records in less Of one minute, although the approximate time was calculated a little more than 350 seconds, the elapsed time did not reach the minute. While the data import is very fast, no progress bar is displayed so the button is pressed until the process is finished, but it should not be thought that the program stopped working, that is why it is indicated The estimated time. If the time elapsed exceeds the estimate, then we would be facing an error, which until now did not occur in the various tests performed with SQL scripts compatible with SQLite.

The user is always notified when the export is complete.

We open the SQLite database (157 MB) obtained from the 278 MB SQL script. 1,516,450 records viewed.

End.