dbdeploy.net
dbdeploy.net copied to clipboard
Is it possible to pass multiple folders in lastChangeToApply property?
I have multiple folders for different solution, like ABCompany/MetaSql (for ex: it contain sql files from number 1-10) ABCompany/SchemaSql (for ex: it contain sql files from number 1-12) DEFompany/MetaSql (for ex: it contain sql files from number 1-5) DEFompany/SchemaSql (for ex: it contain sql files from number 1-7) GHICompany/MetaSql (for ex: it contain sql files from number 1-15) GHICompany/SchemaSql (for ex: it contain sql files from number 1-11)
For example, now I want to execute following files only files whose number after 7(i.e. 8-10) from folder ABCompany/MetaSql only files whose number after 5(i.e. 6-12) from folder ABCompany/SchemaSql only files whose number after 2(i.e. 3-7) from folder DEFompany/SchemaSql
Now Why I want to do this is because let's say I downloaded my production Database in my QA box and it contains all the scripts except the listed above.
Is this possible?
Thanks Manoj
Not at the moment. If I had this requirement, I'd store the files as you mentioned in source control, and have a script which copies all of them into a separate folder and call dbdeploy with that.