Settings for SQL Server

These settings are displayed for SQL Server Enterprise and Developer editions.

Use compression. If selected, creates tables for export with compression.

Compression for. Choose the level of compression.

• Row. Enables row-level compression (for example, the equivalent of CREATE TABLE MYTABLE(…) WITH (DATA_COMPRESSION = ROW); in SQL).
• Page. Enables page-level compression (for example, CREATE TABLE MYTABLE(…) WITH (DATA_COMPRESSION = PAGE); in SQL).