Client-Server Application Scorecard
Client-Server applications designed from source MS Access databases are typically
written in Java or one of the Microsoft .Net languages (C#, Visual Basic .Net),
and designed to run against a SQL Server or Oracle Database server. With a Client-Server migration approach,
your source MS Access application serves only
as a functional prototype for the new application — no components of the MS Access
application are used following project completion.
The result is
high application performance, tight security and the most robust user experience.
Application deployment can be automated and may be restricted to MS Windows PCs. As a true Client-Server application, with a relatively small local PC memory requirement,
the Client-Server approach enjoys standard Windows deployment and security coupled with high-end
database server performance and robust security.
|
Client-Server Scorecard |
|
# End Users |
< 1,000 |
Supports continual use |
|
Deployment |
LAN |
WAN or
Internet use not recommended |
|
Performance |
Excellent |
SQL Server design-dependent |
|
Reliability |
Excellent |
SQL Server design-dependent |
|
Data Integrity |
Excellent |
Assumes proper use of SQL Server database constraints and keys |
|
Security |
Excellent |
SQL Server-level security controls |
|
Data Limit |
Unlimited |
SQL Server datastore |
|
Maintenance |
High |
Distributed application maintenance |
|
# of Records |
Unlimited |
SQL Server datastore |
|
Internet Access |
No |
Remote access will impede performance and reliability |
Client-Server Architecture
The Client-Server architecture is recommended for any application where security,
reliability and performance are of primary concerns. Examples include data entry into regulated
systems for accounting, medical research and personnel management. Client-Server
applications require a full-time reliable connection to the database through a local
or wide area connection or a secure Internet connection.
The major difference between a Client-Server Application and a Smart Client solution:
Smart Client systems are optimized for Internet deployment and use.