Step 1. Launch Export Wizard

To launch the Export wizard, do the following:

  1. In the navigation pane, select a database.
  2. On the Database (or Server/Instance) tab, select Export Schema > Export database schema and data.

Alternatively, you can right-click a database and select Export schema > Export database schema and data.

 

Tip

To import data tables, use the standard SQL server bcp.exe utility. For more information, see this Microsoft article.

Launching Export Wizard