Migrate Microsoft Access Databases To Sql Server

Migrate Access databases to SQL Server by using SQL Server Migration Assistant for Access (SSMA for Access)

What you'll learn
Setup Access Database
Setup SQL Server
Backup Access Database
Create pre-migration assessment report
Convert Access Database Schema To SQL Server
Migrate Access Database To SQL Server
Perform Post Migration Checks
Requirements
SQL Server Migration Assistant -SSMA for Access Required. ( The course covers how to install it)
Description
Database migration is the process of migrating data from one or more source databases to one or more target databases  using a database migration service or tool. When a migration is finished, the dataset in the source databases resides fully, though possibly restructured, in the target database .In this course we will be migrating an Access Database into SQL Server using SQL Server Migration Assistant for Access.SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server, Azure SQL Database and Azure SQL Database Managed Instance. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server, Azure SQL Database or Azure SQL Database Managed Instance objects, loads the objects and migrates data to the target database.SSMA for Access is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2012 through SQL Server 2019, Azure SQL Database and Azure SQL Database Managed Instance.By using SSMA for Access, you can review database objects and data and assess databases for migration.We will convert the Access database schema to SQL Server before migrating the data.  After the migration we will query both the source and target databases to validate the data.

Overview

Section 1: Access Database Setup

Lecture 1 Introduction

Lecture 2 What is Microsoft Access

Lecture 3 How to get Microsoft Access

Lecture 4 Installing NorthWind Database

Section 2: SQL Server Setup

Lecture 5 What is SQL Server

Lecture 6 SQL Server Editions

Lecture 7 Download SQL Server

Lecture 8 Install SQL Server

Lecture 9 Install SQL Server Management Studio -SSMS

Lecture 10 Connect SSMS to SQL Server

Section 3: Migrate Access Database To SQL Server

Lecture 11 Backup Access Database

Lecture 12 Install SQL Server Migration Assistance for Access

Lecture 13 Create a new SSMA Project

Lecture 14 Create a pre-migration assessment report

Lecture 15 Create a new database

Lecture 16 Converting Access Schema

Lecture 17 Migrate Access Database to SQL Server

Lecture 18 Post Migration Checks

Beginners to Database Migration