From Access to SQL Server
Apress (Verlag)
978-1-893115-24-8 (ISBN)
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
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.
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.
| Zusatzinfo | XIII, 340 p. |
|---|---|
| Verlagsort | Berkley |
| Sprache | englisch |
| Maße | 191 x 235 mm |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Informatik ► Office Programme ► Access | |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| Schlagworte | ACCESS • Database • SQL • SQL Server |
| ISBN-10 | 1-893115-24-0 / 1893115240 |
| ISBN-13 | 978-1-893115-24-8 / 9781893115248 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
