Module 1: Introduction to Upgrade Toolset

This modules describes the tools needed for migration to Microsoft SQL Server.

Lessons

• Upgrade Toolkit
• Relevant SQL Tools

Lab: Set Up a SQL Server Database Login

Describe the Upgrade Toolkit and list its relevant tools.Explain relevant SQL migration tools.

Module 2: Native C/SIDE Database

This module explores the Native C/SIDE Database Architecture and discusses the data types that exist within the C/SIDE Database.

Lessons

• Native Database Architecture
• Data in the Native Database

Review the Native Database Architecture.Describe client and server tiers.Define data types in the Native Database.

Module 3: Microsoft Dynamics NAV with Microsoft SQL Server Database

This module describes the data type differences in SQL Server.

Lessons

• Microsoft Dynamics NAV with Microsoft SQL Server Architecture
• SQL Server Data Types
• SQL Server vs. Native Database Sorting
• Advantages of SQL Server

Describe the SQL Server architecture that is used with Microsoft Dynamics NAV.Define SQL Server data types that are used by Microsoft Dynamics NAV.Compare the sorting differences between the SQL Server database and the Native database.Describe the advantages of using the Microsoft Dynamics NAV with Microsoft SQL Server architecture.

Module 4: Upgrade Considerations

This module discusses the migration to SQL Server as it pertains to hardware, software, security, and configuration.

Lessons

• SQL Server Requirements
• SQL Server Configuration Options
• Microsoft Dynamics NAV with Microsoft SQL Server Configuration Options
• Security

Lab: Configure Microsoft Dynamics NAV with Microsoft SQL Server

Define the hardware and software requirements of Microsoft Dynamics NAV with Microsoft SQL Server.Review additional Microsoft SQL Server configurations options.Configure the SQL Server database components in Microsoft Dynamics NAV.Describe security for Microsoft Dynamics NAV with Microsoft SQL Server.

Module 5: Data Clean-up

This module describes the process of finding and correcting data that is not compatible with Microsoft Dynamics NAV and Microsoft SQL Server.

Lessons

• Native Data vs. SQL Server Data
• Unsupported Data
• Causes of Unsupported Data
• Incompatible Data Corrections

Describe the data types used in SQL Server.Identify data that is not supported by Microsoft Dynamics NAV with Microsoft SQL Server.Explain how incompatible data gets into the database.Discuss methods of correcting incompatible data.

Module 6: Performing the Migration

This module explains how to perform the migration to Microsoft SQL Server.

Lessons

• Migration Process Overview
• Old Database Testing
• Data Checking
• Elements of the Migrate.fob
• Database Migration
• Migrated Database Testing

Lab: Migrate to SQL Server

Review the necessary preparations needed for migration and the steps required to complete the SQL Migration.Explain the first step of the upgrade process.Describe the process of checking the data to ensure it will work in SQL Server.Review the elements of the Migrate.fob file.Discuss migration of the Native database into the SQL Server database.Describe how to test the migrated database.