Red Gate - SQL Compare

These pages cover SQL Compare 12, which is not the latest version. Help for other versions is also available.

1. System Requirements

1.1 Supported Platforms :

  • Windows Server 2008 R2, Windows Server 2012, Windows 7, Windows 8, or Windows 10

  • Microsoft .NET Framework 4.0 or later

  • Supported SQL Server versions::
    - SQL Server 2016
    - SQL Server 2014
    - SQL Server 2012
    - SQL Server 2008 R2
    - SQL Server 2008
    - SQL Server 2005
    - Microsoft Azure SQL Database
    - Amazon RDS for SQL Server

1.2 Around firewalls

If you aren’t receiving email updates from Redgate for licensing and authentication, this can sometimes be caused by the configuration of your email servers.

Whitelisting can help our emails get around firewalls and third-party tools designed to filter out emails. We recommend that you use the DNS names instead of the IPs as we don't guarantee to keep them constant.

The exact steps to follow will depend on your email server configuration and any additional spam protection software your organisation has in place, but these are the details your IT team will need to whitelist our emails:

The full list of endpoints relating to licensing:

The locally (to you) hosted endpoints for the Redgate Client service are ports 22221 - 22223 by default (e.g. 127.0.0.1:22221)

1.3 Permissions required :

SQL Server version

Recommended permissions

Minimum permissions  

Permissions if you want to compare
encrypted objects

SQL Server version

Recommended permissions

Minimum permissions  

Permissions if you want to compare
encrypted objects

SQL Server 2008 and later

db_owner role

SELECT for the system view sys.sql_expression_dependencies
(without this permission, comparing databases can be very slow)

VIEW DEFINITION permission

sysadmin role

VIEW SERVER STATE permission

SQL Server 2005

db_owner role

VIEW DEFINITION permission

sysadmin role

Deploying:

For deployments, we recommend using the db_owner role. However, it's possible to deploy with just the permissions to make the changes listed in the Summary tab (on the Review page of the deployment wizard).

Exactly which permissions you need depends on the objects in your databases, and what you're deploying.

You can't deploy objects that are encrypted, if they're encrypted in the source.

Permissions issues:

If you don't have the right permissions:

  • Some objects may be missing from the comparison results.
    For example, User Defined Types don't appear in the comparison results if you don't have permission to view the schema they belong to.

  • Deployments and deployment scripts may fail or have unexpected results.
    If a deployment fails, SQL Compare attempts to roll back the changes, using transactions. However, in some circumstances, rolling back isn't possible. 

2. Installation

There are several ways to find the installers you need for your Redgate tools:

  1. Finding Installers

  • Download product from the website.

  • Log in to the customer portal : access the details of your Redgate licenses by logging into your Redgate account on our website.
    The first view you see in the My Products tab shows a summary of all the licenses associated with your account and you can download the latest versions of your tools from here.

2. Run the installer and follow the instructions.
3. The product is listed on the Start menu under Redgate.

3. Licensing

You can use manual activation to activate products when your computer doesn't have an internet connection or your internet connection does not allow SOAP requests. You'll need access to another computer with an internet connection.

3.1 Manual activation

To activate manually:

  1. Click Activate manually.

  2. The Manual activation page is shown.

  3. Under Step 1, copy all of the activation request, and leave this dialog box open (if you close it you may have to start again).

  4. On a computer with an internet connection, go to http://www.red-gate.com/activate and under  Step 1, paste the activation request into the box.

  5. Click Get Activation Response.

  6. Under Step 2, copy the activation response.

  7. Alternatively you can save the activation response to a .txt file.

  8. Back on the computer where you're activating your Redgate product, under Step 2, paste the activation response.

  9. Click Finish.

  10. The Activation successful page is shown.

  11. You can now continue to use your product

You can use manual activation when an error is shown and the Activate Manually button is available.

Require an internet connection.

