CREATE COMPRESSED DATABASE statement

To create a compressed database from an existing database file, or to expand a compressed database.

CREATE [ COMPRESSED | EXPANDED ] DATABASE new-db-file-name
... FROM old-db-file-name

new-db-file-name | old-db-file-name: 'file-name'

The permissions required to execute this statement are set on the server command line, using the -gu command-line option. The default setting is to require DBA authority.
The account under which the server is running must have write permissions on the directories where files are created.
The source database file must not be currently loaded on a server.
Not supported on Windows CE.

An operating system file is created.

Creates a compressed database file from an uncompressed database file, or an uncompressed database file from a compressed one.

Any relative path is taken relative to the current working directory of the server.

You cannot use this statement on files other than the primary database file.

The following statement creates a compressed database file named compress.db in the C:\ directory from a database file named full.db in the current working directory of the server.
```
CREATE COMPRESSED DATABASE 'C:\\compress.db'
FROM 'full.db'
```
The following statement creates an uncompressed database file named full.db in the C:\ directory from a compressed database file named compress.db in the current working directory of the server.
```
CREATE EXPANDED DATABASE 'C:\\full.db'
FROM 'compress.db'
```