My original, and admittedly very basic understanding of how the SQL (.SqlDataProvider) files worked is that the newest file (03.03.08) got ran, and the rest got ignored.

Obviously this is not the case, as the 03.03.08.SqlDataProvider file only has one stored procedure in it. But it also drops several stored procedures, which is what is confusing me.

I am attempting to figure out what order they run in. If they go from oldest (03.01.00) to highest (03.03.08), then some stored procedures would be dropped and not changed. But if they go in reverse order, then some of the files would be attempting to update a table that isn't there, and thus the changes wouldn't be made.

So, just what determines how the scripts are ran? If I have some spare time I would like to ultimately coalesce all of the files into one, so maintaining them for my own use is easier.

Thanks.