Database module

[Marius]

We're starting the development of this new server module and we would like to hear your opinion about what should be included. Any suggestions are welcomed and we thank you in advance for all of them.

[Paul]

Well MySQL and MsSQL are two of the most used solutions and I think it would be great to have them. Also it would be great if we can *hook* to the database module with our plugins .

[Cptrico]

Hi Marius

Please also think about Oracle.

What should be included: hmm, maybe connection used. Loged on users accessing which resource. Dead/ thread locks could be some of the things included.

[dan.lee]

The ability to kick off MSSQL jobs would be nice.

[gareth25]

My thoughts are, main features should be:

• Start or stop instances.
  
• Structured Queries (We can create a structured set of queries to run to find information, etc)
  
• Performance Information
  
• Manage log files.
  
• Start or stop the SQL
  
• View, Start, Stop, Edit or delete Jobs
  
• Replication Status
  
• User and Credential Management
  

[jorgeluis.prado]

It would be great

- Start or stop the SQL Server

- View, start, stop, view the backup or jobs history even restores a DB from backup

- View errors reporting from database

[Paul]

- Start or stop the SQL Server

You can do this with Services feature.

- View, start, stop, view the backup or jobs history even restores a DB from backup

You can view, start, (stop?) agent jobs, and restore them via query (you can add favorite queries to avoid writing them).

- View errors reporting from database

You can view the server log.

All that for MSSQL server.