Free non commercial license - MySQL Compare from Redgate

[FrancisChung]

Redgate is giving out non commercial licenses for its MySQL Compare and MySQL Data Compare tool.

I've used their SQL Server Compare tools and the ToolBelt extensively many years ago, and it saved my back side time and time again.
I only happen to come across it because I was looking out for a MySQL Compare tool to work out the difference between my Test & Live Servers.

The unfortunate caveat is that it only runs on Windows ...... perhaps it will still be of use to someone.
I will try running it on Parallels and see if it can access a MySQL Instance running on the OS X Parent .... 

http://www.red-gate.com/products/mysql/mysql-comparison-bundle/

[szabesz]

Thanks for the info! I will take a look. I'm also a Parallels user which I normally use for IE/Edge testing purposes only.

For those interested, I succesfully use SquidMan to connect to my MAMP Pro's server on my Mac from the Parallels virtual machine and/or from other (mobile) devices on my network (actually, all requests will be routed through SquidMan):

Set up a permanent local IP for your local dev computer, for instance 192.168.1.10 or take a note of the one assigned to it by DHCP.

Open SquidMan and access the application preferences:
    - In the "General" tab under "HTTP port" enter "8080"
    - Next, in the "Clients" tab enter a range of allowed devices.
        - example: 192.168.1.0/24 and/or 192.168.0.0/24 etc...
    - In the "Template" tab, comment out "http_access deny to_localhost", like this:
        # protect web apps running on the proxy host from external users
        # http_access deny to_localhost
    - Save changes.

Launch your web server and SquidMan.app. Your local web sites are now open to visitors.

On a Mac you'll need to adjust your network settings to use this proxy for HTTP traffic:
    - Open the System Preferences panel, click the Network icon.
    - Create a new 'Location' that uses the Squid proxy.
    - Set the HTTP proxy to be "localhost", port "8080" and turn on "Web proxy (HTTP)" on the "Proxies" tab.
    - Next click on "Apply Now".

On your Parallels virtual machine / remote (mobile) device connected to your local network you also need to use the proxy:
    - Go to your network settings.
    - Optionally, if it is possible to use profiles: create a new Profile that uses the Squid proxy.
    - Set the HTTP proxy to be your local dev machine's IP with port "8080".

For the Parallels virtual machine set networking to "Bridged Network".

Edited October 1, 2016 by szabesz
remote device proxy setting must point to your local dev machine's IP

[szabesz]

I had to realize that "sharing" my Mac's webserver over the network the above mentioned way is for accessing the local websites, whereas connecting directly to MySQL from the Parallels Windows machine is a different matter... However, I just could not figure out how to do it, so if you succeed, please share.

Edited October 1, 2016 by szabesz
typos

[FrancisChung]

Have you had a look at this @szabesz?

https://forum.parallels.com/threads/accessing-mysql-mac-from-windows.105647/

If I recall correctly, I think I had a similar situation with SQL Server where the version (32/64) of the client driver had to match the Server.

Edited October 1, 2016 by FrancisChung
More Information

[szabesz]

Yes I have had, but gave up  at least for the time being. Also, I did not figure out how to "register" MySQLComparisonBundle.exe to utilize the advertized "free for non-commercial version".

[FrancisChung]

I think they send you an e-mail with a registration Key. I too was waiting for the e-mail but I think a customer rep sends it sans Redgate labelling which is why you might not see notice it in your inbox.

Edited October 1, 2016 by FrancisChung
Better clairity

[szabesz]

1 hour ago, FrancisChung said:

I think they send you an e-mail with a registration Key.

I see, thanks. I wait patiently then

[FrancisChung]

Perhaps they handle this manually by a customer rep so you may need to wait until Monday / Tuesday.

Mine was a guy by the name of Jordan Miller and gmail treated it like a promo e-mail so it was nowhere to be seen initially.