| |||||||||||||||
 Trade In this Item for up to £0.25
Trade in From Access to SQL Server: Moving from Access to Microsoft SQL Server for an Amazon.co.uk gift card of up to £0.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
Product Description
Product Description
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.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
This book is laid out in an easy to read and understand format. Assumptions are made that the reader has a clue and actually does know how to open a file. This is not a dummy-idiot book; I didn't feel that I was wasting my time searching through things that were completely redundant.
Helpful items are the screen shots and conversion suggestions or warnings. I really feel that with this reference tool we will be able to accomplish the task given us.
After developing in Access and programming with VBA for four years I thought I could handle moving to SQL Server without a great deal of assistance. Not true. There are lots of things different - lots of 'gotchas' that exist in SQL Server as do in every development environment. Learning them through trial and error is not a pleasant experience. This book help you avoid dead ends and move your project to completion as painlessly as possible.
In particular I appreciated the help with the decision to use ODBC or an Access project and how to approach stored procedures and use them to best advantage.
Rarely have I come across a book where just about every paragraph, no every sentence - contains useful information. This one does. It makes for kind of a dry writing style, but if you can picture having a highly experienced expert at your shoulder as you migrate your database from Access to SQL Server, whispering tips at the appropriate times, then you will know what this book can do for you.
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Access > Access & SQL Server
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Home Office Databases > Microsoft Access
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
