In 1992 Microsoft released the first version of a product called Microsoft Access which has become the de facto desktop database for software development. The application caught on not only as a database tool but also as a development environment. However, Access is not without its flaws, and developers have found that their Access database quickly reaches its limit with regard to the number of users and quantity of information it can handle. As a result, many developers are choosing to move their databases from Access to SQL Server.The process of migrating a database from Access to SQL Server is fraught with problems and “pitfalls” that many developers do not expect. In this book, Russell Sinclair explores the methodology behind this type of database migration and teaches developers what they need to know to successfully complete such a project.Note that while Microsoft does provide simple tools for this type of migration and some documentation for simple transitions, these are quite insufficient for a successful migration of any complex system that would be encountered in the real world.
Most migrations from Access to SQL Server fail due to a lack of understanding as to the differences between the two systems and also how Microsoft Access front ends talk to SQL Server.About the author:Russell Sinclair is a senior programmer with Questica Inc., a company specializing in software for the customized machinery manufacturing industry. He is a frequent contributor to “Smart Access” and has extensive development experience in Access and SQL Server.

Author Biography

Russell Sinclair is an MSCD and the owner of Synthesystems, a technology consulting firm specializing in Visual Basic, SQL Server, and Microsoft Access development. Russell is the senior systems architect with Questica, Inc., a company specializing in software for custom-design manufacturers, and a contributing editor for Smart Access. In addition, he has extensive experience in Access and SQL Server development.

We are committed to protecting your rights under the Consumer Guarantees Act and working with our suppliers to assist with warranty claims. Products sold by Mighty Ape will be covered by a Manufacturer's Warranty for at least a one-year period from the date of purchase.

Your warranty will cover any manufacturing defects which, if existing, will present themselves within this warranty period.

Your warranty will not cover normal wear and tear, faults caused by misuse, and accidents which cause damage or theft caused after delivery. Using the product in a way it is not designed for will void your warranty.

Please refer to our Help Centre for more information.