I'm working on building a module package and I think my understanding of how SqlDataProviders work is wrong. I was under the impression that they should be under the Providers/DataProviders/SqlDataProvider directory of the module. Is this still true?
Second, my module is at version 02.02.05. I have a SqlDataProvider of 01.00.00.SqlDataProvider in aforementioned directory (And an Uninstall of course). Is this correct? Should this script execute when I install the package?
The reason I ask is I just tried to install it as an upgrade and it decided to wipe my database / stored procedures. No harm done as its a test environment, but I want to know why, as it said it executed no SQL scripts when I looked at the list of things it supposedly did. ALSO a subsequent run through did not delete them again. I have yet to test installing on a fresh instance.
Any help / best practice advice would be appreciated.