Friday, March 23, 2012

Migrate to SQL Server Express from Access

Anything I should know about before I start?

Also I want to work with SQL Express from another workstation instead of directly with the server, which tool do I use to build with it?

Probably very obvious answers but since it is critical to do it right, I wanted to check.

What is the best tutorial in regard to these kinds of functions?

THANKS!

See my response to this earlier thread for suggestions for 'learning' material.

Also, if you don't have these resources, they may prove useful:

Access - SQL Server Migration Assistant for Access
http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en

Access -Advantages of SQL Server over Access
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/managesql.mspx
http://www.expresstechnology.com/TechBulletins/SQLCompare.htm
http://www.ssw.com.au/SSW/kb/KB.aspx?KBID=Q169882

Access
http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-from-access-to-sql-server.html
http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

Access -Moving Your Access 2002 Database to SQL Server (Detailed White Paper)
http://msdn2.microsoft.com/en-us/library/aa902657(sql.80).aspx

No comments:

Post a Comment