In Microsoft Dynamics NAV 2009 R2, five new predefined triggers for tracking database changes have been added to codeunit 1 and have IDs of 25 through 29. If you have any custom functions in codeunit 1 that use one of those IDs, then you must renumber them before you start the upgrade.

You perform the following steps to upgrade a solution from Microsoft Dynamics NAV 2009 SP1 to Microsoft Dynamics NAV 2009 R2:

1. Back up your Microsoft Dynamics NAV 2009 SP1 database.
   
   
2. Uninstall Microsoft Dynamics NAV 2009 SP1.
   
   When you uninstall Microsoft Dynamics NAV 2009 SP1, your database is not removed.
   
   
3. Install Microsoft Dynamics NAV 2009 R2 components. For more information, see Install and Configure Microsoft Dynamics NAV 2009 SP1 in the MSDN Library.
   
   If you use SQL Server with Microsoft Dynamics NAV, then you must select SQL Server Database Components, which were removed when you uninstalled Microsoft Dynamics NAV 2009 SP1, and select the Demo Database subcomponent of the Database components as Not available. If you do not exclude the Demo Database subcomponent, then you may see the following error message:
   
   Fatal error during installation. A database with name Demo Database NAV (6-0) already exists.
   
   The message may also advise you to delete the database. If you see this error message, then you can ignore it.
   
   
4. Open the Classic client, and then connect to your database.
   
   A dialog box opens and says that the database must be converted before you can use it with this version of Microsoft Dynamics NAV Classic. Click OK to convert your database.
   
   

   Important
   If you have installed the Classic client and the database on the same computer and you are running Microsoft Dynamics NAV 2009 R2 on Windows 7, Windows Server 2008, or Windows Vista, then click Start, point to All Programs, click Microsoft Dynamics NAV 2009, and then right-click Microsoft Dynamics NAV 2009 with Microsoft SQL Server. On the shortcut menu, click Run as administrator.

5. Recompile all objects in your database. To recompile the objects, in the Classic client, on the Tools menu, click Object Designer. Click All, press CTRL+A to select all objects, and then press F11.
   
   

After you complete a solution upgrade, your Microsoft Dynamics NAV application should work as expected with the new Microsoft Dynamics NAV 2009 R2 components. You do not automatically get the following new application functionality that is available in Microsoft Dynamics NAV 2009 R2:

• Connector for Microsoft Dynamics
  
  
• Online Services for Microsoft Dynamics ERP
  
  
• System Indicator
  
  

For more information, see Application Updates for Microsoft Dynamics NAV 2009 R2.

You can manually add these new features to your solution in Microsoft Dynamics NAV 2009 R2 after you perform a solution upgrade.

• If you have not customized the application objects that are affected by the new functionality, then you can import the R2NewAndUpdatedObjects_XX.fob file, where XX matches the locale of the version of Microsoft Dynamics NAV that you are using. You can find this file in the UpgradeToolkit\NewAndUpdatedObjects folder on the Microsoft Dynamics NAV 2009 R2 installation media. To import a .fob file, in Object Designer, on the File menu, click Import.
  
  
• If you have customized the application objects that are affected by the new functionality, then you must do the following:
  
  
  1. Export the changed objects from Object Designer.
     
     
  2. Merge the code in the objects from your application with the code in the R2NewAndUpdatedObjects_XX.fob file.
     
     
  3. Import the merged objects into Object Designer.
     
     
  For more information, see the Upgrade Toolkit Manual.pdf file. You can also see the following sections to decide whether you must merge code to get the new functionality.
  
  

After you have imported your objects, you should recompile all objects in the database to ensure that you get any additional application corrections that may have been added.

Added or Modified Objects for Online Services for Microsoft Dynamics ERP

Added or Modified Objects for Connector for Microsoft Dynamics

Modified Objects for the System Indicator Feature