There are several methods to get data in and out of your database, and recommended uses for each method.

Method Recommended uses For more information

Import and Export from the File menu in the development environment.

To move, copy, or share objects from Object Designer.

Note
This exports the design object, but not the data, from the database.

How to: Import Objects

How to: Export Objects

Import Worksheet

ImportObjects and ExportObjects commands.

To move, copy, or share objects from a command prompt. Use the commands if you want to automate the import or export.

Note
This exports the design object, but not the data, from the database.

Development Environment Commands

How to: Import Objects

How to: Export Objects

Export the dataset of a report as an .xml file.

  • To view a report on a computer that does not have Microsoft Dynamics NAV installed.
  • To troubleshoot a report on a computer that does not have Microsoft Dynamics NAV installed.
Note
This exports the structure of the dataset and the data from the report.

Walkthrough: Running a Report Offline

Import and export text strings by choosing Translate on the Tools menu in the development environment.

To translate strings for customized objects in a multilanguage environment.

How to: Add Translated Strings By Importing and Exporting Multilanguage Files

Import from or export to a backup file by choosing Backup on the Tools menu.

To backup a database or a company within a database.

Warning
You can choose if you want to backup application objects, data from the database, or both.

How to: Make Backups