|
If you do not need the direct operation with the DB via the ADO.NET, it is recommended to use an internal DB instead of SQL SE DB. Internal DB is more stable and productive in comparison with the SQL CE. |
General description
Microsoft SQL Server Compact Edition (SQL CE) is a relational database produced by the Microsoft company.It is an embedded database engine for desktop applications and mobile devices. SQL CE may be used as an external database for Dr.Web ESS.
To use SQL Server CE:
1.Install the SQL CE server.
2.Set up the database driver to use the respective external database. You can do this in configuration file or via the Dr.Web Control Center: Configure Dr.Web Enterprise Server, Database tab.
Installation and Supported Versions
|
The SQL CE DBMS is compatible only with Windows 2000 OS and higher (x32 and x64 versions).
Dr.Web Enterprise Security Suite supports Microsoft SQL Server Compact of 3.5 SP1/SP2 for x86 and x64 platforms. Compatibility with all later versions of SQL CE DB is not guaranteed. |
If you want to deploy SQL Server Compact Edition, you need to download the installation package from the web site of the manufacturer http://www.microsoft.com/sqlserver/2005/en/us/compact-downloads.aspx and install the corresponding version of the server (see also System requirements for 3.5.).
|
It is not recommended to install more than one version of Microsoft SQL Server Compact on the same computer due to possible compatability issues.
Microsoft SQL Server Compact 3.1 does not support encryption. Databases created on servers running under this version of Microsoft SQL Server may not be compartible with Microsoft SQL Server Compact 3.5 servers. Use the Dr.Web Enterprise Security Suite exportdb and importdb commands to import data from SQL Server Compact 3.1 databaes to SQL Server Compact 3.5 databases. |
A client to access the database is included in the installation package of Dr.Web ESS.
Parameters
To adjust access to the SQL CE DBMS, use the parameters described in Table below.
Parameters of the SQL CE DBMS
Parameter |
Description |
|---|---|
drwsqlce |
Driver name |
DBFILE |
Database name (by default mssqlce.sdf) |
PASSWORD |
Database encryption password |
|
The PASSWORD parameter is an encryption key and bears no relation to the user/password system. By default, the password is empty (the database is not encrypted). |
An Example of the drwcsd.conf Configuration File
If you deploy SQL CE, it is necessary to change the definition and the settings of the database driver in the configuration file of the Server. See a fragment of the configuration file with corresponding parameters below:
... ;Database definition. Mandatory. ;Only one definition is allowed. database
;DB driver (DLL or shared object name) drwsqlce ; sql server compact, windows only
;load library from this path; empty - use default from "" ;parameters describing database connection ;defaults (DBFILE: varroot/mssqlce.sdf) ;using "DBFILE=mssqlce.sdf PASSWORD=drwcs" using "DBFILE=mssqlce.sdf PASSWORD=drwcs" |