fluentmigrator
Connectionless Journaling (create/log to VersionInfo)
I am trying to generate sql script to apply to db. When I use connected mode everything works, but when I use cfg.NoConnection = true; VersionInfo table is not created. It seems there is a difference between ConnectionlessVersionLoader and VersionLoader. ConnectionlessVersionLoader never runs VersionMigration.
@0xorial So I understand your issue:
- Greenfield deployment
- Database is created
- FluentMigrator has never run on this database
- Upon first run with FluentMigrator, you run it with
cfg.NoConnection = true;because you want to generate a script that you can verify, and run manually? And this script doesn't generate the VersionLoader table?
If so, if you run it with a NoConnection = false on a local test db, does the VersionLoader work then?
@jzabroski , thanks for your answer, it is exactly how you described. (one reason for me wanting to have an exact script is the fact we have to submit our migration scripts to dba team for approval :( )
If you're using In-Process Runner, can you please post your Program.cs so I can see how it's configured. You might be running into an issue related to the ScanInBuilder API discussed here: https://github.com/fluentmigrator/fluentmigrator/issues/1062#issuecomment-616598419