When Exporting SQL, Allow User to Split by creating 1 SQL File for each Specific Database Object Types

[brian-ceccarelli]

1. When exporting, I want to pgModeler to create files like "create_tables.sql", "create_functions.sql", "create_fk_contraints.sql" . . . . One file that creates all the objects of a specific type.

I believe you only need to add a option to the Split drop down box.

2. Add the check box to SQL file export: "Generate DROP statements too."

Right now you commented the "drop" statements.

Many times, I only need to replace all the functions in an existing database. Or all the triggers. Or all the defaults, etc.
Also when I have database-object-specific scripts, I can run those scripts in a particular order. I can then migrate a database in place, data and all.

We generate SQL scripts and run those scripts against many instances of the database. We do not use export to a Database Server.