Upload Local MSSQL Database and Configure Connection String

Hi!

Today we will show you how to upload your database to your hosting account with us. This includes four steps:

Step 1: create a new database and db username on your hosting account.
Step 2: take a backup of your local database.
Step 3: restore the backup of your local DB into your newly created DB from Step 1.
Step 4: the connection string

Step 1: Create a new database and db username on your hosting account

- Log into your control panel.

- Click on SQL Server 2012

db1

- Click on Create Database

db2

- Type the database name and click on Save

db3

- Now to create the db username, Click on SQL Server 2012 then click on Create user.

- Type the db username, password and password confirmation then set the “Default database” to the one you have already created and check the database name as well. Click on Save.

db4

- Done, now the database and database user are created on your hosting. Let’s go to Step 2.

Step 2: Take a backup of your local database

This step is to be done on your local machine.

- Using SQL Server Management Studio. Click the server name to expand the server tree Then expand Databases. Right-click the database, point to Tasks, and then click Back Up.

db5

- Most of things should be set by default. You can change the location of the database .bak file if you want by removing the current location and then click on Add to add a new location. You will be asked to enter the backup file name as well (ex: testing.bak).

db6

- Now you have your database .bak file. To Step 3.

Step 3: Restore the backup of your local DB into your newly created DB

- First you will need to upload your .bak file to your hosting account. To do this, you can use your control panel’s File Manager http://blog.arvixe.com/how-to-use-file-manager-in-websitepanel/ or using FTP http://blog.arvixe.com/ftp-basics/ .

- Now go back to SQL Server 2012 on your control panel and then click on the database you have created.

- Click on Maintenance Tools then click on Restore

db7- Select “Hosting Space File” and then select the path to your .bak file and click Restore

db8

- Done. Now your database is restored. For the connection string, check Step 4

Step 4: The connection string

Now everything is ready and set, you just need to configure your connection string. You will need to use the database name, username and password you have created in Step 1. To configure your connection string, please check https://support.arvixe.com/index.php?/Knowledgebase/Article/View/51/8/do-you-have-a-connection-string-i-can-use-to-connect-to-the-local-mssql-database .

You are ready to go online.

Looking for quality web hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , , , , , | Posted under Windows Server Admin | RSS 2.0

One Comment on Upload Local MSSQL Database and Configure Connection String

  1. Yigit says:

    You are great! I easily move my db to your server :)) Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *


6 × = 36

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>