Platform changes from 6.x

SQL replaces embedded DB


7.x and later


Embedded: CodeBase.

SQL Server or Oracle.

Standard, scalable, open.

DB replication built-in.


Easier, more secure than DB-native.

Multi-master architecture.


If it's not broken...

DB on each server.

Local or separate DB.

Scale up with more HW.

1 DB instance per PW server.

DB can be shared.

Leverage corporate DB clusters.

Limited Unicode support (e.g., security Qs).

Full Unicode support (e.g., attributes, IDs).

Better for Asian users.

Direct access to data.

All access via stored procs.

Better performance.