Step 1. Launch Export Wizard

To launch the Export wizard, do the following:

In the navigation pane, select a database.
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.