just installed sql 2008 and need some advice

[sparks]

We have always used access for our databases.
Not they say we need sql.
I have messed with sql in the past. sql 2005 but really did not do
much.

They have some data in sql they want an access front end built for.
They then want to start converting our access databases to sql
backend.

Is there a book on doing this kind of thing.
Pitfalls and things watch out for or avoid doing?

thanks for any help with this

[Erland Sommarskog]

I'm afraid that I don't know of any SQL Server book written for Access
programmers, but given the user base, I would not be surprised if there is
one.

However, I can recommend this book:
http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-T-SQL-Fundamentals-PRO-
Developer/dp/0735626014/ref=sr_1_1?s=books&ie=UTF8&qid=1311803154&sr=1-1
T-SQL Fundamentals by Itzik Ben-Gan. It gives you a good introduction to
T-SQL. If you find it too basic, you may want to try his T-SQL Querying
instead, which is more advanced.

The one thing you should keep in mind is that there are great differences
between the SQL dialects in Access and SQL Server.

The other tip I can give, based from what I have heard from people with a
strong experience of both Access and SQL Server is that you should not
use the upsize wizard, but do a manual migration. The latter is more
work, but you get a much better product in the end.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

[sparks]

Thank you very much for all your help