Difference between revisions of "MSSQL Manager"

From Help
Jump to: navigation, search
(Created page with 'This tool allows you to manage imports and exports for existing Microsoft SQL Server databases. <br> If you do not already have a database you may request to create one by subm…')
 
 
Line 1: Line 1:
−
This tool allows you to manage imports and exports for existing Microsoft SQL Server databases.
+
== Overview  ==
  
−
<br> If you do not already have a database you may request to create one by submitting a ticket using the "Create New Ticket" tool. When submitting the ticket please specify database name, username and password.  
+
The MSSQL Manager application allows you to manage imports and exports for existing Microsoft SQL Server databases.  
  
−
<br>
+
If you do not already have a database you may request to create one by submitting a ticket using the "Create New Ticket" tool. When submitting the ticket please specify database name, username and password.
  
−
'''EXPORT'''
+
To launch the MSSQL application:
  
−
<br> 1. Select a database from the left panel.  
+
#On the Start Services page, click '''Advanced Tools'''.
  
−
<br>
+
#On the Advanced Tools page, click '''MSSQL&nbsp;Manager'''.
  
−
2. Click "Apply" to list the files on the right panel on the same page.
+
== MSSQL Database  ==
  
−
*Click "Cancel" in order to dismiss your selection.
+
The MSSQL Database page, allow you to add a database and view the details of existing databases.  
  
−
<br>
+
To add a database:
  
−
3. Beside each file in the right hand side panel there is a download icon. Click on the download icon corresponding to the file you would like to download.  
+
#On the Main Menu page, click '''MSSQL Database'''.  
 +
#On the MSSQL database manager page, click '''Add new MSSQL database'''.
  
−
<br>
+
== Manage Backups  ==
  
−
4. A pop-up will prompt you to select whether you would like to save the file or open it. Select "Save" in order to save the file on your computer or select "Open" if you would like to open the file without saving it.  
+
<span style="margin: 0px">The Manage Backups page allows you to backup&nbsp;your data and restore it to an existing database.</span>
  
−
<br>
+
=== Restore  ===
  
−
5. Click "Ok" to process your selection in step 4.
+
To restore a file or database:
  
−
<br>
+
#On Main Menu page, click Manage Backups.
 +
#On the Manage Backups page, select the database from the drop-down.
 +
#Click the file name that you want to restore from the Select file for restore list.
  
−
<br> '''IMPORT'''
+
=== <span style="margin: 0px">Import</span>  ===
  
−
<br>
+
To Import a database:
  
−
1. Click "Browse" to locate the file on your computer that you want to import.<br>  
+
#<span style="margin: 0px">On the Main Menu page, click '''Manage Backups'''.</span>
 +
#<span style="margin: 0px">On the Manage Backups page, click '''Import'''.</span><span style="margin: 0px"> </span>
 +
#<span style="margin: 0px">In the Upload from computer field, click '''Browse'''. </span>
  
−
2. Click "Upload" to import the selected file.<br>  
+
=== <span style="margin: 0px">Export</span> ===
  
−
3. The imported file will be visible in the "Export" section.  
+
To export a database:
 +
 
 +
#Select a database from the left panel.
 +
#Click '''Apply'''. The&nbsp;files are displayed in the Select file to download list..
 +
#Click on the download icon corresponding to the file you would like to download.
 +
#A pop-up dialog will prompt you to select whether you would like to save the file or open it.
 +
#Do one of the following: <br>To save the file on your computer, click '''Save. <br>'''To open the file without saving it,&nbsp;click '''Open'''.
 +
#Click '''OK'''.
 +
 
 +
== Security  ==
 +
 
 +
The Security page allows you to&nbsp;a<span style="margin: 0px">dd your IP address or a range of IP addresses to the list of the allowed IP addresses.</span>
  
 
[[Category:Setup]]
 
[[Category:Setup]]

Latest revision as of 15:07, 4 November 2011

Overview

The MSSQL Manager application allows you to manage imports and exports for existing Microsoft SQL Server databases.

If you do not already have a database you may request to create one by submitting a ticket using the "Create New Ticket" tool. When submitting the ticket please specify database name, username and password.

To launch the MSSQL application:

  1. On the Start Services page, click Advanced Tools.
  1. On the Advanced Tools page, click MSSQL Manager.

MSSQL Database

The MSSQL Database page, allow you to add a database and view the details of existing databases.

To add a database:

  1. On the Main Menu page, click MSSQL Database.
  2. On the MSSQL database manager page, click Add new MSSQL database.

Manage Backups

The Manage Backups page allows you to backup your data and restore it to an existing database.

Restore

To restore a file or database:

  1. On Main Menu page, click Manage Backups.
  2. On the Manage Backups page, select the database from the drop-down.
  3. Click the file name that you want to restore from the Select file for restore list.

Import

To Import a database:

  1. On the Main Menu page, click Manage Backups.
  2. On the Manage Backups page, click Import.
  3. In the Upload from computer field, click Browse.

Export

To export a database:

  1. Select a database from the left panel.
  2. Click Apply. The files are displayed in the Select file to download list..
  3. Click on the download icon corresponding to the file you would like to download.
  4. A pop-up dialog will prompt you to select whether you would like to save the file or open it.
  5. Do one of the following:
    To save the file on your computer, click Save.
    To open the file without saving it, click Open.
  6. Click OK.

Security

The Security page allows you to add your IP address or a range of IP addresses to the list of the allowed IP addresses.

Retrieved from "http://websupportwiki.com/en/index.php?title=MSSQL_Manager&oldid=578"