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?