Resources for Migrating Data ONLY from Access 03 to SQL Svr 2005

[Carlos Batista]

Hi there,

We are looking to migrate the tables and data from a production Access
database onto SQL Server 2005, but still access the front-end via Access 2003
and utilize the forms and reports stored there. Where can I find some good
documentation on doing a migration like this, not just steps, but the
pros/cons, considerations, etc. Kinda looking for a white paper of sorts.

Thx!

 

[Beetle]

Here are a few links;

http://www.granite.ab.ca/access/sqlserverupsizing.htm

http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-from-access-to-sql-server.html

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0561.mspx?mfr=true

Some of the articles are about older versions, but the information should
still
be relevant. You may also want to browse some of the posts in
microsoft.public.access.sqlupsizing. It's not a very active group but you
may find some good information there.

 

[Carlos Batista]

Thanks Beetle...the Technet article is especially helpful!