ApexSQL for MySQL tools licensing and renewals

Applies to

ApexSQL Database Power Tools for VS CodeApexSQL Data Diff for MySQLApexSQL Diff for MySQLApexSQL Doc for MySQL.

Summary

This article explains how to activate MySQL tools from the ApexSQL collection.

Description

To eliminate the need for cumbersome procedures, the Quest has enabled its customers to directly manage their licenses as they see fit. The license management can be directly accessed through the dedicated web portal which will be explained in this article.

Note: To access the license management system, a web browser and an active internet connection will be required

For purpose of this article, ApexSQL Doc for MySQL will be used as an example.

Quick tip icon

Quick tip:

Every new customer will receive a 30-day trial period of the ApexSQL tools for MySQL. In the trial period, there are no limitations for using MySQL tools, all features and options will be available to use.

Command-Line Interface (CLI) also can be used in the trial period for MySQL tools which have support for it.

When the application is started for the first time, the Quest log in window will be shown, enter the Quest credentials which were used to register on the Licensing portal:

QUEST sign in window

When the credentials are added, the top of the right screen it will show user account, by clicking the drop-down list, the following options will be available:

  • Manage your license online
  • Check for updated license
  • Sign out

User information menu for MySQL tools

Manage your licenses online

With the Manage your license online option, the application will start a default web browser and open the site with the licensing portal in which the licenser information will be shown, (for which tool the license is activated, administrator name, type of the license, the date when the license or trial period will expire, etc.).

Also, through this portal new license can be added or a product can purchased:

License/subscription management for MySQL tools

Adding sets/users

When, let’s say an administrator, buys a license which contains multiple seats, filling up these seats can be done in the following manner.

Select the Manage your license online from the account drop-down list (or use this URL directly from a web browser: https://core-licensing-ui-prod.ism.quest.com/ licensing portal site):

Manage your license online

When the logging in process is done, the license portal will be opened. The next step is to click on the desired product:

Licensing portal Fundamentalist Toolkit

The License Detail page will be opened, click on the Seats tab (or MENAGE SEATS button):

License detail page Fundamentalist toolkit

Quick tip icon

Quick tip:

On this page administrators can see how many seats are used/free

Manage User Access for MySQL tools

The new page will be opened, click the Assign users button:

Assign users to ApexSQL Fundamentalist Toolkit for MySQL

The Assign users pop up will be shown, in the text field type the user’s email and click the Assign button:

Assign users to licensing portal for Apex MySQL tools

On the License detail page, the newly added user will be shown, and the new state of seats:

Manage User Access for MySQL tools

It is good to note that there is a possibility of adding multiple users at the same time

  • Adding multiple users using comma (,) between two user emails
  • Adding multiple users using CSV file (Bulk upload)

Adding multiple users using comma (,) between two user emails:

When the desired product is selected and Seats tab is opened, click the Assign users button:

Assign users to ApexSQL Fundamentalist Toolkit

The Assign users pop up will be shown, in the text field type the user’s emails (for example: user2@quest.com, user3@quest.com ) and click the Assign button:

Assign multiple users

As shown in the image below, the newly added users will be assigned, and the new state of seats will be shown:

Quest Licensing portal

Adding multiple users using CSV file (Bulk upload)

In this example the ApexSQL Fundamentals Toolkit for MySQL will be used in demonstrative purpose to show how to add multiple using CSV file.

When the License detail page is shown, hover the mouse over Assign users and the Bulk upload button will be shown, click on it:

Adding multiple users using CSV file

When the Bulk Manage users pop up is opened click on the ATTACH CSV file, select desired CSV file, and click the ASSIGN button:

Attach CSV file which contains users

  • NOTE: All previously assigned users will be removed using this option to assign multiple users, click the YES button to continue with the process of assigning new users:

    Attach CSV file which contains users

Import Successful message will be shown, and there will be additional information with the results of this action:

ApexSQL Fundamentalist toolkit for MySQL

Check for updated license

When the new license is added on the site, and the application was already started, the Check for the updated license must be used. This way the application will establish a connection with the server and newly added license will be loaded. After that, the ApexSQL tools for MySQL can be used again.

If the application isn’t already running, the license will be automatically refreshed when the application is launched.

How to activate the subscription

When the license was purchased, an email notification will be sent to the purchaser, that contains all the needed information for activating MySQL tools.

From the received email copy the License number:

ApexSQL fundamentalist Toolkit for MySQL Subscription

And use it with this web site or from the MySQL tools, like previously explained.

Start the application, and if not already logged with the Quest account, the Quest login window will be opened. The same credentials which are used to register on the Licensing portal can be used here as well. When the login process is finished, from the account drop list, select Manage your licenses online, to open the web site. Once the site is loaded, click the Add license:

Add license for MySQL tools

The Add License page will be shown, in the License number field paste the copied license number, or type it in, and click the ASSIGN button:

Add license for MySQL tools

Now when the license (subscription) is activated, launch the tool and on the top of the tool on the right side the account name, for which the subscription is added, will be shown:

ApexSQL Doc for MySQL

FAQs

Q: Can I activate the product offline?

A: No, this is not supported right now

Q: What is the offline grace period?

A: Since the subscription required a connection with the license server, the offline grace period provides our customers to work without a connection to the internet in periods of 7 days.

After 7days the customer will receive the following message when the tool is started:

ApexSQL Diff for MySQL

Establish a connection with the internet and click the Retry button.

The application will establish a connection with the License Server and the application can be used again.

Q: Can I remove the expired license from the site?

A: No, but there is an option to show/hide expired licenses by check/uncheck Show Expired check box:

Show Expired

Q: Can I use the application without logging into MySQL tools?

A: No. To work in all MySQL tools, logging is mandatory

Q: Can I extend the trial period?

A: Yes, the trial period can be extended

Q: Who should I contact to extend my trial period?

A: To extend the Trial period please contact Sales.CustomerSupport@quest.com

Q: How can I extend the trial period?

A: When the user receives an email with the license key, go to the Licensing portal site, click the Add license, type the license number and click the ASSIGN button:

Activate MySQL trial licenses

The newly added license will be shown on the site:

Newly created license will be shown on the site

Q: Why I received ”Invalid CSV template” information when trying to assign multiple users using the Bulk manage feature?

Invalid CSV template for assign multiple users

A: The CSV file must contain “Email” heeder to work correctly:

Correct CSV template for assign multiple users to licensing portal

Q: Can I download list of all assigned users?

A: Yes, this can be done from the Bulk manage users pop up, by click on theDownload your existing list of assigned users CSV file.

Download assigned users from the licensing portal

  • NOTE: As shown in the image above there is a possibility to download a CSV template

Q: Which types of the subscription can be used for ApexSQL for MySQL tools?

A: Our customers will be able to buy ApexSQL Fundamentals Toolkit for MySQL Subscription Term License initially