MSSQL Manager

From wikihelp
(Redirected from Mssqlmanager)
Jump to: navigation, search

This tool allows you to manage imports and exports for existing Microsoft SQL Server databases. MSSQL Manager is a web-based MSSQL client that allows you to create and manipulate MSSQL databases. The Database Manager is designed for advanced users and knowledge of relational databases and SQL is required in order to use it efficiently.

Contents

Add a MSSQL Database

  1. Click on the “Add new MS SQL database” icon. The right hand side of the screen will become active
  2. Choose a database from the drop down menu.
  3. Click “Apply” to add the chosen database.

Note: You will notice that newly added database(s) will be displayed with the status of “Pending addition”. Once the database will become active you will be able to change the size and service type of your database.

Change the size and database service type of a MSSQL Database

  1. Select a database from your list of databases. On the right hand side under the Database details section you will be displayed with details pertaining to the selected database.
  2. Click on the “Change” link.
  3. Select a new service type from the drop down menu.
  4. Click “Apply” to save the changes. You will notice that the status of the database will change to “Pending change”.
  5. Close the application. The changes will take effect in few minutes.

Delete a MS SQL Database

  1. Click on the “Delete “icon corresponding to the database you wish to delete.
  2. Click “Apply” to finalize the deletion process. You will notice that the status of the database will change to “Pending deletion”.
  3. Close the application. The changes will take effect in few minutes.

Import a MS SQL database

This section allows you to import an existing MSSQL database.

  1. Click on “Import” tab.
  2. Select a database from the drop down menu.
  3. Click on “Browse” to locate a backup file on your computer.
  4. Click on “Upload” in order to upload the back up file. Once you upload a file the page will display the imported file.
  5. In order to delete a file to be imported click on the Cancel Import icon.
  6. In order to finalize the cancelation click on “Apply” in the bottom right corner of the page. The status of the file will be changed to “restore”.

Export a MS SQL Database

This section allows you to export an existing MSSQL database.

  1. Click on “Export” tab.
    Note: You will notice that your database(s) will be displayed on the left hand side under “Select database to export” with a status of “Ready” which means it is ready to be exported. You will also notice that the backup file(s) will be displayed on the right hand side under the “Select file to download”.
  2. In oder to export a database click on the exclamation icon.
  3. Click on “Apply” in order to finalize the export.
  4. In order to download a file click on the download icon. You will be able to either open it or save it on your computer.

Security

Due to security policy, remote database management using third party software is restricted on our hosting platform. To have ability to manage your MSSQL databases through database client add your IP address to the list of allowed IP addresses. You are allowed to set the IP range within the last three digits of the IP address.

  1. Click on “Security” tab.
  2. Select a database from the drop down menu.
  3. Click on “Add allowed IPs” icon to add an IP to the list of allowed IP(s). You will notice that the right hand side will become active
  4. Enter the desired IP address or click on the “Get IP of this computer” in order to just automatically enter the IP of the computer you are using.
  5. Choose the type of connection by clicking on the appropriate radio button. There are two options: Permanent (allows a permanent connection to MSSQL server) and Temporary for 1 day (connection from this type of IP will be allowed for 24 hours.
    • After that the IP will be removed from the "Allowed IP(s)" list, and any attempt at connection from this IP will be rejected. To continue using this IP, you will need to re-add the IP to the "Allowed IP(s)" list.)
  6. Click “Apply” to add the IP to the list of allowed IP(s). Once added on the left hand side you will notice the IP listed with the status of “Pending addition”.
Personal tools
Namespaces

Variants
Actions
NAVIGATION
Design
Website Tools
Ecommerce
E-mail
Domains
SEO and Analytics
Advanced Tools
Website Add-Ons
Online Marketing
Social
Webmail
Applications