Home » Knowledgebase » Database » MSSQL » How to use Webbase Enterprise Manager to manage the MSSQL...

How to use Webbase Enterprise Manager to manage the MSSQL...

How to use Webbase Enterprise Manager to manage the MSSQL database?

You can read this article if you have difficulties in inputting the database information in the Webbase Enterprise Manager.

To open the Webbase Enterprise Manager, you can browse the link, https://sqladmin.mysite4now.com/, with your web browser, and you will see the following page.
(You can also find the link in Hosting Control Panel -> Database -> MSSQL manager)

To create connection to your database,
1) Click the connection link.

2) Click the "DSN-less" link.

3) type in the database information and click on the Connect button.

4) Great~! You have connected to your database.

Function in Webbase Enterprise Manager

All the function in Webbase Enterprise Manager will be show as an icon. Here is the list of the icon and the function that it represent.

- Create NEW item

- Edit item

- Manage item

- Rename item

- Delete item

- Show Data

- Show constraints

- Export data as XML

- Export data as CSV

To run query,
1) Click on tool icon.

2) Click the "Query Analyser" link. The Query Analyser will be show on the right windows.

3) You can type in your query and click on the submit button to execute.

Tags:

database, database tools, mssql