Microsoft Dynamics 365 Blog

By default when you are installing the demo database by the installation program you can only install one Demo Database. But if you would like to have more than one Demo Database to try different things in, how to accomplish that? I assume that you know that you can create a new company in the classic client, but you will then not get the demo data. The solution is simple to use SQL Server Management Studio to attach more than one version of the Demo Database.

  1. Stop the SQL Server
  2. Make a copy the database files in “C:\Program Files\Microsoft Dynamics NAV\60\Database” to new location. For example “C:\NAVTestDB\”
  3. Start the SQL Server
  4. Start SQL Server Management Studio and connection to the instance where you have installed the other Demo Database.
  5. Right click on “Databases” and select “Attach” and click “Add”. Then pick the database file that you did copy to new location.
  6. Change the “Attach As” column for the new Demo Database file to “NAVDEMO”
  7. Press OK
  8. Update the Microsoft Dynamics NAV server configuration file to use the new database by open “CustomSettings.config” file in notepad. The file is normally located under “C:\Program Files\ Microsoft Dynamics NAV\60\Service”.
  9. Locate the DatabaseName key.
  10. Change the value attribute to “NAVDEMO”
  11. Restart the “Microsoft Dynamics NAV Server” service in the Windows Service manager

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!