Is there a way to limit SQL Server Developer Edition to features found in more restrictive versions?

Question

Essentially, we're developing for mostly SQL Server Web Edition for some databases and SQL Server Standard Edition for others. We'd like to prevent the possibility of introducing a feature such as vardecimal in development if it won't be supported in the staging (and consequently production) versions.

Ideally there would be an option similar to compatibility level.

Thanks!

Answer 1

There is no such feature from Microsoft, but Kimble Group strongly advise in their The Microsoft Data Warehouse Toolkit to push the code through test or UAT environments (hopefully through continuous integration) where the version/edition would match the production. That of course relies on the assumption that most often this is the deployment strategy anyway.