Sinclair covers the two most common versions of both products, Microsoft Access 7 and 2000 and Microsoft SQL Server 6.5 and 7
The author offers his own tips and techniques based on practical hands-on experience. The resulting book teaches developers how to accomplish their goal without over-simplifying the migration process
Most books do not cover the reasons behind the database migration process. This book helps developers make educated decisions about how to implement their changes
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.
This book covers what Access developers need to know about SQL Server, covering the two most common versions of both products: Microsoft Access 97 and 2000 and Microsoft SQL Server 6.5 and 7. The author offers his own tips and techniques based on practical hands-on experience. The resulting book teaches developers how to accomplish their goal without over-simplifying the migration process. Further, it includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases. It outlines the planning involved and helps developers make educated decisions along the way.|
Although Microsoft's Access Database is extremely popular and adequate for smaller scale applications, many Access developers are discovering that their applications need a more robust, enterprise-ready database system like SQL Server. This book is designed as a guide for Access programmers looking to make this transition, but who have little or no prior experience with SQL Server.
Veteran author Russell Sinclair begins by discussing SQL Server, its architecture and application environment, and its differences from Access. He provides coverage of key topics including security, data storage, system databases, database objects, and queries.
- Illustrates best practices for migrating Access databases to SQL Server
- Carefully explains the differences between these two systems and the changes needed for a smooth migration
- Assumes no prior knowledge of SQL Server
|This book covers what Access developers need to know about SQL Server. It includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases. It outlines the planning that should go into a migration and the decisions that need to be made along the way.
A table of contents is not available for this title.
This book covers what Access developers need to know about SQL Server, covering the two most common versions of both products: Microsoft Access 97 and 2000 and Microsoft SQL Server 6.5 and 7. Further, it includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases.
1 What Every Access Programmer Needs to Know about SQL Server.- 2 Why Migrate?.- 3 Planning the Upgrade.- 4 The Microsoft Wizard.- 5 Data Transformation Services.- 6 Using SQL Server 6.5.- 7 Using SQL Server 7.- 8 Enabling Data Access.- 9 Stored Procedures.- 10 Getting Connected.- 11 Coding with SQL Server Data.- 12 Optimizing Access for SQL Server.- Appendix A Selected Tables.- SQL Server Data Types.- Microsoft Access ODBC Registry Settings.
Über den Autor
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.
Inhaltsverzeichnis
A table of contents is not available for this title.
Klappentext
This book covers what Access developers need to know about SQL Server, covering the two most common versions of both products: Microsoft Access 97 and 2000 and Microsoft SQL Server 6.5 and 7. The author offers his own tips and techniques based on practical hands-on experience. The resulting book teaches developers how to accomplish their goal without over-simplifying the migration process. Further, it includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases. It outlines the planning involved and helps developers make educated decisions along the way.
This book covers what Access developers need to know about SQL Server. It includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases. It outlines the planning that should go into a migration and the decisions that need to be made along the way.
