Migrating from Access to a High-End DBMS {2}

by Jonathan N
This article talks about the users which are ready to make the next step forward and advance from the simplicity of Microsoft Access to a much more multifaceted Microsoft SQL server.  The author speaks of the many reasons why you should be willing to migrate your shared access database to a client/ server.  Access is less able to manage file sharing efficiently. When network traffic increases, access’s responsiveness decreases.  The author also states that Access can handle databases only up to 2 GB and has only  a few high availability features. This could be a big reason why companies will look for other solutions, veering away from Access. 2GB of information is very minimal for some organizations database. Microsoft Access does not backup and restore files dynamically while the database is in use.  This makes using a client/ server for your database much beneficial  because the desire for better security and a dynamic web back end makes it much worth it to go in the route to a SQL server. If you believe you need to make the approach t Sybase Adapative Server Enterprise, you should allow the phased implementations. You should follow these that are listed in Matthew Sarrel’s guidelines below to make the migration easier. read more...