MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Migrating Access Databases to SQL Server

Course Summary

At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server's advanced features, and maintain a link to the data in Access.Watch this course to learn how to leverage what you already know to take that next step. Adam Wilbert reviews the basics of SQL Server Management Studio (SSMS) and introduces two workflows for migrating Access data: one using a simple export/import process and the other using the free SQL Server Migration Assistant (SSMA). He also shows how to convert Access to SQL data types, link Access to SQL data via an ODBC connection, and address special concerns for Access 2010 data.


  • +

    Course Syllabus

    1. Getting Started
    2. Digging into SQL Server
    3. Using SQL Server Migration Assistant
    4. Making the Transition
    5. Connecting Access to SQL Server Databases
    6. Upsizing Access 2010 databases
    Conclusion


Course Fee:
USD 19.99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top