We have several NSB projects using NSB5 with transport persistence of nhibernate. After upgrading to NSB6 we switched to Sql server persistence. During development everything works fine (because the nuget package NServiceBus.Persistence.Sql.MsBuild). When we deploy (we always set EnableInstallers to true) however the scripts are not available. They are not copied to the publishedWebsite folder.
What is the best practice in this approach?
Copy these manually
Can we get away with checking in our scripts? Can we change the folder in which the files are searched for by the NSB proces? (https://docs.particular.net/persistence/sql/controlling-script-generation#promotion)
Only EnableInstallers during dev and manually run scripts on other environments?
Thanks for the feedback.