Course 80298A:

Upgrading Microsoft Dynamics NAV 2009 Native Database to Microsoft SQL Server

Length:1 Days
Published:December 23, 2010
Language(s):English
Audience(s):IT Professionals
Level:200
Technology:Microsoft Dynamics NAV 2009
Type:Course
Delivery Method:Instructor-led (classroom)
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 OutlineModule 1: Introduction to Upgrade ToolsetThis 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 DatabaseThis 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 DatabaseThis 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 ConsiderationsThis 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-upThis 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 MigrationThis 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.
Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:

Find Training Near You

Location:

Eg: Seattle, WA or Paris, France