Verio.com

Note: This article describes features associated with Windows plans. Some features are not available for all accounts, and may appear differently in your Control Panel interface. If you want to use this feature but do not have it, please call sales.

To Import Your Database From a Database File:

The following steps assume that you have accessed your Control Panel. For information about accessing your Control Panel, go to How do I access my Windows Hosting Control Panel?

1. On your Hosting Control Panel, click MSSQL Control Panel. The SQL Server Management window appears.

Note: This page may take a few minutes to load. If you have not yet upgraded your MSSQL database, you are taken to the Manage SQL Database window which will allow you to perform the upgrade. You must upgrade your database in order to use these feature.

2. Click Manage for the database you want. The Manage SQL Database window appears.
3. Under SQL Tools, click Import Data. The Database Migration: Select Source window appears.
4. Select Database File.
5. Select the folder and type the location and/or database name under Relative File Path.

Note: The database you specify is one you have uploaded to your Web Site.

6. Click Next. The Database Migration: Select Object Types window appears.
7. Select the Object Types in your database that you want to import (example: Tables, Stored Procedures).
8. Click Next. A Database Migration window appears for each Object Type you select (example: Select Tables, Select Stored Procedures).
9. Select the information for each Object Type in your database that you want to import.
10. Click Next. The Database Migration: Finalization Options window appears.
11. Select the Finalization Options you want. These are:
• Overwrite Mode: Select whether or not to overwrite information in your database schema. If you choose to overwrite, the database object is deleted and recreated and any data associated with that object will be lost.
• Data to Migrate: Select whether to import your Schema Only, Data Only, or Data and Schema.
12. Click Next. The Database Migration: Summary window appears.
13. Review the information you chose for the import and verify that it is correct.
14. Click Submit. A confirmation dialog box appears.
15. Click OK to go through with the import. The Manage SQL Database window appears with a confirmation message.

Note: Your database import request appears in the Pending Requests section if other databases on the server are processing.

For information about importing your database using a direct connection to your remote SQL database, go to Importing Your Database Using Direct Connection.

For information about backing up your database, go to Backing Up Your Database.

For information about viewing your request log, go to Viewing Your Request Log.

Back to top ^