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 1: Create a new database and db username on your hosting account
> Log into your control panel.
> Click on SQL Server 2012
> Click on Create Database
> Type the database name and click on Save
> 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.
Done, now the database and database user are created on your hosting. Lets 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.
> 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).
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 panels File Manager or any FTP Software ( eg: FileZilla )
> 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
> Select “Hosting Space File” and then select the path to your .bak file and click Restore
Done. Now your database is restored.
Done. Now your database is restored. For the connection string, check Step 4 - See more at: http://blog.arvixe.com/how-to-upload-my-local-mssql-database-to-my-hosting-account-and-configure-my-connection-string/#sthash.e3uTZAqB.dpuf
