Join Adam Wilbert for an in-depth discussion in this video Downloading and installing SSMA, part of Migrating Access Databases to SQL Server.
- Let's walk through the process of getting our own copy…of the SQL Server Migration Assistant…installed on our computer.…I'm going to start at the Microsoft Download page…at microsoft.com/en-us/download.…Then, I'm going to come up here to the search box…and we'll perform a search for…SQL Server Migration Assistant.…Notice that we have different versions.…Here's one for Oracle, and here's one for MySQL.…The one I want is obviously for Access,…so I'll go ahead and click that link here.…And that'll bring up the search results…for the search terms that we put in.…
Now I don't want to just jump in…here to the very first link.…While it does say SQL Server Migration Assistant for Access,…you can see that the release date was back in 2006.…The version that I want is version 6,…which is this last one down here, it's the current version.…If you're seeing a newer version on this page,…then feel free to download that one,…it should work just fine.…You can see that this one was released in July of 2014.…Let's go ahead and select this link here.…
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.
- Why upgrade?
- Importing a SQL database
- Exploring data types and server objects
- Installing SSMA
- Mapping source and target data types
- Using the Migration Wizard
- Linking to migrated tables in SSMA
- Working with views and stored procedures
- Linking Access to SQL Server databases
Skill Level Intermediate
1. Getting Started
2. Digging into SQL Server
3. Using SQL Server Migration Assistant
4. Making the Transition
Backing up the database1m 19s
5. Connecting Access to SQL Server Databases
6. Upsizing Access 2010 databases
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.