INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Convert Access to SQL Server

MS SSMA Tools to Convert MS Access/Oracle/Sybase DBs to SQL Server by SBerthold
Posted: 26 Sep 08 (Edited 26 Sep 08)

These SSMA tools work excellent to convert MS Access 97 through 2008 Data and Meta-data to SQL Server:
============================================================

For Migrating from MS Access to SQL Server 2005
W2000:
http://www.microsoft.com/downloads/details.aspx?FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&DisplayLang=en
============================================================

XP SP2 and Vista systems:
http://www.microsoft.com/downloads/details.aspx?FamilyId=4ECD1E67-C64E-49E6-821E-C4D83D9D5FED&displaylang=en
============================================================

You will need to first install this System Driver:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

and then when installing the converter, you will need to request a license through an msdn account (takes all only a few minutes).
============================================================




For Migrating from MS Access to SQL Server 2008
http://www.microsoft.com/downloads/details.aspx?familyid=133B59C2-C89C-4641-BEBB-6D04476EC1BA&displaylang=en
============================================================


To convert from Oracle or Sybase dbms see:
http://www.microsoft.com/sql/solutions/migration/default.mspx
============================================================

 

Back to Microsoft SQL Server: Programming FAQ Index
Back to Microsoft SQL Server: Programming Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close