3.2 Using the user interface

  1. On the Help menu, click Manage my license. For some products you may need to click Enter serial number.

  2. Most products will ask you to log in with a Redgate ID next. 

    If you are the license owner (purchaser/administrator) and want to activate the product, you should log in with your existing Redgate ID.

    If the license was purchased for you, you should log in with your own Redgate ID.  If you don't already have a Redgate ID, you can create one by following the link in the window (more information about creating and using a Redgate ID).

    Enter the email address and password for your Redgate ID and click Login.

  3. Enter your serial number for the product on the next screen.
    You can find your serial number by logging in to your account on the Redgate website or by contacting the license owner.

  4. If you don't want to send your Windows user name and local machine name to Redgate when you activate your products, clear the Send information about this activation to Redgate check box.
    It can be useful to send information about your activation to Redgate in case you need to contact support in the future to find out where your serial keys are being used.

  5. Click Activate.

  6. Your product is activated and a confirmation page is shown.

  7. If your serial number is for a bundle or suite, all the other products in the bundle or suite are also activated.

  8. If there's a problem with your activation request, an error is shown. For information about activation errors and what you can do to resolve them, see Troubleshooting licensing and activation errors.

  9. You can now continue to use your product.

Require an internet connection.

3.3 Using Redgate ID

In the past, Redgate products could be activated using just a serial number.  In order to make it easier for you to manage your licenses and know who’s using a product, activation in most of Redgate's desktop tools now also requires users to log in with their Redgate ID.  The following does not apply to server-based tools such as SQL Monitor, SQL Back Up. 

  1. Download and install the product. 
    On the first run after installation, you are prompted to log in with your Redgate ID to activate the license.  If you don't have a Redgate ID you can follow the links in the client dialog to create one.

  2. You are only required to log in with your Redgate ID once on each computer, either through installing a product for the first time or updating an existing product.  As other products are upgraded or installed on that computer, they'll be activated using the same Redgate ID.

  3. Logging in with the same Redgate ID each time will only consume one entitlement.  If an additional Redgate ID is used, this will consume another entitlement.

If you are getting the message that you have run out of entitlements, you might not have logged in. On the toolbar of the tool, click on Help>Manage license and you'll see here if you're logged in:

Unable to connect to the Redgate Client Service when activating

To restart the Redgate Client Service open your Services console (Control Panel > Admin Tools > Services), select Redgate Client in the list of services and click Start.  

If this doesn't resolve the problem please send the latest Redgate Client Logs which can be found in C:\ProgramData\Red Gate\Shared Client\Log to Redgate support.

3.4 Removing A User (Freeing Up A License/Entitlement)

If you are getting the activation error 'Failed to activate the license: All of the x entitlements for serial xxx-xxx-xxxxxx-xxxx have already been claimed' you may not be logged in. On the toolbar, click on Help>Manage license and you'll see here if you're logged in.

If you are logging in with the same Redgate ID each time then you will be able to activate on as many machines as you need without running out of entitlements.

If you're not logging in with your Redgate ID, you have changed your email address or other people are using the license you may get a message saying that there aren't enough entitlements left on the license. If this happens you will need to log in to the customer portal and remove an old activation:

3.5 Moving A License To A Different Machine

There is no longer the need to deactivate your license to move it to another machine.

If you're logging in with the same Redgate ID each time you install your license on a machine then you will never run out of activations as this only uses one entitlement. 

If an additional user activates the same license, using their Redgate ID, this will consume another entitlement.

If you're having problems activating your license on a new machine it could be that you haven't logged in with your Redgate ID or that the ID doesn't match the one previously used. You may need to log in to the customer portal and free up an activation by removing an old user or removing the entitlement assigned to the wrong Redgate ID.  You will need to contact the license owner if you can't see the license in the portal.

4. Managing Licenses-User

4.1 Managing users

If you are a license owner or license admin, when you click on the Manage cog on the summary page you’ll see the detailed view for that product.

In the left section you will find a summary of your license and how it is currently being used. To the right is the Current allocated users section where you can invite and manage the allocated users of the license. Email addresses will be shown for users of the license who logged in with a Redgate ID or who were invited to use the license by an admin or owner.

4.2 Inviting a user

