Changes (as compared to 10.51) include:
* Now SQLyog (including SJA for Windows) is available as both 32 and 64 bit binaries. Obviously the 64 bit version will require a 64 bit Windows. 32 bit version will install to ‘Program Files (x86)’ and 64 bit to ‘Program Files’ on 64 bit systems. There are a few cases you should be aware of. Please read the two notes at the bottom.
* Autocomplete is now context-aware. The keyword before any type of autocomplete popup/dialog will be used for filtering and displaying only object types relevant in the context.
* Copy to clipboard from GRID could in rare cases truncate the last row away. This bug was introduced in version 9.51.
* Fixed a bug in import external data where clicking on “select all” would select tables even when no data was returned from the source. This could cause a crash while executing the job. This was introduced in 10.1.
* If there was no default database selected in the main dialog of SQLyog, changing the database from the dropdown in ‘backup as SQL dump’ dialog would cause SQLyog to hang. Introduced in version 10.5.
* When using drag and drop to create a Foreign Key constraint in Schema Designer, the ALTER TABLE pop-up dialog would have the view scrolled to the right, resulting in the leftmost two columns being hidden. This issue was introduced in 9.6.
Cases to be aware of when upgrading:
1) Program identification:
Both the 32 bit and the 64 bit installers distributed have new file names identifying their ‘bit-depth’. Also in ‘add/remove programs’ they are identified with their ‘bit-depth’. Same applies to desktop and start menu shortcuts created by the installer. This means that after upgrading, the old registry entry and shortcuts will exist in parallel with the new ones created. After installing the 32 bit version the old shortcuts can simply be deleted (as they point to same files as shortcuts created with the 11.0 installer). However be aware that if you have a pre-11 version installed, next install the 11.0 64 bit version and finally uninstall the old version, your registration details will be removed from the system and you will be prompted for them again when starting version 11 for the first time after. This will be solved with the 11.0 GA release. So in the meantime we suggest you leave both versions on your system.
2) ‘Import external data’ (ODBC):
The 64 bit version will require 64 bit ODBC-drivers. This is a particular problem with import from Microsoft Office programs as well as from text/CSV files when not using a DSN created explicitly but using the temporary file-DSN that SQLyog can create in the background. The problem is that 32 bit MS Office will install 32 bit drivers and after that 64 bit drivers cannot be installed (it is possible the other way around and 64 bit MS Office drivers are available for download. MS Office 2013 64 bit – and maybe also MS Office 2007 64 bit – installs 64 bit drivers that works fine with the 64 bit architecture of this release. Office 2010 did not have the option for 64 bit). This issue as well as non-availability of 64 bit drivers for some of your data sources may make you decide to stay with the 32 bit version or have both the 32 bit and the 64 bit version installed.