Database Schema File (*.vdb)
- Jacob Pagnotta
- Julian Muir
- Aryn Wiebe
- Eliot Muir
What is a VDB file?
It stands for visual database file - it’s a simple way to describe the tables within a database which then makes it easier to work with databases within Iguana X.
Iguana includes a GUI editor which allows you to easily create or edit VDB files, defining tables and their key fields. You can also look at VDB files without an editor in a very simple to read JSON format.
Note: It is recommended that column names do not contain spaces (ex. First Name). If column names have spaces, db.merge will not be able to be used and instead will have to write and execute SQL statements from the Translator.
If you want to use merge with spaces in column names you can use the custom merge module https://help.interfaceware.com/v6/customize-custom_merge-lua-for-table-and-field-names-with-spaces
Â