Iguana X IguanaX 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, and MariaDB.
| Expand |
|---|
| title | STEP 1: Open a VDB file and click EXPORT.Export |
|---|
|
Simply open your VDB file and click EXPORT Export.  Image Removed Image Added |
| Expand |
|---|
| title | STEP 2: Use Enter your database connection details to the SQL Export tool to generate SQL statements to create the VDB tables in your desired database |
|---|
|
Use the SQL Export tool to generate SQL statements to create the defined VDB tables in your desired database. Type: Select the Database API for the database database and API connection method 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 SQLiteODBC database connections, use the absolute path or the relative path (if in the component project file) system data source name as specified in ODBC. For Oracle OCI, use the OCI TNS Alias (database server name). For MySQL use the database name. For SQLite, browse to the path of the .sqlite target database file. For ODBC connections, use the data source name as specified in ODBC.
Database (for ODBC): The name of the target database. Username and Password: If required, enter the Database name and credentialsyour database login credentials.
 Image Added |
| Expand |
|---|
| title | STEP 3: Generate the SQL, make necessary modifications and execute |
|---|
|
Click Generate SQL to see the prepared SQL statement. 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.
 Image RemovedWhen ready, click Export to execute the prepared SQL statement and generate your VDB tables in your database.
 Image Added |