I'm trying to setup a good workflow for versioning our MSSQL databases, and using DbUp for deployment. So I have a bunch of scripts with names like "Script-<version>.<part>.sql". So I'm setting up a DDL data source for each version, adding the corresponding scripts for each part in the right order, and each version extending the previous version.
I haven't found much documentation on DDL data sources, is this how it's supposed to work? For some reason, it doesn't recognize changes (ALTER statements) in higher versions, and is showing the original version of the tables for all DDL sources in the Database window. Also the inspector says "Unable to resolve 'X'".Maybe I'm just missing something trivial?