Clay Lenhart

The query to look for an empty database is alright. If there are no tables (but views, etc), there's nothing to migrate, so the pre-sql scripts don't need to run....

One scenario is to split a table into two: parent and child. Columns A & B stay with the parent and columns C & D move to a new child...

In terms of design, one way to make this consistent with single-files and to have preactions/postactions nodes like: ``` schema myschema: owner: postgres ... postactions 20181108_system_user: |2 DO $body$ BEGIN...

I'd say DO statements are required -- it'd be useless without it. You need variables, control flow, etc to do anything slightly complicated. I'm optimistic that psycopg supports DO, b/c...

Right I see. I agree. Preactions should be executed on the target DB and before from_catalog is called. Sounds like it could have an impact on the code that begins...

Sounds more complicated than running SQL in filename order. Just my 2 cents.

Which language would you be looking to use? I don't know Python so it was a blocker to submitting pull requests. SQL is what your users know (and want to...

It’s coming back to me now. I had forgotten the idea is to use dbtoyaml rather than edit the yaml directly. I don’t know C++ either. Probably for the best....

The tools folder contains "packages.config.md5sum". Perhaps something similar can be done here to detect a change to Addins\packages.config.

Thanks -- looking forward to it. :)