Importing SQL Server Database Objects
Print this Article
Comment on this Article
Last Updated:
August 12, 2008 11:01 AM
When importing a SQL Server database from an existing hosting account to your Windows shared hosting account, you can script out the existing database objects. By running the resulting script(s) in your Windows shared hosting account SQL Server Web Admin Query Analyzer, you avoid the manual set up of database tables.
NOTE: This article assumes that you have access to SQL Server Enterprise Manager for the scripting out of existing database objects and that a SQL Server database has been created in your Windows shared hosting account. For more information, see Setting up a SQL Server Database on Your Hosting Account.
To Script Database Objects Using SQL Server Enterprise Manager
- Open SQL Server Enterprise Manager.
- In the left navigation, expand Microsoft SQL Servers and SQL Server Group.
- Expand the appropriate server and its Databases folder.
- Click the appropriate database.
- Under the Tools menu, select Generate SQL Script.
- Click Show All and in the Object to script panel, select All tables.
- Click Preview to see the script and click Copy to save it to the clipboard.
To Import Database Objects Through the SQL Server Web Admin
- Log in to your Account Manager.
- In the My Products section, select Hosting.
- Next to the hosting account you want to modify, click Manage Account.
- In the Databases section of the Hosting Control Center, click the SQL Server icon.
- Next to the database to which you are importing, click the Open Manager icon.
- In the Navigation panel, click Connection.
- In the Connection panel, click Connection.
- Enter the User Name and Password you used when setting up the database.
- Click Connect.
- Expand the Tools folder on the left and click Query Analyzer.
- Paste your clipboard contents into the Query Analyzer window and click Submit.
For information about SQL Server data import, see Importing Data Into a SQL Server Database.