Sybase Adaptive Server Anywhere - CREATE COMPRESSED DATABASE Statement

CREATE COMPRESSED DATABASE statement
426
CREATE COMPRESSED DATABASE statement
Use this 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 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.
An operating system file is created.
"The Compression utility" on page 85
"The Uncompression utility" on page 136
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.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
♦ 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’
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
Example