In our environment our production server is using
MS SQL Server 2008 Enterprise Edition. We have a development and test server that runs
MS SQL Server Standard Edition and the table structure between all three environments is exactly the same.
We frequently refresh our dev and test environments from our production database.
I'm looking into turning on
data compression in our production environment, but reading this technet article it sounds like we will no longer be able to perform these refreshes. Am I reading this correctly?
Quote from article:
Databases with compressed tables or indexes cannot be restored, attached, or in any way used on other editions.
Will I be forced to upgrade our dev/test DB to
Enterprise Edition to continue to refresh our data?