Icon CREATE STORE

Creates a new store.

Syntax
CREATE STORE <StoreName> AS <LocalStoreDefinition>|<RemoteStoreDefinition>
[DESCRIPTION <Description>]
[ATTRIBUTES <CustomAttributes>]

<LocalStoreDefinition> =

LOCAL PATH <Path>

<Path> = Any valid operating system path

<RemoteStoreDefinition> =

REMOTE ADDRESS <IPAddress>|HOST <Host>
PORT <Port>|SERVICE <Service>
USER <UserName>
PASSWORD <Password>
STORE <RemoteStoreName>
[SIGNATURE <Signature>]
[ENCRYPTED]
[ENCRYPTION PASSWORD <EncryptionPassword>]
[COMPRESSION <Compression>]
[TIMEOUT <Timeout (seconds)>]
[PING <PingInterval (seconds)>]

<Compression> = 0..9

Usage
Use this statement to create a new store. Use the LOCAL keyword to create a local store that references a path accessible from the local process. If the path specified for a local store is not valid, then ElevateDB will attempt to create the path. Use the REMOTE keyword to create a remote store that references a store located on an ElevateDB Server specified by the ADDRESS or HOST, and PORT or SERVICE, keywords. The remote store name is not validated until the store is opened. If the remote store does not exist when the store is opened, then an appropriate error message will be displayed.

Information As of 2.03 Build 14, if you specify a relative path for a store, the relative path will be interpreted as relative to the current configuration file path setting for the current session. For example, given a configuration file path of 'C:\MyApplication', the store path 'MyStore' will be interpreted as 'C:\MyApplication\MyStore'.

Examples
-- The following statement creates a local Backups
-- store using a path name without a drive letter.

CREATE STORE "Backups" AS
LOCAL PATH '\support\backups'
DESCRIPTION 'Support Database Backups'

-- The following statement creates a remote RemoteOffice store
-- that references the SavedUpdates store on a remote ElevateDB
-- Server.

CREATE STORE "RemoteOffice" AS
REMOTE ADDRESS '64.65.248.118' PORT 12010
USER "MainOffice"
PASSWORD 'LogMeIn'
STORE "SavedUpdates"
DESCRIPTION 'Remote Office Updates'

Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension.
Image