How do I import & export a MSSQL database?

This article applies to 123-reg Shared Hosting and 123-reg Premium Hosting packages.

This article will show you how to Import and Export MSSQL databases from your 123-reg Hosting package. 

Importing a Database

You may need to import a database if you are restoring an old version of your database or if you have an existing database that you wish to use on your 123-reg hosting package.

To Import a database, please do the following:

1

Login to your 123-reg control panel.

2

Scroll down to the Web hosting section.

3

Select the relevant domain name from the drop down box and click on the Manage button.

 Web_hosting_section.jpg
4

Click on the MSSQL Database link in the Web Tools section of your hosting control panel.

5

In the Manage Databases section press the Manage button to access your database administration area.

6

Click on the Import option in the Database menu.

7

Click on the Choose File button.

8

Navigate to the file you wish to import on your computer and press the Open button.

9

Click on the Import button.

10

Your import will have been successfully uploaded.