July 13, 2012 at 4:13 am
Hi,
We've got 2 production servers, one is on 2008 Enterprise Edition , the other on 2005 Standard Edition. The 2005 server gets updated daily with data from the 2008 server (eg. we drop table, then select into xxx).
I've been looking into the data compression functionality on the 2008 server as there will be significant space savings and performance increases. But i cant find anything online to say whether there are any problems with compressed data being copied into a standard edition?
Has anyone else tried this? or can you point me in the right direction
thanks
Choffer
July 13, 2012 at 4:21 am
Hi mate,
Not 100%, but as far as my understanding of compression goes, the data is uncompressed during the process of retrieving it, so a select... into... should be fine, as the data is already uncompressed by the time it reaches the destination.
Of course, should be easy enough to test if you have the resources to set up a test database/tables on each server!
Cheers
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply