Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS SSMA Tools to Convert MS Access/Oracle/Sybase DBs to SQL Server

Convert Access to SQL Server

MS SSMA Tools to Convert MS Access/Oracle/Sybase DBs to SQL Server

by  SBerthold  Posted    (Edited  )
These SSMA tools work excellent to convert MS Access 97 through 2008 Data and Meta-data to SQL Server:
============================================================

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

[color red]XP SP2 and Vista systems:[/color]
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).
============================================================




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


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

Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top