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.

For information and an instructional video on adding email addresses to a user account on the Email Server, go to How do I Import My Database Using Direct Connection? (Video and Transcript).

To Import Your Database Using Direct Connection:

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.

Note: The database you select must contain enough disk space to store the database you want to import.

3. Under SQL Tools, click Import Data. The Database Migration: Select Source window appears.
4. Select Direct Connect and fill in your remote database settings. These settings are:
• Server/Instance Name: Type the full name of your SQL database server as you access it over the Internet. For example, sql000.mssqlservers.com or sqlexpress0.sql000.mssqlservers.com\sqlexpress0. Consult your provider for the exact name of your SQL server if we do not host it.
• Port: Select the port number of your SQL database server. Port 1433 is the most common port used by SQL servers. Port 1436 is also available if necessary. Consult your provider for the port you should use if we do not host the SQL server.
• Database Name: Type the name of your SQL database on your server.
• Database User ID: Type the User ID to access your SQL database.
• Password: Type the Password to access your SQL database.
5. Click Next. The Database Migration: Select Object Types window appears.
6. Select the Object Types in your database that you want to import (example: Tables, Stored Procedures).
7. Click Next. A Database Migration window appears for each Object Type you select (example: Select Tables, Select Stored Procedures).
8. Select the database objects for each Object Type you selected.
9. Click Next. The Database Migration: Finalization Options window appears.
10. 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.
11. Click Next. The Database Migration: Summary window appears.
12. Review the information you chose for the import and verify that it is correct.
13. Click Submit. A confirmation dialog box appears.
14. Click OK to complete the import request. 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 database file, go to Importing Your Database Using a Database File.

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 ^