SQL Server Compatibility with older DotNetNuke versions

I'm trying to determine whether DNN 2.0.4 will be compatible with SQL Server 2005 SP4. 开发者_高级运维My company is upgrading their server framework and they're trying to determine (without testing obviously...) if the SQL upgrade will blow up some of their older DNN sites.

I've trolled the boards, liberally dusted with Google magic and even skimmed through the super user manual. The nearest I've been able to get to an answer is that the latest version REQUIRES SQL Server 2005 but there's no indication that it will work with the older DNN.

Anybody out there have any concrete experience I can fall back on?

Because of the large installed base and wide variety of environments, the DNN core team has focused on using very standard SQL and I think if there was any problem, your searching would have turned something up.

Also, I'm not aware of any breaking changes or features in SQL Server 2000 that were removed in SQL Server 2005.

You should be fine. If you do run into a problem it's much more likely to be with a 3rd party module rather than the core. Some 3rd party modules were much quicker to begin to use the new capabilities of SQL Server 2005 and in general are less likely to follow standards or be tested as extensively in a wide variety of environments.

I am running 2.1.2 on SQL Server 2005 without issues. I think that the same would be true of 2.0.4.