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
- [Voiceover] Hi, my name is Adam Wilbert, and I'd like to welcome you to Migrating Access Databases to SQL Server. We'll start by applying what you already know about Access to SQL Server Management Studio, and explore the parallels between the two database systems. Once we've gotten comfortable with the SQL Server environment, we can begin looking at ways to move your Access tables into SQL Server. We'll start with a simple export and import process, and then turn our focus to a free tool called the SQL Server Migration Assistant. Along the way, we'll explore the conversion of our data types from those supported in Access, to the corresponding types in SQL Server.
Once our tables have been migrated to SQL Server, we'll link them back into Access using an ODBC connection, so that we can continue working with the form and report objects that make up the front end of our database. If you've been curious on how to start working with SQL Server, but have been hesitant to take the leap from Access, then you're in the right place. I created this course as an introduction to SQL Server that leverages what you already know from Access. By exploring the similarities, I hope to provide a more approachable introduction to a new and powerful environment that has a reputation for being more intimidating than it really is.
So enough talk, let's dig in.
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.