In the past Redgate products could be activated using just a serial number. In order to make it easier for you to manage your licenses and know who’s using a product, activation in most of Redgate's desktop products now also requires users to log in with their Redgate ID.  

To invite a user to use this product license, enter their email address in the email field and click Send. They’ll receive an email saying they’ve been invited to use a product. You can also enter multiple email addresses to invite more than one user at a time.

The email includes a link which, when clicked, takes them either to a page where they can create a Redgate ID (if they don’t already have one), or to the Redgate ID login page. Once they’ve logged in, they’ll be taken to the product summary view in My Products, where they can get the serial number which is needed to activate the product.  

You can invite as many users as you have licenses for the product. When you’ve reached the maximum number of invitations, you’ll see the message All licenses are currently in use above the list of allocated users, and the invitation functionality will be unavailable. In this scenario, you must first remove one of the existing allocated users before you can invite another user. 

4.2 Creating a Redgate ID

If you don’t already have a Redgate ID, you can create one:

  1. Go to the Redgate ID log in page and click Don’t have a Redgate ID?

  2. Enter an email address and password, and click Create Redgate ID.

  3. You'll receive an email from Redgate. Click the confirmation link in the email to confirm your email address.

You can now log in to your account.

4.3 Deactivating a user

To remove an allocated user, click on the Remove button alongside their details in the list. Then confirm the removal by clicking the subsequently displayed Remove button to deactivate them. A message will be displayed confirming that the user has been removed. This has the same effect as someone deactivating the product on their computer.

4.4 Migrating from anonymous to identified users

If you’ve been using Redgate products for a long time and have purchased multiple licenses, there’ll be a number of people using those products anonymously - labelled as Not logged in. This makes it hard to know exactly who is using which product, which can be a problem if you’re responsible for tracking license usage in your organisation.

User account licensing makes it possible to track allocated users for most Redgate products.

The recommended way to transition an anonymous user to an allocated user is similar for bundle licenses and single-product licenses:

  • For a bundle license, the user should Check for updates from within any one of the bundled products (e.g. SQL Data Generator).  

  • For a single-product license, the user should Check for updates from within that product.

  • Download and install the product update.

  • On first run after installation, the user is prompted to log in with their Redgate ID to activate the upgrade. If the user doesn’t have a Redgate ID they can follow the links in the client dialog to create one.

The user is only required to log in with their Redgate ID once on each computer, either through installing a product for the first time, or updating an existing product as described above.
As other products are upgraded or installed on that computer, they'll be activated using the same Redgate ID.

5. Managing Licenses -Admin&Owner

If you are a license owner, to add an administrator click Admins and enter the Redgate ID of the person(s) you wish to associate as admin of the license in the box under Add new license admins and click Send. A license admin can see license information as well as add and remove users from a license.

Similarly, license owners can be managed using the Owners tab. Only a license owner can invite and remove other owners and admins on a license as well as managing allocated users. 

License admins and owners do not consume a license activation unless they have also been invited to be a license user.

Inviting and removing license admins

To invite a person to be a license admin, enter their email address in the input field and click Send. That person will need to log on to the Redgate website with their Redgate ID. If they don't already have a Redgate ID, they can create one using the email address that was used to invite them. See more information about creating and using a Redgate ID . You can also enter multiple email addresses to invite more than one license admin at a time.

To remove a person's license admin rights, click on the Remove button alongside their details in the list. Then confirm the removal by clicking the subsequently displayed Remove button to remove them.

Submitting a license owner request

If you would like to request to become a license owner, in the customer portal, on the My Products page click on add existing license and enter the serial key of the license you wish to become owner of.

An email will be sent to any existing owners of the license asking them to accept or reject your request.  When the existing owner has accepted you will become an owner and will be able to see the license in your account.

In some instances, the existing owner may have left the company, when this is the case, if there are no other license owners to accept your request, the request will pend for 10 days and then automatically accept.  If you are unable to wait 10 days, please Contact Support.

Support Chanel:

For product-related issues : Submit a Request

For any security issues : Please report them via this page.