You can use Microsoft SQL Server Management Studio to import a SQL 2008 database not created in our shared hosting environment. Download the latest version of SQL Server Management Studio Express from Microsoft.
To Import MS SQL 2008 Databases
- Connect to the local SQL Server. On SQL Server 2008 Express, the command is typically \\SQLEXPRESS.
![](https://static.itegy.com/images/faq/1.jpg)
- From the Object Explorer, right-click on your local database, select Tasks, and then select Generate Script.
![](https://static.itegy.com/images/faq/2.jpg)
- In the Script Wizard, select your local database, and then select Script all objects in the selected database.
![](https://static.itegy.com/images/faq/3.jpg)
- Select the objects you want to script, and then change Script Use Database to False.
![](https://static.itegy.com/images/faq/4.jpg)
- Select Script to New Query Window, click Finish, and then click Finish. This process generates the script for importing your database.
![](https://static.itegy.com/images/faq/5.jpg)
- After the script is generated, click Close.
![](https://static.itegy.com/images/faq/6.jpg)
- Click the script to select it, and then choose Change connection. Complete the information for the remote database server to connect.
![](https://static.itegy.com/images/faq/7.jpg)
- To execute the script, verify that the name next to the Execute button matches your database name, and then click Execute!
![](https://static.itegy.com/images/faq/9.jpg)