I'm looking into database versioning using the DDL Data Source function.
1. Is it possible to organize the generated SQL scripts into folders based on schema & object type like the Database Explorer does? Right now, everything is under schema.
2. If I wish to add script to initialize a table with data, it should not be placed in the generated script files because it will be overwritten. Correct?
3. The general workflow is to create, modify, delete database objects using the GUI tools & let the DDL Data Source files auto sync if turned on. Correct? The workflow is NOT to modify DDL Data Source script files & push to the database. Right? Or can it work both ways?