INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

HANDLE


PASSWORD
Remember Me
Forgot Password?

Navigation

Join Us!
Keyword Search
Browse Forums
Jobs
Start A Group
Tell A Friend
Donate
Whitepapers

Come Join Us!

  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • Turn Off Ad Banners
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
E-mail*
Handle

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

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Member Feedback

"...Keep up the good work - excellent site - i'd been looking for something like this for ages !..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!
Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Programming > FAQs

Microsoft SQL Server: Programming FAQ

Convert Access to SQL Server

MS SSMA Tools to Convert MS Access/Oracle/Sybase DBs to SQL Server
faq183-7072
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 FAQ Archive
Email This FAQ To A Friend

My Archive