ER2SQL is a Ruby script that transforms an ER diagram made in Dia into SQL statements.
Using er2sql couldn't be easier. Simply run the script with the path to your Dia file as an argument, and specify the output file name. For example, if you have a Dia file called "family.dia" that you want to convert to SQL, you would run the command "er2sql family.dia" and specify the output file name as "family.sql".
One important note: make sure that your Dia file is not saved with the "Compress diagram file" option, as this can cause issues with the conversion process.
To use er2sql, all you need is Ruby installed on your computer. The script is compatible with Ruby 1.8 and above, so you can be confident that it will work on almost any system.
This latest release of er2sql includes some important bug fixes and improvements. Specifically, the script now resolves foreign keys when using the plural form of a table name (with an "s" at the end), and checks for circular dependencies to prevent errors in your SQL statements.
Overall, ER to SQL converter (er2sql) is an excellent choice for anyone who needs to quickly and easily convert er-diagrams into usable SQL statements. With its user-friendly interface and powerful features, this script is sure to be a valuable addition to your software toolkit.
Version 0.1.1: N/A