Iguana X can be used to modify an existing database’s tables or generate a database and tables from VDB table definitions.
This functionality is supported for a variety of databases including SQLite, MS SQL Server, MySQL, Oracle, and PostgreSQL.
Simply open your VDB file and click EXPORT.
Use the SQL Export tool to generate SQL statements to create the defined VDB tables in your desired database.
Select the Database API for the database you want to connect and create tables in.
Add the Data Source: If the database does not exist in the path provided, the export tool will create the database and associated tables.
For SQLite, use the absolute path or the relative path (if in the component project file) of the .sqlite file.
For ODBC connections, use the data source name as specified in ODBC.
If required, enter the Database name and credentials.
Make any changes to the SQL as required.
You may notice, as you select different Database APIs, Iguana automatically generates the syntactically correct SQL statements to create the tables.
You can make any necessary edits to the SQL before executing. If a table already exists in your database, the table will be dropped and re-created to reflect your changes.
Click EXECUTE.
