How can I migrate from Access to SQL Server?

A. To start with use the free Access upsizing wizard on MS's website. It works from Access 97 to SQL 6.5 or 7.0. It is available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm 

If you are using Access 2000 then the Access Upsizing tool that ships as part of Office 2000 only supports SQL 7.0.

There are also some 3rd party-products :-

http://www.weirperf.com
http://www.ssw.com.au SSW Upsize PRO! (97 and 2000)


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish