|
vb123.com
Garry Robinson's Popular MS Access, Office and VB Resource
Site
 |
|
Home
Contact Us
Order our Software
RSS &
Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More
Get Good Help
If you need help with a database, our Professionals could be the answer
Read More
 Is Your Database Corrupt
?
If you have a corrupt database,
Try our Access Recovery service
The
Workbench
Find out who has
your database open, start the correct version of Access, easy compacting and
backups, change startup options, mde compile, shutdown database
Read and Download
The Toolshed
Searchable help file comprising of all the information at vb123.com plus hidden downloads
etc.
Read More
The Toolbox
Libraries of software that we regularly import into our projects. Enhances the Toolshed
More..
DryToast New
Backup and query your BaseCamp®
projects
Read More
Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware
tool.
Read More
Garry's Blog
Find out a few other things that Garry
has been writing about Microsoft Access.
Read more
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author and
has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...
Search ...
or try our Aussie
vb123.com.au
mirror site
|
|
| |
Real World Microsoft Access Database Protection and Security
- A book by Garry Robinson
Why Migrate from Access to SQL Server?
Bonus Chapter by Russell Sinclair.
ONE WAY THAT YOU CAN IMPROVE
your Access data security is by migrating your
database to a server-based database such as SQL Server, Informix, or Oracle. If
you
have already migrated a database to an enterprise-quality database product like
one of these, you will appreciate that this process is not a trivial task. If
you haven’t,
then let me assure you that it is worthwhile that you understand both the
benefits
and the pitfalls of such an undertaking long before you take the plunge with
some
real live data.
To help you make up your mind, Russell Sinclair and the gang at Apress have
allowed me to reprint a chapter from Russell’s book, From Access to SQL Server.
In
this chapter, you will find out things about Access to SQL Server migration,
like:
• Why migrating a database that has been in use for a long period of time is
more involved than migrating a brand new database.
• Why big Access tables are a impediment to Access performance. (Remember
that Chapter 5 in my book shows you how you can work out your largest
tables.)
• SQL Server can process the query on the server and return only the results,
thereby freeing network traffic.
• SQL Server handles multi-user issues, such as locking, much better than
Access, especially when compared with Access 97.
• Introduction into the differences between Access and SQL Server security,
maintenance, and cost.
So, if migrating your database is something that you think you should consider
or is something that you have tried and felt like you need more information for
the
next time, try another of Russell Sinclair’s book chapters at
http://www.apress.com/
Purchase
Russell's book and read more about it at the following online book stores
Amazon... Amazon
UK...
Purchase
Garry's book and read more about it at the following online book stores
|