Get Free Shipping on orders over $79
From Access to SQL Server : APRESSPOD - Russell Sinclair

From Access to SQL Server

By: Russell Sinclair

Paperback | 1 September 2000

At a Glance

Paperback


$84.99

or 4 interest-free payments of $21.25 with

 or 

Ships in 5 to 7 business days

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.

More in Databases

Python All-in-One For Dummies : 3rd Edition - John C. Shovic

RRP $74.95

$55.75

26%
OFF
Database Systems : A Practical Approach - Mitchell Penn
Tools and Applications of Data Mining - Richard Vincent
Big Data Analytics : A Practical Guide - Candy Walken
The Data Science and Psychology - Alisha Attella
Microsoft Excel 365 Bible : Bible - Michael Alexander

RRP $90.95

$65.75

28%
OFF
Microsoft 365 Access For Dummies : Access for Dummies - Laurie A. Ulrich
Social Research Methods : 4th Edition - Maggie Walter

RRP $101.95

$87.75

14%
OFF
Mindf*ck : Inside Cambridge Analytica's Plot to Break the World - Profile Books
Data Analytics for Accounting ISE : 3rd Edition - Vernon Richardson

RRP $169.95

$146.75

14%
OFF
Microsoft Power BI For Dummies : For Dummies (Computer/Tech) - Jack A. Hyman