Access Scalability
The last thing you want is a database platform that cannot cope
with the performance demands placed on it, and yet it has no upgrade
path. A dead-end disaster. Fortunately, Access can be upsized to
SQL Server.
Microsoft Access --- SQL Server
What happens when I
migrate to SQL Server?
You would use Access as the Client (Front-end) and SQL Server
as the Server (Back-end). This means that SQL Server will hold your
data.
What do I do with the
existing Access database?
SQL Server has no attractive visual interface for the end user,
so you will use Access for that. You will need to modify some parts
of your Access database when you upsize. Microsoft provides a wizard
to assist but some areas will require manual intervention. Designing
your Access application at outset with migration in mind will reduce
the number of changes required.
Is SQL Server as easy
to maintain as Access?
No! SQL Server requires more maintenance than Access. And a different
skill set. Be prepared! However, SQL Server 7.0 has much less maintenance
demands than SQL Server 6.5.
Which
Database Engine should I use? 
1.
Why Choose Access?
2. Performance:
Is Access up to the job?
3. Scalability:
What are the upgrade options?
4. Which
Database Engine should I use? Jet (that comes with Access) or SQL
Server?
|
