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.


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: