Before attending this course, students must have 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.

After completing this course, students will be able to 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.