ApexSQL for MySQL tools licensing and renewals

ApexSQL fundamentalist Toolkit for MySQL Subscription

Applies to

ApexSQL Database Power Tools for VS Code, ApexSQL Data Diff for MySQL, ApexSQL Diff for MySQL, ApexSQL Doc for MySQL.

Summary

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

Description

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 credential which is used to register on the Toad world site:

QUEST sign in window

When the credential is added, on the top of the right screen it will be shown user account, by click on the drop-down list, available options will be shown:

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

User information menu for MySQL tools

Manage your licenses online

By clicking on the Manage your license online, the user will be redirected to (license site) in which information about the license will be shown, (for which tool license is activated, administrator name, type of the license, the date when the license or trial period will expire, etc.).

Also, the customer in this window can activate the new license or shop for another product:

License/subscription management for MySQL tools

Adding sets/users

When an administrator buys a license for multiple users, adding those licenses can be done as follows.

Selecting Manage your license online from the account drop-down list (or from the license site):

Manage your license online

When the logging in process is done, the licenses site will be opened. The next step is to click on the dots and select from the drop-down list Manage Seats:

Add seats for MySQL tools

The new page will be opened, click on the ASSIGN USERS:

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, in the email addresses field, type the email address of the new user, then click on the ASSIGN USER:

Assign user to ApexSQL Fundamentalist Toolkit for MySQL

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

Manage User Access for MySQL tools

Check for updated license

Quick tip icon

Quick tip:

If the application is not started, and the customer adds his license on the site, when the application starts, the tool will automatically refresh the license.

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

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

How to activate the subscription

When the license was purchased, the customer will receive an email that contains all the needed information for activating MySQL tools.

From the received email copy of the License number:

ApexSQL fundamentalist Toolkit for MySQL Subscription

Add licensing can be done on this site or from the MySQL tools.

Start the application, If the user is not logged in, when the application is started, the Quest login window will be opened. The same credentials which are used to register on the Toad world site can be used here as well. When the login process is finished, from the account drop list, select Manage your licenses online, this will redirect the user to the site. Once the site is loaded, click the ACTIVATE LICENSE:

Activate license for MySQL tools

The new window will be opened, in the License number field write the license number, and click the ADD LICENSE:

Add license for MySQL tools

Note: The Site Message is not mandatory

The newly added license will be shown in the license section on the site:

Quest licensing site

Note: If there any issue with the license contact License@quest.com.

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

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 subscription from the site?

A: Yes, this can be done from the site, or select Manage your license online from the account drop-down list this will redirect the user to the site. Once the site is loaded, click on the three dots and select Remove license:

Remove License from the site

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 Toad world site, click the ACTIVATE LICENSE:

Activate MySQL licenses

Then type the received license number in the License Number field, then click the ADD LICENSE:

Add license on the site

The newly added trial period will be shown on the site:

Newly created license will be shown on the site

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

 

ApexSQL Database Power Tools for VS Code – Object search

Object search command from server level context menu

Applies to

ApexSQL Database Power Tools for VS Code

Summary

This article describes how to use the SQL Object search feature to find objects in MySQL and MariaDB databases.

Description

By using the SQL Object search feature, objects in MySQL or MariaDB databases can be found such as tables, table columns, stored procedures, user-defined functions, procedure and function parameters, views, etc. based on a specified phrase in the Search phrase box of the Object search pane: