October 12, 2007 at 9:41 am
I would like suggestions for a beginner's book on setting up a server on which I will be installing SQL Server 2005 Standard edition and eventually building in .NET connectivity. If you can suggest a series of books to bring me through these steps, that would be excellent!
There will be about 15 users utilizing this server and the underlying database which I will be migrating from Access 2000 is about 35 MB.
Thanks!
Gresford Thomas
October 18, 2007 at 12:20 am
What specifically are you looking for? OS configuration? Best practices for installing the database engine? How to integrate CLR? All of the above?
K. Brian Kelley
@kbriankelley
October 18, 2007 at 8:42 am
What I am looking for is a basic book on server administration starting from choosing the correct hardware to physically setting up the server in my department to OS configuration to .NET connectivity. If there are a series of books that you could suggest that would work also. I am starting from ground zero with little support so I just need a reference to point me in the right direction.
Thanks!
October 19, 2007 at 9:43 am
I would suggest you look at Buck Woody's "Administrator's Guide to SQL Server 2005" published by Addison-Wesley ISBN 0-321-39797-5 to get you started with SQL Administration. It is easy to read, and is designed for hands on learning.
Good Luck and Have Fun!
October 19, 2007 at 11:12 am
Gresford Thomas,
You are dealing with several phases for your project. I have given a rough outline of how I see your project unfolding, as well as where to get information to make decisions with. You asked for books for each part, and I have made recommendations below.
Overall Goal:
Migrate Access2000 database to SQL Server 2005 with a .NET front end
1) Decide SQL Server 2005 Hardware and Software:
Beginning SQL Server 2005 Administration
ISBN-10: 0470047046
ISBN-13: 978-0470047040
Chapter 1 has a section covering the different versions of SQL Server 2005 that are available.
Chapter 2 covers Hardware, Processor, Memory, and Storage considerations as well as Minimum Software specifications.
This information can is also covered in SQL Server 2005 Books Online (BOL).
2) Analyze the Access2000 database.
ACC2000: "Access 2000 Upsizing Tools" White Paper Available in Download Center
http://support.microsoft.com/kb/241743">
http://support.microsoft.com/kb/241743
NOTE: This tool is compliant with SQL Server 7.0 and should be used as a guide for how to move to SQL Server 2005. This tool will give you an idea of how complex the Tables, Queries, Forms, Reports, etc. are within the Access2000 database.
3) Migration
From Access to SQL Server
ISBN-10: 1893115240
ISBN-13: 978-1893115248
This book will get you well under way for your migration.
Additionally this book may also come in handy for getting down to the coding details:
Microsoft Access Developer's Guide to SQL Server
ISBN-10: 0672319446
ISBN-13: 978-0672319440
4) .NET connectivity
At the least your SQL Server 2005 server will need to run the application you are going to write in .NET. IIS will need to be running on the server. I would suggest the following as an introduction:
Beginning ASP.NET 2.0 Databases: From Novice to Professional
ISBN-10: 1590595777
ISBN-13: 978-1590595770
On the other side of the coin, you could outsource the project with an independent consultant or with a company that specializes in this type of conversion. You may want to consider getting a quote or two to help justify your costs of doing the work internally.
If you would like to discuss this topic offline, please feel free to drop me a private message.
At a minimum, please post your progress to the message forums, so that we may all benefit.
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply