ASA SQL Reference
  SQL Statements

CREATE COMPRESSED DATABASE statement

Description 

Use this statement to create a compressed database from an existing database file, or to expand a compressed database.

Syntax 

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

Usage 

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

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

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

Permissions 

• The permissions required to execute this statement are set on the server command line, using the -gu option. The default setting is to require DBA authority.

• The operating system account under which the server is running must have write permissions on the directories where files are created.

• The old database file must not be currently running.

• Not supported on Windows CE.

• You must specify a key if you want to create a compressed database for a strongly encrypted database.

Side effects 

An operating system file is created.

See also 

The Compression utility

The Uncompression utility

Encryption Key connection parameter [DBKEY]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

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'