Lots of us have migrated from Access to SQL Server.  The difficulties depend
on your database design and front end design.  When I migrated my
application from Access to SQL Server I had to also migrate from DAO to ADO.
I also had to address SQL queries that were Access specific.  

In migrating the database itself I had to address bad data that Access
allowed but SQL Server didn't (bad dates for example) and had to migrate the
data to maintain data integrity.  This can be tricky for complex databases
(such as mine). (I migrated to SQL Server and merged 12 separate databases
into 1)

For creating the SQL Server database there are 2 main ways 1) the Access
upsize wizard and 2) DTS.  If possible use the upsize wizard.  If your
destination is SQL 2000 upgrade from Access XP (or 2000) if possible (if
needed upgrade your database from 97 to 2000/XP first).  The upsize wizard
maintains/recreates primary keys and direct referential integrity better
than DTS.  If you use DTS to create the tables watch the column types that
it uses (such as "smalldatetime" instead of "datetime") and as Niall
mentioned you may need to reassign primary keys.  

Brian Freeman
(xxx) xxx-xxxx  ext. 415
Carnegie Technologies/Bluewave Computing 
www.carnegie.com and www.bluewave-computing.com

-----Original Message-----
From: Kozman, Marty [mailto:kozmanm@c...]
Sent: Wednesday, October 16, 2002 7:52 AM
To: sql language
Subject: [sql_language] Access to SQL


Has anyone migrated an access database to SQl?

If so.... was it extremely difficult and cumbersome?

Thanks
Marty