[AccessD] upgrading

Hi Susan,

I am going to start next week!  I am planning to use SQL Server Migration
Assistant (SSMA) for Access, which I believe will help significantly.  SSMA
will convert many select queries in Access to views in SQL.  

There is a comprehensive technical paper which discusses how to use SSMA for
Access.
http://download.microsoft.com/download/e/c/8/ec8d5025-7ef7-4dcc-a9f3-9c297cf
5350e/SSMAAccess.docx

Dan



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, June 10, 2008 7:39 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] upgrading

Has anyone upgraded an Access database to SQL Server 2005 or SQL Server 2005

Express? I'd like to hear about the experience and the gotchas if 
significantly different from earlier SS versions.

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com