Upgrading Microsoft Dynamics NAV 2009 Native Database to Microsoft SQL Server

Code: 80298
Course duration: 2 days
Price:

80298: Upgrading Microsoft Dynamics NAV 2009 Native Database to Microsoft SQL Server (2 Days)

About this Course

This one-day course is designed for students preparing to upgrade Microsoft Dynamics NAV 2009 Native client to Microsoft SQL Server. This course covers the upgrade process from preparing existing data, configuring Microsoft SQL Server, troubleshooting data issues, to validating data after upgrade. Students wishing to take this upgrade course should have Microsoft SQL Server knowledge and take Microsoft Course 80156: SQL Server Installation and Optimization for Microsoft Dynamics NAV 2009.

Audience Profile

This course is intended for Developers, IT Professionals, Microsoft Dynamics Partner Professionals and Consultants.

At Course Completion

  • Describe the Upgrade Toolkit and list its relevant tools.
  • Explain relevant SQL migration tools.
  • Review the Native Database Architecture.
  • Describe client and server tiers.
  • Define data types in the Native Database.
  • 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.
  • 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.
  • 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.
  • 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.

Course Outline

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.
  • General knowledge of Microsoft Dynamics NAV
  • General knowledge of Microsoft SQL Server
  • Attended course 80043, Introduction to Microsoft Dynamics NAV 2009, What's New in Microsoft Dynamics NAV 2009-Installation and Development, and 80156 SQL Server Installation and Optimization for Microsoft Dynamics NAV 2009.

Course Reviews

No reviews found for this course.

Be the first to write a review