Continuing our work on Azure SQL Database management, over this weekend we released a new version of Cloud Portam. In this release we included support for managing databases. In the previous release, we included support for managing database servers. In this blog post we will talk about the features we released and our immediate roadmap.

In order to manage SQL Databases in Cloud Portam, first you would need to add the Azure Subscription account. Please see this blog post to get started with adding an Azure Subscription in Cloud Portam: http://blog.cloudportam.com/cloud-portam-updates-announcing-the-availability-of-azure-subscription-management-in-cloud-portam/.

Summary of Enhancements

In this release we included following features:

  • List databases in a database server.
  • Create new databases.
  • View deleted databases and restore deleted databases.
  • Delete databases.
  • View database properties.
  • Change database pricing tier.
  • Copy database.
  • Manage database tags.
  • View permissions on database.
  • Manage locks on database.

Now let’s talk about these features in details.

Database Management

List Databases

In order to list databases in a database server, simply click on the “Databases” link in the row for database server as shown below.

SNAGHTML5d18b8c

You will then see all the databases in that database server.

SNAGHTML5d3a052

When listing databases, Cloud Portam shows you the database name, pricing plan and status. It also fetches the information about the total size of the database and displays it.

SNAGHTML5d4ce91

Create New Database

Cloud Portam enables you to create a new database in the database server. Creation of a database is controlled by Role-based access control (RBAC) thus you will only be able to create a database if you have permission to do so.

From the databases dashboard, there are three ways by which you can initiate creation of a new database as shown below.

image

Currently there are three ways by which you can create a database in a database server:

  1. Create an empty database.
  2. Create a database from the latest full and differential backups of the specified source database.
  3. Create a database from a deleted database.

image

Each of these have been extensively covered in our previous blog post and I would highly recommend reading about them there.

Another thing I want to mention is that creation of a database is an asynchronous process. So when you create a database using Cloud Portam, Azure accepts the request and queues it. So it may take a little while for the new database to show up in the list of databases.

image

View/Restore Deleted Databases

Deleted a database by mistake! Cloud Portam enables you to view deleted databases in a database server and restore them if they are restorable. For example, I deleted “test-db-02” and “test-db-03” database.

image

image

image

Delete Databases

Cloud Portam enables you to delete one or more databases from your Azure Subscription.

Please note that deleting database is again backed by role-based access control thus you will only be able to delete a database if you have the permission to do so.

Furthermore if a database, database server or the database server resource group is locked, you will not be able to delete a database.

image

Deleting a database is an irreversible process. To ensure that you really want to delete a database we have included a simple CAPTCHA on the delete confirmation box.

image

View Database Properties

Cloud Portam enables you to view properties of a database.

image

image

Change Database Pricing Tier

Cloud Portam enables you to scale up/down a database by changing its edition and performance tier.

image

image

When changing the pricing tier, Cloud Portam only shows you the tiers to which a database pricing tier can be changed to. For example, when changing the pricing tier for a “Basic” edition database, Cloud Portam only shows “Standard” and “Premium” pricing tiers. Similarly when changing the pricing tier for a “DataWarehouse” edition database, Cloud Portam only shows “DataWarehouse” pricing tiers.

Also, please note that changing the pricing tier is an asynchronous operation thus it may take a little while for the new pricing tier to show up.

Copy Database

Cloud Portam enables you to copy a database from one database server to another. If you want you can also create a copy of a database in the same database server.

image

image

Please note that while copying the database, you can’t change the database edition (i.e. you can copy a “Basic” edition database to a “Standard” edition database) however you can change the performance tier of a database (i.e. you can copy a “Standard – S0” database to create a “Standard – S1” database).

Also, please note that copying a database is an asynchronous operation thus it may take a little while for the copied database to show up in the database list.

Manage Database Tags

Cloud Portam enables you to manage tags on a database. You can create new tag entries (key/value pair) and update or remove existing entries from a database.

image

image

View Database Permissions

Cloud Portam enables you to view the permissions you have on a database from the perspective of management of that database.

image

image

Manage Database Locks

Azure Resource Manager API allows you to lock your databases to prevent them from being accidentally deleted or updated. Cloud Portam enables you to manage locks on databases. Using Cloud Portam, you can create locks on a database. You can also view locks on a database or even delete the locks on a database.

Again, managing locks on database is protected by role-based access control thus you will only be able to perform this operation only if you permissions to do so.

image

image

image

What’s Next

When we looked at the management features for databases, we found about 30 features. In this release we included only a few of them. So please expect to see more database management features show up in the next few releases. Also we will work on elastic database pools management in the application. So stay tuned for those features.

Try It Out!

We humbly request you to try out these updates in Cloud Portam. This is available in both “Personal” and “Team” editions of Cloud Portam. Though extreme care has been taken regarding testing the current functionality, it is quite possible that we may have overlooked something. If you find something missing or implemented incorrectly, please feel free to reach out to us and tell us. We will fix the issues ASAP.

Closing

As you can see we’re constantly investing in making the product more and more useful. Do try out Cloud Portam and these features and let us know what you think. If you think, we can improve it in any way, please feel free to share your thoughts. The link to our website is http://www.cloudportam.com.