How to Identify compressed tables/objects before Restoring/Migrating database to any edition other than Enterprise Edition

Geschrieben von Database Magician am Mittwoch, 30. März 2016

'TITLE: Microsoft SQL Server Management Studio
——————————
Restore failed for Server ‘SQL_SERVER’. (Microsoft.SqlServer.SmoExtended)

ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Database ‘DB1′ cannot be started in this edition of SQL Server because part or all of object ‘object1′ is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition.

Database ‘DB1’ cannot be started because some of the database functionality is not available in the current edition of SQL Server. (Microsoft SQL Server, Error: 909)'...

https://blogs.msdn.microsoft.com/sqlserverfaq/2010/09/03/how-to-identify-compressed-tables-before-restoringmigrating-database-to-any-edition-other-than-enterprise-edition-of-sql-server-2008/