Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Microsoft Access Developer's Guide to SQL Server (Professional) by Andy Baron |
by Susan Sales; Reid, Martin Harkins
|
|
![State Of Play : Complete BBC Series 1 [2003] [DVD]](http://ecx.images-amazon.com/images/I/51G4DTWRTXL._SL500_SS90_.jpg)
DVD ~ John Simm
|
Product details
Would you like to update product info or give feedback on images?
|
Customers Viewing This Page May Be Interested in These Sponsored Links(What is this?) |
Product Description
Product Description
<br/><br/> <br/> Illustrates best practices for migrating Access databases to SQL Server. <br/> Carefully explains the differences between these two systems and the changes needed for a smooth migration. <br/> Assumes no prior knowledge of SQL Server. <br/><br/> <p>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. <p> 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. <p> After reviewing SQL Server, he covers core migration issues, frameworks for decision making, and the migration process itself. Specific topics include Microsoft's Upsizing Wizards, use of SQL Server's Data Transformation Services (DTS), options for connecting Access databases directly to SQL Server, differences and similarities between Tables and Views in Access and SQL Server, how to write SQL Server stored procedures, and how to convert existing Access reports to stored procedures.
<br/><br/> <br/> Illustrates best practices for migrating Access databases to SQL Server. <br/> Carefully explains the differences between these two systems and the changes needed for a smooth migration. <br/> Assumes no prior knowledge of SQL Server. <br/><br/> <p>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. <p> 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. <p> After reviewing SQL Server, he covers core migration issues, frameworks for decision making, and the migration process itself. Specific topics include Microsoft's Upsizing Wizards, use of SQL Server's Data Transformation Services (DTS), options for connecting Access databases directly to SQL Server, differences and similarities between Tables and Views in Access and SQL Server, how to write SQL Server stored procedures, and how to convert existing Access reports to stored procedures.
Inside This Book
(Learn More)
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 organize and find favorite items. |
What Do Customers Ultimately Buy After Viewing This Item?
 |
51% buy the item featured on this page: From Access to SQL Server: Moving from Access to Microsoft SQL Server £33.57 |
 |
30% buy Beginning SQL Server 2008 for Developers: From Novice to Professional (Expert's Voice in SQL Server) £23.69 |
 |
19% buy Microsoft Access Developer's Guide to SQL Server (Professional) £24.64 |
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
|
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 > Programming > Languages & Tools
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Home Office Databases > Microsoft Access
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
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.
The Body Shop |
Let Olay Amaze You |
Treat Someone
With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is). |
||||||||
| |||||
Your Recent History
(What's this?)|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
Continue Shopping: Top Sellers
| ||||
Amazon Home | |
| International Sites: United States | Germany | France | Japan | Canada | China | |
| Business Programs: Sell on Amazon | Fulfilment by Amazon | Join Associates | Join Advantage | |
| Customer Service | Help | View Basket | Your Account | |
| About Amazon.co.uk | Careers at Amazon | |
| Conditions of Use & Sale | Privacy Notice © 1996-2009, Amazon.com, Inc. and its affiliates |