| 
| 
Why Select Lava Distributed SQL?
Easy and Powerful Import Facilities
It is important to most new database users to be able to import data from an existing database. In order to support this critical first task, the Lava development system offers facilities to render accessing and importing data from other databases a snap.
Automatic import of foreign tables into the Dictionary
The Blueprint development system has a comprehensive Entity Relationship Diagrammer which is fully integrated into the project system. In order to facilitate the import of foreign data, this interface allows the direct import of table structures from compliant databases1, creating a complete table entry in the current entity-relationship diagram.
Automatic generation of import code
Once a set of tables have been imported into a dictionary within the Blueprint development environment, a code generation template provides the ability to generate LavaStream source code dedicated to the import of these tables. The programmer only has to add code where custom data translation is required.
In addition, the generation template is itself written in LavaStream, and is provided in order that any customization required may be undertaken.
Ample examples
A number of working examples of data imports, ranging from simple to complex, small to large, are provided. From these, even databases not supported by the import mechanism may be accessed.
1 In order to allow import of data tables, the source database must have high ODBC 3 compliancy. This is, for example, true of databases such as MySQL and Oracle. It should be true of most databases. There are exceptions, though - for example, Pervasive SQL does not have adequate functionality to support table structure import