Tools Add
Rss Categories

How to export a Microsoft SQL (MSSQL) database

Reference Number: AA-04950 Created: 2013-06-30 06:52 Last Updated: 2013-06-30 06:55 0 Rating/ Voters

In this tutorial, we will be showing you how to export your MSSQL database using the Microsoft Server Management Studio tool, which can be downloaded from the link below:

1) Open Microsoft SQL Server Management Studio and connect to the database server with using the database server name, login and password that you created for your database. This information can be found on the control panel, under the More Services -> Databases link and by clicking on your database name in the list, next to the label 'External Hostname'.

Connection Settings

2) After you connect to the database server, find your database name in the object explorer pane.

Object Explorer

3) Right click your database and choose first "Tasks" then "Generate Scripts…"

Generate Scripts

4) Click on "Next" to start selecting which database objects to back-up.

Generate Scripts Window

5) Choose the tables that you would like to back-up from your database (You can also click on Select All to choose all of them).

Select Tables

6) Click on "Advanced" to access the advanced settings of the back-up process. Also set the location where you want to save the file on your local computer.

Set Scripting Options

7) Choose "Schema and data" for the option Types of data to script, if you want you can also turn on the "Script Full-Text indexes" and also "Script Indexes" options for your back-up.

Advanced Scripting Options

8) Review the summary and click "Next" to start the back-up process.

Review Summary

9) Make sure all the steps of the process completed successfully.

Successful Completion

At the conclusion of this tutorial, you should now have a backup of your MSSQL database which can later be restored and imported if ever needed.

Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: