Macromedia breeze 5 Betriebsanweisung
The Breeze database
29
The Breeze database
Breeze Server requires a database created with either the embedded database engine or Microsoft
SQL Server 2000. The Breeze database stores information about users, content, courses,
meetings, and reports.
SQL Server 2000. The Breeze database stores information about users, content, courses,
meetings, and reports.
•
The embedded database engine comes with Macromedia Breeze. You install it at the same time
that you install Breeze Server.
that you install Breeze Server.
•
Breeze Server deployed in a configuration with multiple computers (a cluster, for example) or
with multiprocessor computers with HyperThreading requires SQL Server 2000.
with multiprocessor computers with HyperThreading requires SQL Server 2000.
•
If you use Microsoft SQL Server 2000 as the database engine, make sure to install it in mixed-
mode. This gives you the option to use SQL or Windows authentication. Breeze supports SQL
authentication only.
mode. This gives you the option to use SQL or Windows authentication. Breeze supports SQL
authentication only.
•
The database must be set to case insensitive. For more information on configuring the
database, see Chapter 4, “Post-installation,” on page 57.
database, see Chapter 4, “Post-installation,” on page 57.
Limitations of the embedded database engine
The embedded database engine that comes with Macromedia Breeze has the following
limitations:
limitations:
•
The licensing agreement restricts installation and use of the embedded database engine to the
computer hosting Breeze Server.
computer hosting Breeze Server.
•
Because of licensing restrictions, you can install the embedded database engine only on a
single-processor computer.
single-processor computer.
•
2 GB is the maximum size of the Breeze database using the embedded database engine.
•
The embedded database engine has a command-line interface for managing and querying the
database, in contrast to Microsoft SQL Server 2000, which has tools with graphical user
interfaces for executing these tasks.
database, in contrast to Microsoft SQL Server 2000, which has tools with graphical user
interfaces for executing these tasks.
Database engine recommendations
The following recommendations should guide your choice of database engine:
•
Consider using the embedded database engine installed with Breeze for testing and
development. It uses the same data structures as SQL Server.
development. It uses the same data structures as SQL Server.
•
In production environments, give preference to the Microsoft SQL Server 2000 engine.
SQL Server is a scalable DBMS designed to support a significantly larger number of
concurrent users.
SQL Server is a scalable DBMS designed to support a significantly larger number of
concurrent users.