How To Create Tables / Move Data to SQL Server On Hosting Server?

First step is database creation on the host server. Follow these steps:

Step 1: Create SQL Database

First step is database creation on the host server. Follow these steps:

Login into control panel as web administrator.

  1. Click on the Database Manager, click Add Database link in left frame and click on Add Database button.
  2. Enter The following information

    • Database Name: The name by which you want to create database in SQL server.
    • Database Login: The login name for newly created database. HC will create this new login in SQL and assign rights on the database.
    • Password: The password for above login name.
    • Target Database Path: The physical path for SQL database files (.MDF & .LDF files).

  3. Click Create Database button.

Step 2: Create Backup of local SQL database

SQL database backup creates a backup of your local database which is later restored on host server. Follow these steps:


  1. Open SQL Server Enterprise Manager. Expand a server group, and then expand a server.
  2. Expand Databases, right-click the database, point to All Tasks, and then click Backup Database.
  3. In the Name box, type the backup set name. Optionally, in Description, type a description of the backup set.
  4. Under Backup, click Database - complete.
  5. Under Destination, click Tape or Disk, and then specify a backup destination. If no backup destinations appear, click Add to add an existing destination or to create a new one. Click OK button.
  6. Upload this database backup to /db folder of your website.

Step 3: Restore the SQL backup on remote hosting server

Restoring SQL database complates the task. Follow these steps:


  1. Login in Control Panel as web administrator.
  2. Click on Database Manager, and click List Databases.
  3. Select the database you created in Step 1 and click on Restore button. Browse to the /db folder and select the database backup created and uploaded to /db folder in Step 2 above. Click Select File button.

The above three steps will restore all the tables, procedures, view etc along with their data to remote SQL server on hosting server.

The following procedure guides you how to create tables in remote SQL server if you don't have database backup or this is a fresh database.

To create new tables in SQL server

Follow the Step 1 above to create a database in SQL server.

  1. Create tables in SQL server programmatically using following formats

    • CREATE TABLE tablename (columnName  datatype [primary key][NOT] NULL [,])
    • CREATE [unique/clustered] INDEX indexname ON tablename(columnName(s))
  • 28 Users Found This Useful
Was this answer helpful?

Related Articles

MS SQL Server Error: Unable To Create The SQL Server Object

Answer: If you are trying to install Hosting Controller on a machine where MS SQL server is not...

When I try to add MS SQL database, I get error

This error occurs in two cases: MS SQL services are not running Hosting Controller is...

I am not able to perform action. Error-access denied for user - root@localhost (using password: YES)

 am trying to add mySQL database but getting this error: Error: 71400050 : Unable to...

What is MySQL, MS SQL, etc?

Answer: MySQL and MS SQL are database systems. Depending on what your host provides, you can use...

What is MySQL Database?

MySQL is an open-source RDBMS (Relational Database Management System) that relies on SQL for...

Powered by WHMCompleteSolution