Dbforge studio


10 лучших инструментов для разработки и администрирования MySQL / Хабрахабр

Многие компании создают различные многофункциональные приложения для облегчения управления, разработки и администрирования баз данных.

Большинство реляционных баз данных, за исключением MS Access, состоят из двух отдельных компонентов: «back-end», где хранятся данные и «front-end» — пользовательский интерфейс для взаимодействия с данными. Этот тип конструкции достаточно умный, так как он распараллеливает двухуровневую модель программирования, которая отделяет слой данных от пользовательского интерфейса и позволяет сконцентрировать рынок ПО непосредственно на улучшении своих продуктов. Эта модель открывает двери для третьих сторон, которые создают свои приложения для взаимодействия с различными базами данных.

В Интернете каждый может найти много продуктов для разработки и администрирования баз данных MySQL. Мы решили собрать 10 самых популярных инструментов в одной статье, чтобы вы смогли сэкономить свое время.

1. Workbench
Первое место, по праву принадлежит инструменту Workbench (разработка компании Sun Systems/Oracle), который может работать на платформах Microsoft Windows, Mac OS X и Linux. Workbench объединяет в себе разработку и администрирование баз данных и является преемником DBDesigner4.

MySQL Workbench распространяется под свободной лицензией — Community Edition и с ежегодной оплачиваемой подпиской — Standard Edition. Последняя включает в себя дополнительные возможности, которые способны существенно улучшить производительность, как разработчиков, так и администраторов баз данных.

Скачать Workbench можно здесь dev.mysql.com/downloads/workbench

Стоимость — бесплатно.

Что делает Workbench популярным?

  • возможность представить модель БД в графическом виде, а также редактирование данных в таблице;
  • наличие простого и функционального механизма по созданию связей между полями таблиц, среди которых реализована связь «многие-ко-многим» с возможностью создания таблицы связей;
  • функция Reverse Engineering позволяет восстанавливать структуру таблиц и связей из той, которая была реализована ранее и хранится на сервере БД;
  • наличие редактора SQL-запросов, который дает возможность при отправке на сервер получать ответ в табличном виде и другие возможности.
2. Navicat

Второе место занимает Navicat (разработка компании PremiumSoft CyberTech Ltd) — инструмент для разработки и администрирования баз данных, который работает на любом сервере MySQL, начиная с версии 3.21. Для MySQL, Navicat доступен для работы на платформах Microsoft Windows, Mac OS X и Linux.

Подробнее о Navicat вы можете узнать здесь www.navicat.com/en/products/navicat_mysql/mysql_overview.html

Стоимость продукта варьируется от 199 до 379 долл. США.

Что делает Navicat популярным?

  • наличие визуального конструктора запросов;
  • возможность импорта, экспорта и резервного копирования данных;
  • возможность создавать отчеты;
  • SSH и HTTP туннелинг;
  • миграция и синхронизация данных и структуры;
  • инструмент для планирования задач и другие возможности.
3. PHPMyAdmin

PHPMyAdmin — бесплатное приложение с открытым кодом, предназначенное для администрирования СУБД MySQL. PHPMyAdmin представляет собой веб-интерфейс с помощью которого можно администрировать сервер MySQL, запускать команды и просматривать содержимое таблиц и БД через браузер.

Скачать PHPMyAdmin можно здесь www.phpmyadmin.net/home_page

Стоимость — бесплатно.

Что делает PHPMyAdmin популярным?

  • возможность управлять СУБД MySQL без непосредственного ввода SQL команд;
  • как панель управления PHPMyAdmin предоставляет возможность администрирования выделенных БД;
  • интенсивное развитие;
  • возможность интегрировать PHPMyAdmin в собственные разработки благодаря лицензии GNU General Public License и другие возможности.
4. dbForge Studio for MySQL

dbForge Studio for MySQL — инструмент, представляющий интерес как для пользователей MySQL, так и для разработчиков БД. С его помощью вы сумеете легко автоматизировать рутинную работу и сэкономить время. Сегодня dbForge Studio for MySQL представлен в трех редакциях: Express, Standard и Professional, что позволяет выбрать тот инструмент, который нужен именно вам. Пользоваться dbForge Studio for MySQL можно как коммерческой, так и бесплатной версией.

Ознакомиться с возможностями dbForge Studio for MySQL вы можете здесь www.devart.com/ru/dbforge/mysql/studio

Существует как бесплатная, так и платная версии, цена последней составляет 49,95 долл. США (стандартное издание ) и 99,99 долл. США (профессиональное издание).

Что делает dbForge Studio популярным?

  • наличие средств для централизованного администрирования;
  • инструменты для сравнения БД;
  • визуальный профилировщик запросов;
  • возможность управлять привилегиями пользователей;
  • наличие Дизайнера БД, который позволяет строить визуальные диаграммы;
  • улучшенная работа с проектами БД и другие возможности.
5. HeidiSQL

HeidiSQL — бесплатный инструмент для управления базами данных. Достойная альтернатива PHPMyAdmin, которая позволяет создавать и редактировать таблицы, представления, триггеры, процедура, а также просматривать и редактировать данные. Также HeidiSQL предоставляет возможность экспорта данных как в SQL файл, так и в буфер обмена на других серверах.

Скачать HeidiSQL можно здесь Сайт: www.heidisql.com

Стоимость — бесплатно.

Что делает HeidiSQL популярным?

  • возможность подключаться к серверу с помощью командной строки;
  • возможность пакетной оптимизации и восстановления таблиц;
  • возможность редактирования столбцов, индексов и внешних ключей таблиц, редактирование тела и параметров SQL процедур, триггеров и др.;
  • простое форматирование неупорядоченных SQL;
  • синхронизация таблицы между разными базами данных и другие возможности.
6. SQL Maestro для MySQL

SQL Maestro для MySQL — инструмент для администрирования, разработки и управления наиболее востребованных СУБД. Удобный графический интерфейс дает возможность выполнять SQL запросы и скрипты, управлять привилегиями пользователей, экспортировать и создавать резервные копии данных.

Ознакомиться с возможностями и купить SQL Maestro для MySQL можно здесь www.sqlmaestro.com/products/mysql

В зависимости от выбранной лицензии и варианта использования, стоимость данного инструмента варьируется от 99 до 1949 долл. США.

Что делает SQL Maestro для MySQL популярным?

  • поддержка версий MySQL сервера с версии 3.23;
  • наличие конструктора баз данных;
  • возможность редактирование, группировки, сортировки и фильтрации данных;
  • визуальный конструктор запросов;
  • SSH и HTTP туннелинг;
  • BLOB-редактор и другие возможности.
7. EMS SQL Manager для MySQL

EMS SQL Manager для MySQL — инструмент для разработки и администрирования баз данных, который поддерживает различные функции MySQL и работает со всеми версиями MySQL старше 3.23. С его помощью у вас есть возможность визуально редактировать, импортировать и экспортировать БД, выполнять сценарии SQL, управлять привилегиями пользователей, визуально проектировать базы данных MySQL.

Подробнее ознакомиться и приобрести EMS SQL Manager для MySQL можно здесь www.sqlmanager.net./ru/products/studio/mysql

Существует платная и бесплатная версии приложения. Последняя имеет ряд функциональных ограничений. Стоимость платной версии варьируется в пределах 95 – 245 долл. США.

Что делает EMS SQL Manager for MySQLпопулярным?

  • поддержка данных UTF8;
  • простое управление различными объектами MySQL;
  • совместимость со всеми версиями с 3.23 по 6.0 включительно;
  • наличие графических и текстовых инструментов для формирования запросов;
  • SSH и HTTP туннелинг;
  • удобный конструктор отчетов и другие возможности.
8. SQLyog

SQLyog — один из наиболее мощных инструментов, который сочетает в себе возможности MySQL Administrator, PHPMyAdmin и некоторые другие инструменты для администрирования и разработки баз данных. SQLyog работает на платформах Microsoft Windows, Windows NT. и Linux с помощью Wine.

Подробнее ознакомиться и приобрести SQLyog можно здесь www.webyog.com/en/index.php

Доступна как бесплатная, так и платная версия SQLyog. Стоимость платной версии — от 99 до 1499 долл. США (варьируется в зависимости от количества пользователей и лицензии, с поддержкой или без нее).

Что делает SQLyog популярным?

  • удобный конструктор запросов;
  • возможность синхронизации данных;
  • поддержка юникода;
  • SSH и HTTP, HTTPS туннелинг;
  • «умное» автозавершение работы;
  • интеллектуальное дополнение кода и другие возможности.
9. DBTools Manager

DBTools Manager — приложение для управления данными, с встроенной поддержкой MySQL, PostgreSQL, MSAccess, MSSQL Server, Oracle и других БД. Поддерживаемые платформы: Windows 2000, XP, Vista, 7.

DBTools Manager представлен в бесплатном (Standard) и платном варианте (Enterprise). Стоимость составляет 69.90 долл. США за одну лицензию, при покупке нескольких лицензий предусмотрены скидки.

Подробнее ознакомиться и приобрести DBTools Manager можно здесь www.dbtools.com.br/EN/dbmanagerpro

Что делает DBTools Manager популярным?

  • управление базами данных, таблицами;
  • наличие редактора запросов;
  • наличие мастера создания форм и отчетов;
  • возможность импорта и экспорта данных из различных источников, среди которых MSAccess, MSExcel, Paradox, FoxPro, DBF, ODBC таблицы, текстовые и XML файлы;
  • конструктор диаграмм и другие возможности.
10. MyDB Studio

MyDB Studio — бесплатный инструмент для администрирования БД MySQL, который позволяет создавать, редактировать и удалять записи, таблицы и базы данных. Работает исключительно на платформе Windows.

Скачать MyDB Studio можно здесь www.mydb-studio.com

Стоимость — бесплатно.

Что делает MyDB Studio популярным?

  • возможность подключаться к неограниченному количеству баз данных;
  • возможность подключения по SSH каналам;
  • создание откатов и экспорт БД в различные форматы;
  • возможность переноса, резервного копирования, также восстановления БД и другие возможности.

habrahabr.ru

Первое знакомство с программой dbForge Studio. -

Существует чрезвычайно полезная, бесплатная для не коммерческого использования программа работы с базами данных. Она имеет очень богатый функционал, такой как: дизайн баз данных, администрирование, миграция данных и анализ, далее мы подробней рассмотрим все пункты подробней. Скачать программу можно на сайте разработчика:  http://www.devart.com/ru/dbforge/mysql/studio/. Универсальный инструмент dbForge Studio создан для работы с сервером MySQL, который позволяет администраторам БД, разработчикам MySQL: создавать, разрабатывать и отлаживать процедуры, функции, запросы. Также позволяет автоматизировать управление БД MySQL в интуитивно понятном пользовательском интерфейсе.

В панели быстрого запуска,на вкладке «SQL разработка» можно выполнить: визуальное создание запросов на диаграмме  используя редактор выражений, заниматься отладкой, запускать и выполнять скрипты.

На вкладке «Дизайн базы данных» можно: создать диаграмму базы данных, сравнить данные и схемы базы данных, производить поиск в объектах баз данных либо в таблицах.

На вкладке «Администрирование» можно настроить права к базе данных, посмотреть текущие сессии подключения к базе данных, сделать резервную копию либо восстановиться с резервной копии базы данных, сделать сброс данных, оптимизировать — проверить — восстановить таблицы.

На вкладке «Миграция данных» можно легко экспортировать и импортировать  данные с базы данных в нужный формат файла, сравнить две базы данных, сделать резервную копию.

Во вкладке «Анализ данных» можно создать так называемый проект поиска данных, создать проект сравнения и синхронизации, наглядно посмотреть связи таблиц. сделать отчет.

Чтобы начать работу в программе dbForge Studio необходимо создать подключение к базе данных. В свойствах соединения базы данных необходимо указать хост: ip адрес либо имя сервера БД, порт: по умолчанию mysql использует порт 3306, также имя и пароль доступа к базе данных. При правильном указании параметров и нажатии на выборку «База данных», программа выведет список доступных для подключения баз, данные параметры подключения можно сохранить.

Можно устанавливать множество подключений к различным серверам БД и при работе быстро переключаться между базами.

Здесь показан пример просмотра связанных таблиц в программе dbForge Studio.

 

 

Вконтакте

Одноклассники

Мой мир

Facebook

E-mail

www.itworkroom.com

Работа с MySQL с помощью dbForge Studio

Более 20 тыс. вакансий, открытых для ИТ-специалистов в последнем квартале 2012 г., требуют от кандидатов знания языка запросов SQL.

Знание SQL - наиболее распространенное требование к ИТ-специалистам, несмотря на то, что в 4 квартале 2012 г. потребность в специалистах по базам данных снизилась на 1,4 % по сравнению с 3 кварталом 2012 г. Тем не менее, в 20660 вакансиях в числе требований к навыкам сотрудника указано знание SQL.

Британская рекрутинговая компания CW Jobs

Проектировать базу данных можно с помощью SQL-команд, используя непосредственно инструменты MySQL, но этот вариант является достаточно кропотливым и трудоемким, потому существует достаточно много программных продуктов, значительно облегчающих эту непростую работу.

Одним из таких гибких профессиональных инструментов для разработчиков и пользователей MySQL является программа dbForge Studio for SQL от компании Devart. С ее помощью автоматизируются рутинные задачи разработки и администрирования MySQL: проектирование базы данных, ввод и редактирование данных таблиц, создание и выполнение SQL-скриптов, запросов и триггеров и др. Программа является бесплатной для частного некоммерческого использования и для учебных заведений.

Программа имеет русскую локализацию, однако ее справочное пособие (кстати, довольно неплохое) имеется только на английском языке. Как-то на форуме программы я вычитал объяснение разработчиков программы по поводу отсутствия русской версии справки. Суть его такова: мы и так предоставляем возможность бесплатного использования программы, так что требовать от нас еще и локализации (и поддержки) справки, мягко говоря, не корректно, что, на мой взгляд, полностью справедливо. С другой стороны, неплохо бы иметь какое-то представление о продукте именно на русском языке, тем более литературы по ней я не встречал (хотя, допускаю, где-то она и есть). Поэтому надеюсь, что данная статья поможет кому-то разобраться с данным, достаточно неплохим программным продуктом.

В статье рассматривается последняя на момент написания версия программы 6.0.265.

Интерфейс программы

Основное окно программы поделено на несколько областей (панелей):

  1. Проводник баз данных. Структурированный в виде дерева перечень объектов баз данных, объединенных в функциональные группы.
  2. Свойства. Отображает свойства выбранного объекта.
  3. Главное окно. Рабочее окно, в котором осуществляются все действия с базой данных.
  4. Проект.
  5. Окно вывода. Вывод сообщений системы.

Отмечу, что информация панелей не всегда автоматически обновляется. Поэтому, если вы не наблюдаете произведенных изменений, то попробуйте на панели проводника программы вызывать контекстное меню на имени соединения и выбрать из него пункт "Обновить" либо нажать функциональную клавишу <F5>, либо на панели инструментов окна проводника щелкнуть кнопку "Обновить информацию схемы".

Подключение к серверу MySQL

После загрузки программы следует соединиться с сервером. Если это делается впервые, то на панели инструментов окна проводника необходимо щелкнуть кнопку "Новое соединение", после чего появится окно "Свойства соединения базы данных", в котором указываются параметры соединения с сервером:

  1. IP -адрес хоста, на котором расположена база данных.
  2. Порт (по умолчанию "3306").
  3. Имя пользователя.
  4. Его пароль.
  5. Можно также указать базу данных, с которой автоматически будет осуществляться работа после установки соединения.

Для проверки правильности введенных параметров щелкните кнопку "Проверить". При успешном соединении с сервером последует сообщение: "Соединение установлено".

После успешного подключения к серверу на панели проводника программы появится перечень баз данных на сервере, причем на корневом уровне находится название соединения. Одновременно в окне вывода появляется сообщение об установке соединения с сервером.

При следующих загрузках dbForge Studio for SQL создавать новое соединение не нужно, просто необходимо возобновить соединение с сервером. Это можно сделать разными способами, например, вызывать контекстное меню на имени соединения на панели проводника программы и выбрать из него пункт "Открыть (соединение)" или просто дважды щелкнуть на имени соединения.

Создание базы данных

  1. Для создания новой базы данных следует выполнить команду База данных > Новая база данных..., после чего появится окно "Создать новую базу данных".
  2. В поле "Название" вводится произвольное имя.
  3. В списке "Кодировка" задается кодировка данных. Естественно, при работе с кириллицей следует выбрать русскую кодировку для Windows "cp 1251".
  4. В списке "Сопоставление" задается правило для работы с данными таблиц. Например, для работы с данными на русском языке выбирается набор для "cp 1251_general_ci". Вместе с тем, сопоставление позволяет "детализировать" выбранную кодировку, выбрав, например, правила для болгарского или украинского языка.

Отвлекусь немного в сторону от основной темы. Настройки (по умолчанию) в окне не случайны, они определяются при конфигурировании MySQL. Именно там, если вы планируете работать с данными на русском языке, следует задать такую установку:

character-set-server=cp1251

После создания новой базы данных в dbForge Studio for SQL ее название должно отобразиться в окне проводника.

Свойства базы данных, в частности набор символов для работы с базой данных и набор правил для работы отображаются на панели свойств при установке курсора на имени базы данных в окне проводника.

Работа с таблицами

Доступ к таблицами базы данных осуществляются в узле "Таблицы" соответствующей базы данных панели "Проводник".

Создание таблицы

Создание новой таблицы осуществляется так:

  1. Раскрываем узел с именем нужной базы данных (раскрытие и свертка узла осуществляются также, как и в "обычном" проводнике Windows, то есть щелчком на символе "+" либо "-" перед названием базы данных.
  2. Вызывать контекстное меню на пункте "Таблицы" и выбрать из него пункт "Новая таблица".
  3. В рабочем окне появится окно-вкладка таблицы, которая в свою очередь содержит несколько вкладок. На вкладке "Общие" задаются общие атрибуты таблицы: ее имя, тип данных, здесь же можно при необходимости изменить базу данных, для которой создается таблица. Тип данных таблицы, опять же, устанавливается автоматически соответственно настройкам MySQL.
  4. На той же вкладке "Общие" вводятся данные о структуре таблицы, то есть. обо всех ее полях. Новое поле создается автоматически, его также можно добавить "явно", выполнив команду Таблица > Новый столбец. Вообще, пункт главного меню программы Таблица предназначен именно для работы с таблицей, в том числе он содержит действия, позволяющие изменять структуру таблицы: добавлять, удалять, вставлять, редактировать поля таблицы.

Ключевые свойства полей:

  • Первичный ключ. Определение поля ключевым.
  • Пустые значения. Разрешение или запрет наличия пустых значений в поле.
  • Без знака. Запрет ввода отрицательных чисел в поле.
  • Бинарный. Задание этого свойства определяет, что значения в этом поле будут чувствительными к регистру.
  • Автоинкремент. Автоматический прирост на "1" значения в поле при добавлении новой записи. Применяется для полей целого типа данных (INT).

Для сохранения структуры таблицы следует выполнить команду Файл > Сохранить или щелкнуть соответствующую пиктограмму на панели стандартных инструментов программы.

Под структурой таблицы расположено окно "SQL", в котором отображается команда SQL, автоматически генерируемая программой во время создания таблицы по введенным нами данным. Замечу, что текст SQL-команды не редактируется.

Дальнейшее обращение к таблице осуществляется путем двойного щелчка на ее имени в проводнике, после чего ее структура отображается в главном окне.

Изменение структуры таблицы (состав полей или их свойств) осуществляется также на вкладке "Общие".

Сводные данные о таблице можно отобразить на панели свойств двойным щелчком на названии таблицы на панели проводника.

Ввод данных

Для ввода данных следует выбрать в проводнике нужную таблицу, а в окне-вкладке с таблицей перейти на вкладку "Данные".

Новая строка (запись) добавляется автоматически при нажатии функциональной клавиши <вниз> при установленном на последней записи курсоре. Переход от поля к полю осуществляется клавишами навигации, <Enter> или <Tab>. Если данные визуально не полностью отображаются в поле, его можно увеличить, перетянув его правую границу или дважды нажав на ней в строке с заголовками полей.

Перемещение по данным таблицы осуществляется с помощью клавиш навигации. Нижняя часть окна с таблицей содержит также панель навигации, которой удобно пользоваться при перемещении по таблице с большим количеством записей.

Отмечу, что после ввода в таблицу данных их нужно сохранить, то есть, выполнить команду Файл > Сохранить или щелкнуть соответствующую пиктограмму на панели стандартных инструментов программы. Впрочем, если Вы и забудете об этом, то программа сама напомнит Вам о наличии несохраненных данных при окончании сеанса работы с нею.

Работа с запросами

Построение запроса

  1. Выполнить команду Файл > Создать > Запрос или на панели стандартных инструментов программы щелкнуть кнопку создания нового запроса , после чего в главном окне появится вкладка "Запрос.sql".
  2. Перетянуть из окна проводника на вкладку "Запрос.sql" таблицы, из которых нужно отобрать информацию.
  3. Сформировать параметры запроса, о чем речь пойдет ниже.
  4. При необходимости в колонке "Псевдоним" ввести содержательное название для поля. В этом случае именно оно будет отображаться в выводе (в противном случае отображается название поля).
  5. Сохранить запрос, выполнив команду Файл > Сохранить запрос.sql или щелкнув соответствующую пиктограмму на панели инструментов. Появится окно "Сохранить файл как", в котором следует указать имя запроса, которое может быть и на русском языке. Файл запроса имеет расширение SQL.

Создание запроса на выборку

Самым простым типом запроса является запрос на выборку. Отображение и формирование перечня полей, включаемых в выборку, осуществляется на вкладке "Выборка". Для включения в запрос значений поля достаточно установить флажок для поля-метки с названием поля в области окна, отображающего структуру выбранных таблиц. Другой вариант формирования запроса заключается в выборе полей из раскрывающегося списка в колонке "Столбец". Так в запрос добавляются составные выражения, содержащие, например, функции или представляющие собой выражение из нескольких полей.

Результаты запроса будут отображаться именно в том порядке, как они расположены в колонке "Столбец". Если возникает необходимость отображать определенную информацию только один раз, то нужно установить флажок для поля-метки "Уникальные строки". Для просмотра результатов запроса еще во время его формирования (без запоминания) нужно щелкнуть кнопку "Выполнить".

Отбор по критерию

Наложение условия на значения поля или нескольких полей осуществляется на вкладке "Условия".

Для добавления условия следует щелкнуть кнопку . Это приведет к появлению текста, который дважды содержит фразу "Введите значение", разделенную знаком "=".

  1. Первый текст "Введите значение" является левой частью условия. Это - поле (название столбца) какой-то таблицы.
  2. Знак "=" является оператором условия. Его можно заменить на другой. Для этого следует щелкнуть на нем и выбрать из появившегося списка нечто иное, например, ">".
  3. Текст "Введите значение" справа от знака "=" является значением условия. Щелчок на тексте "Введите значение" приводит к отображению списка полей таблиц, различных выражений и пр., что можно представить как условие.

Например, для отбора студентов, имеющих оценку "5", условие может быть записано как "Оценка"=5.

Условий может быть несколько. Для добавления нового условия также необходимо щелкнуть кнопку и сформировать по вышеприведенным правилам новое условие.

По умолчанию между собой условия соединяются логическим оператором AND, однако и его можно изменить, щелкнув на нем и выбрав из списка другой.

Создание связей (объединение таблиц)

В базе данных MySQL нельзя одноразово жестко зафиксировать связи между таблицами. Пользователь в каждом запросе должен создавать их с помощью SELECT и JOIN. Программа позволяет создавать пять видов связей, в том числе внутреннюю, левостороннее и правостороннее объединение.

Объединение двух таблиц осуществляется путем объединения мышкой нужных полей таблиц. Созданная связь отображается графически. Те же действия можно произвести и на вкладке "Соединения". Для этого нужно щелкнуть кнопку , после чего появится пустой оператор JOIN. Щелкаем на тексте "Укажите имя столбца" и добавляем к соответствующим полям поля объединяемых таблиц.

Код команды SELECT, отображающий создание связей, также отображается на вкладке "Соединения".

Для изменения типа связи следует вызывать контекстное меню на типе (названии) соединения, например, "Inner Join" и выбрать из него нужный.

Удалить связь можно разными способами, например, вызывав контекстное меню на графической линии связи и выбрав из него пункт "Удалить из диаграммы".

Вычислительные поля

Достаточно часто вывод результатов запроса должен содержать не просто значения одного из полей таблицы, а комбинацию значений полей из одной или нескольких таблиц или математическую операцию над ними. Например, в запросе следует подсчитать общую стоимость товара, которая определяется как произведение общего количества товара и цены за единицу товара. Для этого следует создать вычислительное поле. Например, создание произведения полей "Цена" и "Количество" осуществляется так.

  1. Перейти на вкладку "Выборка".
  2. Щелкнуть на свободной строке в поле "Столбец".
  3. Выбрать поле "Цена".
  4. В нижней части окна выбора щелкнуть пиктограмму оператора "*".
  5. Из соответствующей таблицы выбрать поле "Количество", после чего в поле "Столбец" появится выражение наподобие Цена*Количество.
  6. Для создания содержательной подписи для вычислительного поля следует в поле "Псевдоним" заменить выражение "Exp" на "Всего".

Упорядочивание (сортировка) записей

Если необходимо упорядочить отобранные данные по определенному полю, то применяют, как известно, сортировку. Определение полей сортировки осуществляется на вкладке "Сортировка". Здесь список "Столбцы" содержит перечень всех полей, включенных в запрос. Двойной щелчок на любом из них или щелчок кнопки "Добавить столбец" приводит к переносу этого поля в список "Сортировка", который и определяет сортировочные поля и порядок упорядочивания записей. По умолчанию применяется метод сортировки "по возрастанию", но его очень просто изменить на "по убыванию", щелкнув кнопку "Сортировать по..." .

Количество полей сортировки не ограничивается, что позволяет осуществить многоуровневую сортировку результатов вывода, упорядочив его сразу по нескольким полями. В этом случае поля, для которых осуществляется сортировка, следует расположить в списке в именно том порядке, в котором она будет осуществляться.

Группировка записей и агрегатные функции

Действие группировки дает возможность объединить одинаковые по какому-то признаку записи таблицы для определенного поля в группы и применять к ним вычисления с помощью разных функций.

Группировка записей задается на вкладке "Группировка".

Добавление функции для поля осуществляется на вкладке "Выборка" так:

  1. Щелкнуть кнопку нового поля в колонке "Столбец".
  2. В списке "Функция" выбрать нужную функцию, после чего ее имя появится в колонке "Столбец".
  3. В качестве аргумента функции выбирается нужное поле из списка "Таблица".

Напомню, что к агрегатным функциям относятся следующие:

  • функция Sum предоставляет возможность подсчитать для группы записей сумму;
  • функция Avg - вычислить среднее значение;
  • Count - подсчитать общее количество записей;
  • Max и Min - определить максимальное и минимальное значение в поле.

Так, если осуществить группировку студентов по их фамилии, номеру зачетной книжки и т.п., то в таблице, которая содержит данные с оценками студентов с помощью функции Sum можно подсчитать общую сумму оценок для каждого студента, а с помощью функции Avg - вычислить его средний балл.

Использование агрегатных функций в условиях

В условиях во фразе HAVING можно использовать агрегатные функции, которые действуют в пределах создаваемых групп. Это осуществляется на вкладке "Включение".

Например, для отбора оценок студентов группы, которые имеют оценки выше среднего балла, можно применить два варианта:

Оценка > AVG(Оценка)

Оценка - AVG(Оценка) > 0

Одновременно на вкладке "Группировка" должна быть задана группировка по студентам.

Выполнение запроса

Для выполнения запроса следует сначала его открыть. С этой целью следует щелкнуть кнопку "Открыть" на панели стандартных инструментов программы. Для выполнения запроса щелкните кнопку на панели запросов.

Формирование триггеров

Как известно, триггер - это процедура (последовательность SQL-операторов), которая активируется во время выполнения операций манипулирования данными (добавление, замена и удаление) над таблицами. Триггеры являются одним из механизмов поддержки целостности базы данных.

Программа dbForge Studio for SQL представляет автоматизированные средства создания триггеров.

Создания триггера осуществляется по такому алгоритму:

  1. На панели проводника вызывать контекстное меню для пункта "Триггеры" и выбрать из него пункт "Новый триггер". Появится окно формирования триггера.
  2. На вкладке "Общие" определяются общие реквизиты триггера: имя, владелец и таблица, в качестве которых выступают соответственно база данных и таблица, для которых создается триггер.
  3. В поле "Тело триггера" на той же вкладке разработчиком самостоятельно формируется последовательность операторов, которые будут выполняться во время выполнения операции манипулирования данными. Они располагаются между операторами BEGIN и END.
  4. На вкладке "Событие" определяется, для какой операции манипулирования данными предназначен триггер, а также момент его срабатывания: до или после события.

На вкладке "SQL" отображается автоматически сформированный системой скрипт для триггера.

Резервное копирование / восстановление

При работе с компьютером всегда необходимо помнить о возможности аварийных ситуаций: отключение электричества, выхода из строя устройств и т.п. Если база данных содержит значительный объем информации, то потеря или разрушение данных может быть воспринято как "конец света". Поэтому первое правило при работе с любой системой - это наличие резервной копии данных, что позволяет при необходимости восстановить данные. Копия также может быть полезной и при необходимости возврата к предыдущим данным.

Создание резервной копии осуществляется командой База данных > Резервная копия > Создать резервную копию БД. Архив создается с расширением SQL, при этом его имя содержит имя базы данных, для которой он создается и время его создания, например: "предприятие 20101117 1559".

Для восстановления базы данных желательно ее наличие на сервере. Впрочем, ее можно создать и автоматически в процессе восстановления. После этого следует вызывать контекстное меню на названии базы данных и последовательно выбрать из него пункты Резервная копия, Восстановить БД из резервной копии.

Действия по созданию и возобновлению резервной копии осуществляются под управлением программы-мастера и сложностей не вызывают. Единственно, замечу, что при создании резервной копии обращайте внимание на то, чтобы в поле "База данных" была выбрана нужная база данных.

И еще одно замечание. Следует иметь в виду, что если база данных переносится с компьютера на компьютер, то такие объекты, как таблицы со всем их содержимым и триггеры будут восстановлены корректно и без проблем. А вот для каждого запроса при первом его запуске на другом компьютере нужно будет давать подтверждение про перенос его на новый сервер.

И последнее.

При работе с dbForge Studio for SQL пользователи частенько отмечают наличие в ней багов. По этому поводу хотелось бы отметить следующее: во-первых, сама задача, поставленная перед собою разработчиками программы, а именно - автоматическая генерация SQL-команд при визуальном проектировании базы данных является достаточно сложной для реализации (несмотря на формальность алгоритмов генерации), во-вторых, сами баги постоянно исправляются, а, в-третьих, программа-то бесплатна, а даренному коню, как известно, в зубы не смотрят...

И самое последнее. Я предварил статью выдержкой из британской рекрутинговой компании CW Jobs, в которой отмечалось высокая потребность в IT-специалистах, знающих язык SQL. Из статьи следует, что программа автоматически генерирует SQL-команды по введенным данным, а это позволит начинающим разработчикам отслеживать корректный код, необходимый для создания объектов базы данных.

Валерий ФЕТИСОВ

www.kv.by

О Devart: краткая информация о компании

Релиз ODAC 1.0

Oracle Data Access Components - первый продукт в линейке компонентов доступа к данным и первый продукт, созданный Devart.

Создание линейки dotConnect провайдеров

dotConnect for MySQL и dotConnect for Oracle были первыми продуктами в известной линейке ADO.NET провайдеров.

Поддержка dbExpress технологии

dbExpress драйвер для Oracle был нашим первым шагом на пути к созданию решений для быстрого доступа к основным серверам баз данных.

Создание линеек инструментов dbForge для MySQL и Oracle

Были выпущены самостоятельные инструменты для работы с серверами Oracle и MySQL, а также расширения для Visual Studio и Delphi.

Поддержка Entity Framework

Мы поддержали эту инновационную технологию в dotConnect for Oracle.

Создание линейки инструментов dbForge для SQL Server

Мы создали инструменты для сравнения схем и данных в базах SQL Server – dbForge Schema Compare for SQL Server и dbForge Data Compare for SQL Server.

Создание инструментов для разработчиков

Релиз инструмента Code Compare положил начало новому направлению разработки - мы стали создавать инструменты для работы с кодом.

Pелиз LinqConnect

Релиз быстрого и простого в использовании ORM-решения, совместимого с LINQ to SQL и предоставляющего доступ к базам данных SQL Server, Oracle, MySQL, PostgreSQL и SQLite для приложений на основе платформ .NET Framework, Metro, Silverlight, и Windows Phone.

Релиз dbForge SQL Complete

Плагин для Microsoft SQL Server Management Studio и Microsoft Visual Studio. Обладает мощными средствами автодополнения и форматирования T-SQL кода.

Релиз Review Assistant

Плагин для Visual Studio, который помогает анализировать код и является удобным инструментом для ведения диалога с привязкой к блокам кода. Инструмент поддерживает интеграцию с наиболее популярными системами контроля версий.

Бесплатный онлайн инструмент форматирования кода

Моментальное форматирование SQL кода с помощью dbForge SQL Complete.

Релиз Fusion for SQL Server

Плагин для Visual Studio, который поможет вам упростить разработку и расширить возможности управления базами данных SQL.

Oracle Silver Partner

Получив статус Silver Partner, Devart приобрел возможность работать с инструментами, ресурсами и экспертами OPN портала в Oracle Partner Business Center, что позволит нашей команде подробнее изучить Oracle Server и усовершенствовать навыки работы с ним.

Cтатус партнера Microsoft с компетенцией Silver Application Development!

Компетенция Silver отражает приверженность компании «Devart» высокому качеству продуктов и услуг, а также профессионализм наших разработчиков, компетентность которых была подтверждена путем тщательного тестирования, увенчавшегося получением сертификации Microsoft.

Запуск Skyvia

Компания Devart запускает облачное решение для интеграции, резервного копирования облачных данных и управления данными при помощи SQL запросов — Skyvia.

Запуск линейки надстроек для Microsoft Excel

Компания Devart запускает линейку надстроек для Microsoft Excel для работы с внешними данными из облачных приложений и баз данных.

Запуск линейки ODBC драйверов

Компания Devart запускает линейку ODBC драйверов, обеспечивающих приложения на основе ODBC прямым доступом к наиболее популярным базам данных из различных платформ.

Релиз dbForge Data Generator for SQL Server

Мощный инструмент для генерации больших объемов тестовых данных.

Релиз dbForge Event Profiler for SQL Server

Бесплатный инструмент для мониторинга и анализа событий SQL Server.

Релиз dbForge Data Generator for MySQL

Эффективный инструмент для генерации больших массивов тестовых данных.

Запуск линейки SSIS DataFlow компонентов

Компания Devart запускает линейку SSIS DataFlow компонентов, включающую SSIS компоненты Source, Lookup, и Destination для баз данных и облачных приложений.

Запуск линейки плагинов для SSMS

Компания Devart запускает линейку плагинов для SSMS, которые разработаны для упрощения разработки баз данных, а также для улучшения возможностей управления данными.

Запуск линейки ODBC драйверов для облачных приложений

Компания Devart запускает линейку ODBC драйверов, которые предоставляют прямой доступ к следующим облачным сервисам: Salesforce, Salesforce MC, Dynamics CRM, SugarCRM, Zoho CRM, QuickBooks, FreshBooks, MailChimp, BigCommerce, Magento, NetSuite.

Релиз TMetric

Выходит первая версия облачного сервиса для учета рабочего времени.

Релиз dbForge Data Generator for Oracle

Выходит первая версия инструмента для генерации больших объемов данных Oracle.

www.devart.com

dbForge Studio for SQL Server History

5.5.311 13-Oct-17

User reported bug fixes

  • Known data import issues are fixed (T233402, T233763, T233872, T234419)
  • Copy-Paste from Excel issue for Data Editor is fixed (T230734)
  • Check for update issue in Express edition is fixed (T216853)
  • Other user reported bugs are fixed (T232233, T232259, T231703)
5.5.279 13-Sep-17

User reported bug fixes

  • Issues with random application crash reported by some users are fixed (T205713, T211526, T212740, T214078, T216866, T198231, T219097, T219548, T220110, T221342, T216853, T221516, T227369, T228141, T229704)
  • Object Editors issues are fixed (T230078, T231019, T229805,T229124,T231638, T231887, T229595, T229704, T228665, T228504, T230499, T231020, T231792, T227934)
  • Skin issues are fixed (T228171, T228519, T228622, T229229, T229296, T228071, T228065, T228806)
  • Code Completion issues are fixed (T230164, T228164, T230695)
  • Data Editor and Viewer issues are fixes (T229714, T228704, T229393)
  • Data Export\Import issues are fixed (T230213, T218898)
  • Documenter issues are fixed (T231460, T229061, T228416)
  • Object Editors issues are fixed (T230078, T231019, T229805, T229124,T231638, T231887, T229595, T229704, T228665, T228504, T230499, T231020, T231792, T227934)
  • Schema Compare issues are fixed (T229012, T228567)
  • Script Generator issues are fixed (T228598, T228496)
  • SQL Document issues are fixed (T231337, T228073, T228427, T228973, T213935, T177249, T181353, T183867, T187059, T228896)
  • Other user reported bugs are fixed (T228495, T231133, T231611, T231496)
5.5.196 03-Aug-17

SQL Server support

  • SQL Server 2016 Service Pack 1 (SP1) new syntax support
  • SQL Server 2017 CTP2 new syntax support
  • Azure SQL Data Warehouse connectivity support

Code Completion

  • Column match highlighting in the INSERT statement
  • Database element dropping from the prompt in Completion List
  • Possibility to exclude a scheme in the ON condition of the JOIN statement
  • Possibility to connect/disconnect when describing/pre-describing objects of the same database
  • Query navigation
  • CASE END pairs highlighting
  • Extended suggestion in the PIVOT/UNPIVOT queries
  • Extended support for CTE
  • Prompt and QI of variables in named transactions
  • CREATE OR ALTER statement support
  • Support of the following statements:
    • DROP RULE
    • ALTER SERVICE
    • ALTER QUEUE
    • DROP SERVICE
    • DROP CONTRACT
    • ALTER EXTERNAL RESOURCE POOL
    • CREATE EXTERNAL TABLE AS SELECT
    • CREATE REMOTE TABLE AS SELECT
    • ALTER EXTERNAL DATA SOURCE
    • ALLOW_ENCRYPTED_VALUE_MODIFICATIONS at CREATE USER

SQL Document

  • New query execution history feature saves information about SQL statement you run

Data Compare

  • Static Data comparison in Script Folder
  • Support for MASKED columns
  • Option to automatically select a key for comparing objects without a suitable unique key
  • Added option to turn ON\OFF Generation of IF NOT EXISTS on inserting
  • Possibility to open the comparison wizard instead of the comparison autorun when opening the dcomp files

Schema Compare

  • Support for External Objects
  • Support for MASKED columns
  • Azure v.12 Extended Support
  • Support for SECURITY POLICY object
  • Support for Column Encryption Keys
  • Support for Column Master Keys
  • Extended support for comparison of SQL Server 2014-2016 backup files
  • New Database creation through Schema Comparison Master
  • Redesigned logging in command line
  • Possibility to open the comparison wizard instead of the comparison autorun when opening the scomp files

Documenter

  • Documenter tool now supports generation to Markdown format

Data Generator

  • Storing custom generators
  • Generating data by time
  • Generating data to existing tables already populated with data
  • Generating data using linked table
  • Pre and Post Script Execution

Source Control

  • Added authentication capability for VS Online
  • TFS 2017 support
  • SourceGear Vault v9.1 support
  • SourceGear Vault v10.0 support
  • Surround SCM support

Index Manager

  • The Command Prompt provides scan results of index analysis including index name, reason, and fragmentation

Connectivity

  • Each document uses its own connection
  • Password change on expiry
  • Keyboard shortcut for selecting connection and assigned database

Monitor

  • New tool to monitor SQL Server performance in the online mode
  • Possibility to monitor CPU and memory utilization
  • Data IO information
  • Displays information about waits, including its type, resource, a number of waits on this wait type, and more
  • Database metrics
  • Query profiling with top operations and plan in XML format
  • Information about active sessions and database backups

Other improvements

  • Command-Line Master which greatly simplifies command-line usage
  • Generate Script As redesigned
  • Express Edition extended with ability to manage table partition

User reported bug fixes

  • SQL Document and Code Completion issues are fixed (T212521, T217146, T221380, T222709, T219960, T226952, T222386, T213940, T199661)
  • Data Compare issues are fixed (T224823, T224823, T209269, T208150, 147588)
  • Data Editor and Viewer issues are fixed (T214008, T213028, T205958)
  • Data Export\Import issues are fixed (T226797, T218898, T213239, T211014, T206194)
  • Data Generator issues are fixed (T219021, T170551)
  • Documenter issues are fixed (T216527, T220436, T215062, T216226)
  • Issue with silent deployment is fixed (T220237)
  • Issue with duration column sorting in Event Profiler is fixed (T216076)
  • Other Event Profiler issues are fixed (T224298, T225426)
  • Database Diagram issues are fixed (T221788, T204480)
  • Database Explorer issues are fixed (T219962, T221151, T210297, T218283, T222082)
  • Schema Compare issues are fixed (T223850, T223945, T222900, T214774, T211201)
  • Source Control issues are fixed (T211201, T172965, T204839, T190431, T209045, T209085)
  • Syntax Check issues are fixed (T223151, T215949, T197334, T198481, T118226)
  • T-SQL Analyzer gives proper suggestions for TRUNCATE of table variables (T217114, T217113)
  • Object Search displays table name in which the column is found (T195564)
  • Other user reported bugs are fixed (T208833, T226549, T223847, T223920, T213935, T215396, T214560, T208354, T226553, T227176, T226082, T211436, T208792, T203501, T159851, T136506)
5.4.275 17-Mar-17
  • User reported issues with application launch for PRO edition are fixed (T211422, T211365, T211446, T211363)
  • Documenter issue with databases selection is fixed (T211485)
  • Index Manager issue with database names that contain a dot is fixed (T211440)
5.4.270 15-Mar-17
  • User reported issue with activation lost on midnight is fixed (T207634, T210225, T210589, T210570, T210567)
  • Schema Compare synchronization issue is fixed (T206405)
  • Data Compare NRE is fixed (T210444)
  • Documenter issue with generating report on specific database is fixed (T210158)
  • SQL Profiler issue is fixed (T208176)
5.4.257 03-Mar-17
  • Known activation issues are fixed
  • User reported issues with stored procedure edit are fixed (T177600, T186810, T207194, T206791, T208179, T208582)
  • Source control issues are fixed (T204643, T205417)
  • Documenter issue with 'CHAR' type is fixed (T207828)
  • SQL Profiler issue is fixed (T207608)
  • Query builder issue with 'collation=case' sensitive is fixed (T190330)
  • Script generator issue with timestamp field always generated upper-case is fixed (T208664)
  • 'WITH' statement issue in Data Editor and Viewer is fixed (T205258)
  • Mapping issue in Data Compare with 'BIT' type is fixed (T207184)
  • Other user reported issues are fixed (T208831, T204251, T202885)
5.4.215 10-Feb-17
  • Issues with SQL Server 2016 Express and temporal tables are fixed (T205271, T205283, T205332, T205416, T205619, T205854, T206193, T206345)
  • Issues with Excel import are fixed (T205904, T205294)
  • Azure Active Directory Authentication issue with dbo schema is fixed (T205260)
  • Source objects are modified using ALTER statement instead of DROP/CREATE now
  • Some issues with saving Schema Compare document in Pro edition are fixed (T20590, T205906)
  • Other user reported issues are fixed (T206037, T190330)
5.4.211 1-Feb-17
  • User reported issues with product activation are fixed (T205231)
5.4.209 31-Jan-17

Schema and Data Comparison

  • New comparison options
  • Comparison and synchronization of memory-optimized tables
  • Command-line interface for the scripts folder comparison
  • Extended comparison reports functionality
  • Support for SECURITY POLICY objects
  • Data comparison and synchronization of system-visioned tables

Query Profiler

  • Live query statistics
  • Wait Stats tab
  • Saving/Opening execution plan files
  • Table I/O
  • Highlighting potentially resource-intensive statements
  • Displaying clustered columnstore indexes in execution plan

Data Export/Import

  • Dramatically improved data import performance
  • Export/import of JSON data
  • Redesigned export/import of XML data
  • Preview of the generated UPDATE script in the wizard
  • Detection of column types when importing data from the Excel format
  • Execution of SET IDENTITY_INSERT ON when the Repopulate option is enabled during data import

Data Generator

  • Generation of country-specific data
  • The ISJSON function in Check Constraint generator
  • 10+ new generators, including ICD-10 Codes
  • Data generation for databases already filled with data
  • Improved DateTime generators

Source Control

  • Defining object file name format in Source Control and Scripts Folder creation
  • Creation of the script folder via the command-line interface

Data Viewer and Editor

  • Data Viewer and Editor features a new Geometry view, that helps to visulaize spatial geometry data

SQL Document

  • CTRL+W shortcut for closing current tab
  • Opening new tabs next to current one
  • CTRL+N shortcut for opening new SQL window with inherited server and database of the current window
  • Showing the connection coloring in the status bar

Code Completion

  • Support of the following statements:
    • BULK INSERT
    • ALTER APPLICATION ROLE
    • DROP APPLICATION ROLE
    • DROP DATABASE
    • DROP DEFAULT
    • DROP QUEUE
    • ALTER LOGIN, DROP LOGIN
    • CREATE APPLICATION ROLE
    • RECEIVE
    • DROP STATISTICS
    • CREATE FULLTEXT STOPLIST
    • CREATE DEFAULT
    • CREATE XML SCHEMA COLLECTION
  • Suggestion improvements:
    • Filegroups suggestion
    • System versioning
    • Transactions Suggestions
    • Stretch tables
    • Always encrypted
    • Dynamic data masking
    • Row-level security
  • Fully qualifying a table with the server name is supported
  • Suggestion of databases created in script is supported
  • Column suggestion for CTE is improved
  • JOIN synonym suggestion is implemented

Other Improvements

  • Support for Power Shell
  • Trial product activation
  • Greatly improved visual style of the application with high DPI support (T167078)
  • Specific exit codes are added (T179285)
  • Compliance with the Federal Information Processing Standard (FIPS) (T202683, T200652, T202683)
  • Connection to Microsoft Azure SQL Database by using identities in Azure Active Directory (T178327, T181021, T181011)

User reported bug fixes

  • Data Export\Import issues are fixed (T190439, T189279, T178258, T190648, T196941, T197426, T204476, T115423, T175888)
  • Data Editor and Viewer issues are fixed (T190439, T172102, T183426, T185281, T197463, T195972, T77205, T117784)
  • Data and Schema Compare issues are fixed (T186801, T181511)
  • Source Control issues are fixed (T172102, T177400)
  • SQL Document and Code Completion issues are fixed (T153278, T198273, T199012, T199912, T191374, T200841)
  • Documenter issues are fixed (T201750, 189300, T202830, T193233)
  • Object Editors issues are fixed (T199529, T188135, T182349)
  • Query Builder issue with case sensitive collation is fixed (T190330)
  • Other user reported bugs are fixed (T191375, T203304, T198944, T200583, T171987)
5.3.56 22-Sep-16

Enterprise Edition is extended with new Documenter for SQL Server tool

  • Obtain an overview of the database schema
  • Include self-documenting SQL objects
  • View inter-object and inter-database dependencies
  • Customize documentation styles
  • Generate documents in HTML and PDF files

Improved Data Generator

  • XML generator improved
  • Foreign Key generator improved
  • Check Constraint generator improved
  • 15+ new and improved meaningful generators

Data Editor and Viewer Window

  • XML View improved
  • JSON View added

Other improvements

  • Vault 9 is supported for Source Control (T178241)
  • Styled icons are used by default

User reported bug fixes

  • Code Completion issues are fixed (T185155, T180117, T177271, T184761, T185098, T184379, T177334, T177416, T178455, T179742, T179820, T179930, T179970, T180425, T181171, T184619, T184754, T185283)
  • ER when removing part of the SQL code is fixed (T181154, T181758, T181826, T184121, T184755)
  • SQL Formatter issues are fixed (T183452, T181719, T184667, T180134, T179811, T179371, T181156)
  • Syntax Check issues are fixed (T184373, T184290, T183512, T180123, T181621, T180247, T179121, T180247, T180568, T181811, T184884)
  • Database Diagram layout issues are fixed (T177122, T183120, T185937)
  • Object Editors issues are fixed (T177773, T184027, T182524, T183432, T182168, T182500, T182168, T182500, T179382, T179382, T172102)
  • Data Export\Import issues are fixed (T178233, T178258, T178344, T182347)
  • Other user reported bugs are fixed (T181941, T182741, T174109, T178473, T178238, T177717, T165386, T148503)
5.2.177 24-June-16

Final version released

5.2.125 beta 20-May-16

New version contains numerous improvements!

  • SQL Server 2016 support
  • Totally redesigned Database Search (objects and data)
  • Redesigned Visual Table Editor
  • Visual View Editor
  • tSQLt Framework updated to the latest version
  • Index Manager functionality is now available via command line

Improved SQL Completion

  • Objects suggestions in CROSS/OUTER APPLY statement
  • Suggestion of compound phrases
  • Greatly improved suggestion performance
  • Several new formatter options and profiles
  • Both objects and schemas suggestions in Completion List when writing cross-database queries are shown

Improved and enhanced Schema Comparison Tool

  • Many new comparision and synchronization options added
  • Enchanced backup support
  • Sequences support greatly improved
  • Improved security during synchronization process
  • Valid support of "WITH CHECK" and "WITH NOCHECK" constraints

Improved Source Control

  • Plastic SCM predefined template
  • Undo Local Changes
  • Support for version control command line client

Improved Data Generation

  • Updated RegExp and Python generators
  • JSON generator
  • Check Constraint generator
  • 15+ new meaningful generators

User reported bug fixes and improvements

  • Generate INSERT / UPDATE statements based on result grid have been added (T160960)
  • Generate Script As now supports selection of multiple objects (T165365)
  • Shortcut for Delete entire editor line (Ctrl + Y) has been added (T160960)
  • Generate WHERE IN () clause based on result grid has been added (T160960)
  • Popup menu for Copy Special in Data Editor has been added (T160960)
  • Display grid column types in Data Editor have been added (T160960)
  • Schema Compare and Sync Logging through the command line has been expanded
  • ArgumentNullException during creation SQL Document at the Studio start has been fixed (T161053)
  • The 'Index was outside the bounds of the array' error during schema comparison has been fixed (T159084)
  • IndexOutOfRangeException while comparing schemas of two databases has been fixed (T158788)
  • FileNotFoundException when restoring a database has been fixed (T158169, T161597)
  • Installation hangup has been fixed (T145722, T148482)
  • Bug with script generation for index creation has been fixed (T144431)
  • During schema sync, ALTER for scalar and table functions is generated if types in source and target coincide (T167604)
  • Option to save settings for "Object Filter" has been added (T163632)
  • Error with the database comparison parameters has been fixed (T163466)
  • InvalidCastException while comparing schemas of two snapshots has been fixed (T162316)
  • Bug with schema synchronization when ddl generation has been fixed (162173)
  • Ignore Semicolons option in schema comparison has been added (T160775)
  • NullReferenceException while comparing schemas has been fixed (157891)
  • Issue with integrated security when referencing an .SCOMP file during schema comparison has been fixed (T156509)
  • Schema Comparison Sync bug has been fixed (T159626)
  • Duplication of information in the Output window has been fixed (T167254)
  • IncludeIdenticalObjects option in the command line has been fixed (167846)
  • Outlining mode when editing a store procedure has been fixed (T163634)
5.1.178 18-Dec-15

Final version released with numerous improvements!

  • Data Generator updated to latest version
  • Schema comparison performance increased
  • TFS 2005, TFS 2008, TFS 2013 and TFS 2015 are now supported by Source Control
  • Installation Wizard redesigned

User reported bug fixes

  • Schema comparison mapping issues are fixed (T149758, T149718, T150099, T152184, T152702)
  • Performance issues are fixed (T142424, T146879)
  • Express edition issues are fixed (T149813, T149762, T150369, T150835, T150920, T150163, T151008, T151475, T154369)
  • Layout issues are fixed (T151053, T154476)
  • Data import issue is fixed (T151027)
  • Database Connection Properties form issues are fixed (T149712, T150269, T150241, T150835, T152614, T153484, T154154)
  • Data Editor and Viewer issues are fixed (T150741, T155092, T155642, T150088, T153835, T154305, T155329)
  • Snippets issues are fixed (T150855, T150982, T151172, T151861, T152219, T153128, T153756, T155212, T155445)
  • SQL document issues are fixed (T150956, T151008, T151840, T152134)
  • Query Builder issue is fixed (T151378)
  • Debugger behavior is fixed (T152152, T152908)
  • Other stability improvements and bug fixes (T150877, T155473, T152324, T133575, T131790, T153278, T140900, T155604, T131513, T132137, T153630, T145111, T132953, T150143, T154084, T140633, T154235, T150337, T153139, T153234, T133587, T153620, T137810, T145345, T152489, T132567, T151942, T149488, T128653, T150061, T150335, T150320, T150921, T149767, T150873, T149436)
5.1.71 beta 24-Oct-15

Index Manager

  • Multiple Databases Scan
  • Maintenance Recommendations
  • Export of Scan Results
  • Customizable Index Fragmentation Thresholds
  • Script Generation

Unit Test

  • tSQLt Framework for Implementing Tests
  • No Affect on Actual Database
  • In-isolation Testing
  • Run Multiple Tests in Less Time
  • Built-in unit testing examples
5.0.337 20-Oct-15

Final version released!

  • Minor bug fixes and improvements
  • User reported bug fixes (T145884, T128186, T70220)
5.0.286 beta 02-Sep-15

The extended Standard Edition substitutes the discontinued Data edition. The Enterprise Edition is introduced.

Source Control

  • Support of Subversion (SVN), Team Foundation Server (including TFS Cloud), Git, Perforce, Mercurial, SourceGear Vault systems
  • Repository Manager
  • Source Control Manager
  • Link Database To Source Control Wizard

Code Completion

  • New snippets
  • UPDATE statement expansion
  • Custom alias mapping
  • Pair highlighting
  • SQL refactoring
  • Semicolon insertion

Schema Comparison and Synchronization

  • Database script folder creation and comparison
  • Comparison with database script folder in version control

Data Generator

  • Enhanced RegExp generator
  • Support of composite foreign keys
  • 180+ meaningful generators
  • Extended matching for more intelligent table mapping
  • User-Defined Generators
  • Command-line interface
4.5.79 5-Jun-15
  • Deleting issue in paginal mode is fixed (T132764)
  • NRE during debug is fixed (T127037)
  • Query Builder issue is fixed (T132264)
  • Code Completion not working in Data Editor is fixed (T131816)
  • Dark theme issues are fixed (T131781)
  • Find and Replace issue is fixed (T132953)
  • Data Generator NRE is fixed (T129887)
  • Doesn't save the window size and location on exit issue is fixed (T128392)
  • Other user reported bug fixes (T130215, T131703, T127964, T127805, T127262)
4.5.60 23-Mar-15
  • Improved application startup time
  • NRE during debug is fixed (T127037)
  • Issues during stored procedure execution is fixed (T126569, T127608, T127463)
  • Issue when adding a new trigger to a table is fixed (T127318)
  • Issue when querying linked server without showplan permission is fixed (T122938)
  • Issue with Find and Replace is fixed (T127590)
4.5.40 26-Feb-15

SQL Server Data Generator

  • Fast generation of large volumes of test data
  • Parameters customization for each column data type
  • Preview of test data to be generated
  • Generated data can be executed against a database or exported to SQL script

Schema Compare and Sync

  • Improved text comparer
  • Option to show text comparer in a detached window
  • Preview tooltip for previewing differences in statements with a large number of lines
  • Information pane for indication of comparison and synchronization source and target
  • Redesigned display of database objects in the grid

Data Compare and Sync

  • Information pane for indication of comparison and synchronization source and target
  • Redesigned display of database objects in grid

Data Export and Import

  • Displaying progress bar for data import/export process

User reported bug fixes

  • Issue with queries with more then 32 columns is fixed (T120823, T121353, T121979, T122309, T122657, T122926, T123323, T124468, T120345)
  • Some issues when using filters in database explorer and data viewer are fixed (T117993, T119291, T124479, T123737, T121449, T122917)
  • NRE in Query Builder is fixed (T125435)
  • Debug issues in x64 systems are fixed (T124967)
  • Export and import issues are fixed (T124220, T124453)
  • Ability to attach a database using custom path is implemented (T124297)
  • Issue with generating synchronization scripts via command line is fixed (T121501)
  • NRE in Event Profiler is fixed (T121590)
  • NRE in Data Comparison is fixed (T120723)
  • Issue with CONCAT function is fixed (T120002)
  • Issues in Object Editor are fixed (T120689, T120704)
  • NRE in Find Object is fixed (T119110, T120530)
  • Other bug fixes and improvements (T122969, T122938, T122018, T121709, T121172, T120938, T121172)
4.0.52 12-Dec-14

User reported bug fixes

  • Issue with editing FLOAT data type is fixed (T119295)
  • Error when server Default Backup Path is unavailable is fixed (T119286)
  • Issue with using multiline filters in Database Explorer is fixed (T119271)
  • Issue with scroll arrow is fixed (T119146)
  • Issue with search functionality is fixed (T119092)
  • Issue with stored procedure that contains compile errors (T118943)
  • Errors when creating a snapshot are fixed (T117992, T118124)
  • Issue with selecting a big number of columns is fixed (T118918)
  • Issue with SQL Server 2000 schemes is fixed (T118835)
  • User reported NRE is fixed (T118715)
  • Issues with Data Viewer and HEX view are fixed (T118625, T119221, T119509, T119511)
  • Issue with updating the statistics is fixed (T118480)
  • Issue with CSV export is fixed (T118369)
  • Issue with exporting to SQL with 'Open the result file after export' option on (T118896)
  • Some issues with useless implicit code completion blocks are fixed (T118333)
  • Issue with 'Check for object existence' option for default constraint (T118197)
  • Column filter issues are fixed (T117972, T118400)
4.0.35 17-Nov-14

User reported bug fixes

  • Some users reported crash on using Product Update Manager (T117601, T117698)
  • Code formatting issue (T117843)
  • Issues when using search window (T117835, T117842)
  • Other minor fixes and stability improvements
4.0.24 10-Nov-14

SQL Server Event Profiler

  • Create a trace
  • Watch the trace results as the trace runs
  • Store the trace results in a table
  • Start, stop and modify the trace results as necessary

T-SQL Code Analyzer

  • Identify possible code defects
  • Check T-SQL code for compliance with best practices
  • Code analysis profiles

SQL Editing and Execution

  • Command-line interface for SQL formatting
  • Changing a snippets folder location
  • Query execution pane
  • Easy way to hide data results
  • Encoding switch in the /execute command-line operation
  • MERGE statement support (syntax checking, formatting)
  • Phrase completion
  • Updated Find&Replace feature in documents and files

Database Explorer

  • Creating new schemas and displaying all existing ones
  • Alternative ways to create a new object
  • Generate Script As shortcut menu item for check and default constraints
  • Sending objects to a database diagram
  • Renaming columns
  • Displaying the objects number

Object Editors

  • Completely redesigned Index Editor
  • Updated Check Constraint Editor
  • Updated Database Editor
  • Support of user types when working with tables

Schema Comparison

  • Custom mapping for tables
  • Updated Synchronization wizard
  • Zooming font size in Text Comparer

Data Comparison

  • Show white spaces option
  • Ignore computed columns option
  • Zooming font size in Data Viewer

Data Reporting

  • Support of report parameters in command-line interface

Query Profiler

  • Diagram printing options for a Query Profiler Plan Diagram

Data Editor

  • Data Viewer, LOB Editor, and Redirect Data to Output are combined in a single control
  • Zooming font size in Data Viewer and Editor Window

Data Export and Import

  • Updated Import and Export wizard

Generate Scripts

Security Manager

  • Creating and editing schemas

User Interface

  • Support of multiple monitors

Other Features and Improvements

  • Create Schema Snapshot and Data Report wizard windows are modeless
  • Improved application performance when executing a query, opening a table, designing a diagram, and building a query in the Query Builder
  • Windows 10 support
3.8.218 01-Sep-14

User reported bug fixes

  • Issue with Parameter Info is fixed (T109367, T109953, T111272, T112079)
  • Issue with script formatting is fixed (T109197)
  • Issue with table editor is fixed (T105940)
  • Issue with data comparison is fixed (T111041)
  • Several issues with dark themes are fixed
  • Some other stability improvements
3.8.180 17-Jun-14

Final Version Released!

  • Minor bugfixes and improvements
3.8.171 beta 29-May-14

SQL Server 2014 support

  • Now dbForge Studio for SQL Server supports the latest SQL Server 2014

Database

  • Generate Script As shortcut menu option is added
  • Database Visual Editor is added
  • Database Backup and Restore features are added
  • Possibility to attach and detach a database is added
  • Take Offline and Bring Online database states are added
  • Copying a database from one server to another using the MS Agent is possible now

Generate Schema Script

  • Saving the options setting for future use
  • Support of command line interface
  • Automatic archiving of schema export scripts
  • Writing a report about the process into a log file
  • Automatic old files removal based on date or quantity

Database Explorer

  • Filter settings are available now
  • Objects' dependencies view is supported
  • Possibility to duplicate an object is added
  • Renaming a table through the Database Explorer is possible
  • Delete shortcut menu command is available for all objects' types
  • Disable and enable trigger's menu options are added
  • Each database state has its corresponding icon now
  • Changing a database object name is now possible

Object Editors

  • Database Visual Editor is added
  • Statistics Properties visual editor is added
  • Code preview when editing columns, indexes, etc. is possible now
  • Index editor is improved

Code Completion

  • New CREATE COLUMNSTORE INDEX statement syntax is supported
  • New keywords in the CREATE TABLE statement are supported
  • New keywords in the CREATE INDEX statement are supported
  • New keywords in the CREATE PROCEDURE statement are supported
  • Members prompt for user-defined table type is supported
  • Refactoring aliases is possible now

Data Compare/Schema Compare

  • COLUMNSTORE index is supported
  • Check for object existence option is added to the synchronization wizard
  • Ignore column order in indexes option is added
  • ALTER SCHEMA feature for objects transferring between the schemas is supported
  • Include print comments option is added
  • Exclude comments option is added

SQL Profiler

  • Query plans can be saved visually
  • Results comparison is executed when the required elements are selected
  • Various queries plans can be shown vertically in one view when comparing
  • Buffer and plans cache refresh options are added
  • Zoom menu in the Profiler diagram is available

User Interface

  • Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
  • SSMS shortcut schema availability

Other Features and Improvements

  • Coloring a database connection according to the document category is possible now
  • Database connection properties are expanded
  • SET connection options in query execution are added
  • Possibility to switch from the wizard page to the main application window is added
  • Find Objects feature is expanded
  • Restoring the documents opened in the last session is possible now
  • SQL document zooming by holding the CTRL key and rotating the mouse wheel is added
3.5.93 12-Mar-14

User reported bug fixes

  • Problem with shortcuts is fixed (T98504, T98550, T98774, T98773, T98843, T98932, T98935, T98938, T98985, T99377, T99402, T99657)
  • Problem with identity columns in Data Export is fixed (T98894)
  • T-SQL configuration function @@SERVERNAME is supported (R34372)
3.5.86 18-Feb-14

New code formatter features

  • New Option: Add empty line after GO
  • New Option: Enclose identifiers within square brackets []
  • New Option: Add parentheses when inserting functions
  • New Option: Enable autoformat words while typing
  • New Option: Alias Text Case - As in declaration
  • Code formatter functionality is available even if SQL Complete is disabled
  • Do not format tag is implemented. Now it is possible to format a whole SQL document in the editor ignoring selected code fragments which you do not want to be formatted.

Refresh suggestions cache

  • Automatic refresh suggestions cache by specified time is added
  • New option: Refresh suggestions cache on detecting changes on a server

New code completion features

  • SET IDENTITY INSERT tables suggestion is added
  • XML variables suggestion in the FROM statement is added
  • Column suggestion in the VALUES statement is added
  • Object suggestion for linked servers on SQL Azure is added

Minor improvements

  • Formatting CASE options are redesigned
  • Objects describe performance is improved
  • New snippets are added

User reported bug fixes

  • Problem with unreadable characters in Schema Compare is fixed (R30785)
  • Behavior in Find Object window is improved (R31054)
  • Problem with empty file name in Data Compare is fixed (T73310)
  • OverflowException in Database Diagram is fixed (T91517, T92597)
  • ArgumentNullException during launching the application is fixed (T84639)
  • NullReferenceException in Data Compare is fixed (T94442, T95211)
  • Incorrect behavior with card mode in Data Editor is fixed (R28778)
  • Problem on editing table without unique key in Data Editor is fixed (T93383)
  • NullReferenceException during synchronization in Schema Compare ix fixed (T72231)
  • NullReferenceException during canceling data comparison is fixed (T67964)
  • NullReferenceException on parsing script in object editor is fixed (T95245)
  • NullReferenceException on mapping objects in Data Comparison is fixed (T68493, T68722, T98526)
  • Ability to control-scroll zoom text size is added (T83910)
  • Problem on installing the product is fixed (R28557)
  • InvalidOperationException in Data Compare is fixed (T94736)
  • Incorrect behavior with cycled dependencies during in Schema Compare is fixed (T95144)
  • IndexOutOfRangeException on exporting data into ODBC format in Data Export is fixed (T92435)
  • Problem with database list in Data Compare wizard is fixed (T98144)
  • Problem with completed connection transaction is fixed (T92273)
  • Command 'Create Unique Key' in Database Explorer and table editor is added (T92867)
  • ArgumentException in Data Compare is fixed (T95958, T98204)
  • Text colors in SQL Document are improved (SSMS like style) (T72785,T83910)
  • NullReferenceException in Schema Compare is fixed (T92437, T98377)
  • Problem with snapshot format in Schema Compare is fixed (T97363, T97834, T98493)
3.0.248 21-Nov-13
  • NullReferenceException on hitting the Update Database button in the Stored Procedure editor is fixed (T90279)
  • NullReferenceException on editing data in the Data Editor is fixed (T89961)
  • ArgumentException on loading a .dit file in the Data Import wizard is fixed (T89844)
  • The problem with the New Relation command on the Database Diagram toolbar is fixed (T89138)
  • An option that allows to synchronize objects with square parenthesis is added (T89073)
  • OutOfMemoryException on searching data in Data Editor is fixed (T88817)
  • TypeLoadException while describing database objects is fixed (T88526, T88531)
  • An error on creating a stored procedure using the Object Editor is fixed (T88094)
  • The syntax error in the CREATE SEQUENCE statement is fixed (T90082, T90081)
  • Wrong behavior on comparing parameters in CLR function is fixed (R27916)
  • Problem with the installation of the product is fixed (R28557)
  • Wrong behavior on synchronizing data with a target database in Data Compare is fixed (T90112)
  • The navigation from the Error List to the specific error in a script is fixed (T88471)
3.0.238 15-Oct-13
  • An exception while comparing schemas (on condition that before schema comparison the data comparison process was implemented) is fixed (T84523, T87411)
  • InvalidOperationException while executing queries on SQL Azure is fixed (T84559)
  • A problem related to the focus, while executing several statements is fixed (T84632)
  • A problem with highlighting of the IIF function is fixed (T84653)
  • NullReferenceException while working with a query that contains PIVOT (in Query Builder) is fixed (T84919)
  • Data export functionality to a CSV file is added. Now you can use column separator: tab, space, custom (T86071)
  • OverflowException while editing a table that contains an identifier column with assigned BIGINT type, is fixed (R28330)
  • TypeLoadException on comparing ASSEMBLY is fixed (T88526, T88531)
  • A problem related to the searching and replacing tabs and whitespaces is fixed (R28253)
3.0.230 19-Sep-13
  • NullReferenceException on adding rows in Data Editor is fixed (T84511)
  • NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed (T74907, T75124, T75355, T75356, T75357, T75440, T83022)
  • NullReferenceException on editing a table is fixed (T84516)
  • Error on applying table structure changes in Data Editor is fixed (T84565)
  • NullReferenceException on detecting a cyclic dependency is fixed (T66662)
  • Problem with saving a file's encoding is fixed (T83954)
  • NullReferenceException on attempting to perform synchronization into a snapshot via the command line interface is fixed (T83705)
  • NullReferenceException on executing a query is fixed (T83825, T84358, T84425, T84827)
  • Problem with removing a record in Data Editor is fixed (R26432)
  • Computed columns are now excluded from synchronization by default (T83409)
  • Error report when Estimated Rows exceeds the limits of integer in the Profiler document view is fixed (T83219)
  • Problem with generating a schema name when exporting data using the MERGE mode is fixed (T77218)
  • NullReferenceException on invoking Snippets Manager from the Code Snippets tool window is fixed (T84639)
3.0.217 23-Aug-13
  • Problem with defining input parameters on debugging a procedure with parameters of user-defined type is fixed (R10865)
  • Error on opening schema synchronization script in external editor is fixed (R24795)
  • Problem on importing data from Excel 2007 file is fixed (T75056)
  • Problem in data editor with not assigning default values is fixed (T70859, R10060)
  • NullReferenceException on renaming invalid snippet is fixed (T69969)
  • NullReferenceException on working with snippet template is fixed (R21124)
  • Problem with clearing memory on selecting data from table is fixed (T71228)
  • FileNotFoundException on restarting debug is fixed (R26004)
  • Problem with committing changes in version control system is fixed (T75228)
  • Problem with application freezing on switching between tabs after data synchronization script generation is fixed (T75272)
  • Problem with running the application on .NET Framework 4.5 is fixed (T75603)
  • Problem with showing semi-transparent hints is fixed (T75871)
3.0.205 12-Jul-13
  • Problem with connecting to TFS on visualstudio.com is fixed (R24383)
  • The information is added to the report, while detecting the circular reference (T72560)
  • Syntax check failure for RAISERROR is fixed (T74355)
  • The 'select db..' statement failure is fixed in SQL Complete (T74397)
  • NullReferenceException on editing a table in the editor is fixed (T73420)
  • NullReferenceException on invoking Help in the Command Line is fixed (R23315)
  • The error related to inappropriate columns displaying while changing a query type on the Insert Values ( in the Database Diagram) is fixed (T72173)
  • "Statistics norecompute" options translation is fixed in Russian Edition (T69944)
  • TFS 2010 connection failure is fixed (T73129)
  • Error on changing connection in SQL document is fixed (R23354)
  • NullReferenceException on executing a function from Find Object Results Window is fixed (T72506)
  • Work with memory is improved while redirecting data to the Output window (R22051)
  • The problem with inaccurate title of filter in schema comparison document is fixed (T68928)
  • InvalidCastException on editing a subquery in Query Builder is fixed (R20279)
  • InvalidCastException on refreshing procedure node in Database Explorer is fixed (R20986)
  • The problem with applying a filter in Data Editor is fixed (T70060)
  • The 'Round float types up to 3 digits' option is added in data comparison wizard (R21962)
  • Ability to create snapshots is added to the Standard edition (R22633)
  • NullReferenceException on drag-n-dropping a table to Database Designer is fixed (T72478)
  • Incorrect behavior with identity columns on adding data in Data Editor is fixed (T69095)
3.0.185 15-Apr-13
  • The problem with the temporary table on schema synchronizing is fixed (T66662, T69085, T69895, T69951)
  • The problem with procedure's dependencies determination on schema comparison is fixed (T67595)
  • InvalidOperationException on executing a script is fixed (T69522)
  • ArgumentException on saving command line arguments in the Data Comparison wizard is fixed (R20898)
3.0.180 09-Apr-13
  • Database Diagram is included in the Standard edition without any limitations now
  • The problem with saving the Splitting options is fixed (T60064)
  • InvalidOperationException on executing a script is fixed (R17828)
  • NullReferenceException on debugging a procedure is fixed (T67893)
  • NullReferenceException on closing the procedure editor after debugging is fixed (R19529)
  • The problem with changing options for code editor is fixed (T65707)
  • Incorrect behavior on synchronizing a function in Schema Comparer is fixed (T66941)
  • NullReferenceException on trying to find a search pattern in a document is fixed (R19287)
  • InvalidOperationException on editing data in Data Editor is fixed (T67547)
  • The problem with connection to TFS 11 is fixed (T61250)
  • ArgumentOutOfRangeException on saving changes in the procedure editor is fixed (T66641, T69375, T69490)
  • The problem with the name of a temporary table is fixed (T66662, T69085)
  • The problem with punctuation's visibility in code editor with black background being set is fixed (T65696)
  • NullReferenceException on executing a script is fixed (T65230)
  • Syntax error on executing the current statement using the Execute Current Statement command is fixed (T68993)
  • Problems with mixed case named indexes are fixed (T66552, T68265)
  • Wrong displaying of NULL values in comparison reports is fixed (T68678)
  • NullReferenceException on choosing invalid file as a snapshot file is fixed (R18487)
  • Syntax error on executing a script with @@ variables is fixed (T62139)
  • The problem with using store procedures as Custom Query in data comparison is fixed (T66152)
  • NullReferenceException on switching to the Mapping page in the Data Comparison wizard is fixed (T66404)
  • The problem with saving a comment in the table editor is fixed (T65161, T66267)
  • OverflowException on scrolling a database diagram is fixed (T66729)
  • The error on choosing a snapshot in the Schema Comparison wizard is fixed (T66590, T67465)
3.0.161 16-Jan-13
  • NullReferenceException on comparing schemas of SQL Azure is fixed (T65593)
  • Error on default schema mapping is fixed (R17170)
3.0.160 15-Jan-13

New Features

Ability to create primary fields that are not IDENTITY fields is added.

User reported bug fixes

  • ArgumentException error on clicking Save As My Defaults in the synchronization wizard is fixed (T64077)
  • Problem with displaying options in the Data Import wizard is fixed (T63344)
  • Saving of changes in object mapping to *.dcomp files is fixed (T63179, T63753)
  • ArgumentException on describing view columns is fixed (T38076)
  • Error on searching stored routines names of which contain the '_' symbol is fixed (T62907)
  • NullReferenceException on pressing Ctrl+Shift+Z on a diagram is fixed (T16602)
  • NullReferenceException on calling 'Edit source object' on the schema comparison page is fixed (R15128)
  • The SqlTypeException on executing stored procedure with data entered out of the permissible range is fixed (T64333)
  • The error on working with Team Foundation Server is fixed (T61250)
  • NullReferenceException on setting 'Computed' for columns on diagram is fixed (R16496)
  • InvalidCastException on double-clicking a table in Database Explorer is fixed (T64179)
  • NullReferenceException on double-clicking an element in Suggestions List is fixed (T61512)
  • Error on generating script for indexes is fixed (R13720)
  • Error on setting alias name in upper case is fixed (R15105)
  • NullReferenceException in Query Builder is fixed (T62199, T63974)
  • Incorrect tables comparison when the 'Ignore Unique Key' option is on is fixed (R15118)
  • NullReferenceException error on comparing schemas of backup copies is fixed (R15144)
  • NullReferenceException on editing roles is fixed (R15126)
  • InvalidCastException on editing views is fixed (T59437)
  • Error connected with absence of a table on a diagram if this table is available in the database is fixed (R16585)
  • Error on generation of incorrect schema synchronization script when an account with restricted rights is used is fixed (T63740)
  • NullReferenceException on opening a *.dcomp file is fixed (T65066)
  • NullReferenceException error on creating a SELECT query in Query Builder is fixed (T63549)
  • Error 8623 on schema comparison is fixed (T39594)
  • The 'Cannot browse data in Master-Detail' error is fixed (T59563)
3.0.136 08-Nov-12
  • SQL Server 2012 LocalDB is now supported (R14621)
  • Schema comparison performance is improved (T39594)
  • Synchronization of procedure with dependencies is fixed (R11464)
  • ArgumentException on opening a file through the command line is fixed (T45824)
  • ArgumentException on synchronizing databases in Schema Compare is fixed (T50581, T59826, T60281)
  • Application's hanging when comparing snapshots is fixed (T51789)
  • TargetInvocationException in the Schema Comparison wizard is fixed (R13555)
  • Incorrect creating of foreign keys is fixed (T59065)
  • Incorrect trial on Windows 8 is fixed (T59119, T59496, T59563, T59698, T59827, T59847)
  • ArgumentNullException on finding the next occurrence in text is fixed (R13847)
  • NullReferenceException on profiling a query is fixed (T59489)
  • Old warnings that occurred during comparison are removed now (T59484)
  • Incorrect values on generating DELETE statements in Data Compare are fixed (T59583)
  • NullReferenceException on searching a text in SQL document is fixed (T59700)
  • Option "Disable Check Constraints" is saved in the Data Comparison document now (R14047)
  • NullReferenceException on applying the filter and removing it after refresh in the Schema Comparison document are fixed (T59720)
  • NullReferenceException on opening recent Schema Comparison document is fixed (T59751)
  • TargetInvocationException on getting schemas with insufficient privileges in the Schema Comparison wizard is fixed
  • Incorrect behavior on saving a procedure with errors in its text is fixed (T59939)
  • Error on saving a valid procedure with table variable in its text is fixed (T60026)
  • Incorrect error positions in object editors are fixed (T60129)
  • NullReferenceException on saving Data Comparison document is fixed (T60313)
  • Incorrect behavior on saving stored procedure is fixed (R14530)
  • Non-working command line on operating systems with only .NET Framework 4 installed is fixed (T61027)
  • ComponentNotRegisteredException on comparing data with a backup as a source or target is fixed (T61163)
  • Incorrect behavior with specifying file groups in synchronization scripts is fixed (T60183)
  • Use ALTER will be used instead of DROP/CREATE for stored procedure in all editing features (R13499)
  • Incorrect saving of the length of a column in Column Editor is fixed (T60382)
  • InvalidOperationException on refreshing nodes in Database Explorer with opened Database Diagram document is fixed (T60588)
  • Losing privileges on source objects after editing or synchronizing databases in Schema Compare is fixed (T59672)
  • InvalidOperationException on closing a connection with invalid transaction is fixed (R14818)
3.0.117 18-Sep-12
  • ArgumentException in Pivot Table with spatial data types is fixed (R13561)
  • Incorrect feedback URL in main menu is fixed (R13578)
  • NullReferenceException on creating DDL trigger in the object editor is fixed (R13560)
  • Incorrect behavior with table functions in Query Builder is fixed (R13570)
  • InvalidOperationException on opening the mapping page in Data Export wizard is fixed (R13552)
  • NullReferenceException on opening Data Viewer window in Data Editor is fixed (R13608)
3.0.114 13-Sep-12 (first release of dbForge Studio for SQL Server)

Data Studio for SQL Server is now known as dbForge Studio for SQL Server and incorporates such tools as SQL Complete, Data Studio, Schema Compare, Data Compare and Query Builder for SQL Server.

Product Editions

dbForge Studio for SQL Server comes in 4 editions:

  • Free Express edition with basic functionality for database development
  • Standard edition extends the Express edition's functionality with T-SQL Debugger, Query Profiler, advanced SQL Coding Assistance features, etc
  • Professional fully-featured edition that provides additional functionality
  • Data edition includes all the functionality of the discontinued Data Studio for SQL Server
Major New features
  • Table Designer:
    • Visual editors for table properties
    • Editor for table creation script
    • Rebuild tables when complex changes are introduced
    • Preview changes before modifying a database object
  • Database Diagram:
    • Visual editing, easy manipulation and scaling
    • Containers for grouping objects
    • Printing large diagrams
    • Virtual connections
  • T-SQL Debugger integrated into the stored procedure editor allows to start debugging from the Database Explorer tree
  • Query Profiler for locating bottlenecks and optimizing query execution time with advanced options unavailable in a standard tool
  • Security Manager that incorporates visual editors for logins, users, and roles; batch object editing, etc
Other features
  • Generate Script As in Database Explorer feature added
  • Procedure, function, synonym and sequence editors added
2.0.47 18-Jul-12 (last release of dbForge Data Studio for SQL Server)
  • Error while running Microsoft SQL Server Management Studio is fixed (T39149)
  • Error "Object cannot be cast from DBNull to other types" on SQL server 2012 is fixed (T42098)
  • Start page scrolling bug is fixed
  • Problem with report generating is fixed (T41645)
  • Error "Key cannot be null" is fixed (T41340)
  • "Create synonym with default schema" bug is fixed
  • Error "Incorrect syntax near..." during search object is fixed (T40345)
  • Problem with creating report using .rdb file is fixed
  • Error "Object cannot be cast from DBNull to other types" is fixed (T40064)
  • Problem with messages in trial is fixed
2.0.35 27-Apr-12
  • Some corrections in documentation are made (T34205)
  • Incorrect warning message during synchronization is fixed (R9043)
  • ArgumentException on importing data from MS Excel 2007 is fixed (T34901)
  • Other small fixes in different features are made
2.0.17 05-Apr-12

Second release of dbForge Data Studio for SQL Server comprises a lot of experience and a huge effort that was made to turn our product into the indispensable assistant for application developers that use SQL Server.

SQL Intellisense

Taking into account our users needs and expectations we have integrated the functionality of SQL Complete Express Edition into dbForge Data Studio for SQL Server. Owing to that, the new release introduces users to the following enhancements:

  • Context-sensitive code completion and object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements
  • Smart filtering of the suggestion list based on user input
  • Parameter information for functions
  • Quick object information available from SQL editor
  • SQL formatting with rich options (limited to the set of statements mentioned above)
  • A few other minor features
Query builder can now work with INSERT, UPDATE, and DELETE statements

Thanks to the Visual Query Builder users can create INSERT, UPDATE and DELETE statements. Together with extending the types of edited queries, we have improve general usability of the tool and fixed many bugs. The updated query builder facilitates the process of creating queries and makes it even more intuitive.

Automated data report delivery

This feature enables users to set an automatic data report generation and delivery to a requester. Reports' generation and delivery setup can be executed in the command line, providing an opportunity to use Windows scheduler for regular reports generation (Setup of report's generation and delivery can be executed in the command line, providing an opportunity to use Windows scheduler for regular reports generation):

  • A format for report generation can be chosen
  • "Report delivery" method can be chosen: e-mail, ftp, shared folder
Data export to SQL statements
  • Possibility to export data to INSERT, UPDATE, and MERGE statements
  • Ability to export data from a table or data grid using a wizard
  • Quick export from data grid without opening wizard
Data Compare
  • New extended data reports
  • Custom query result comparison (the results of specific queries can be compared)
  • "One-to-many" objects mapping when addressing columns that were separated as a table in the target database
  • Possibility to include objects into comparison by mask, which is useful when comparing groups of tables
  • Improved analysis of comparison results
  • Improved data synchronization
Convenient work with result sets of several SELECT queries

If there is more than one SELECT statement in a document, query results will be displayed on separate tabs in the Data window after execution.

SQL Server 2012 and SQL Azure Support

New release of Data Studio includes full support for new version of SQL Server and functionality allowing users to work with Microsoft Cloud SQL services, knows as SQL Azure.

Other improvements

User interface skins support is added

1.00.134 28-Apr-11
  • ArgumentNullException on refreshing database list in Data Import Wizard is fixed (T28123)
1.00.133 08-Apr-11
  • Saving of columns aliases in Data Export template files fixed (T27551)
  • Incorrect drawing of some UI elements on x64 systems fixed
1.00.129 09-Mar-11
  • The problem with Data Editor on Microsoft Windows 2000 fixed (T26756)
1.00.128 16-Jan-11
  • The problem with updating the Standard edition fixed (T26317)
1.00.127 12-Jan-11
  • NullReferenceException on opening a large SQL file fixed (T25207)
  • NullReferenceException on applying a custom filter in Data Editor fixed (T25168)
  • NullReferenceException on editing a subquery in Query Builder fixed (T25205)
  • Incorrect behavior on pressing Ctrl+End to fetch all data in Data Editor fixed (58046)
1.00.123 20-Dec-10
  • Fixed the problem with empty column names in Data Editor on executing SELECT statements (57826)
  • Fixed UI defects in the Data Editor navigator (56597, 57124)
  • Fixed NullReferenceException on opening a file with a database report in IDE without any connection (57828)
  • Fixed problem of layout removing on uninstall when the corresponding option is enabled (57829)
  • Now DML triggers are displayed with schema names in Database Explorer (57831)
  • New logo is added in Data Report wizard (57832)
  • Fixed incorrect behavior on drag-and-dropping synonyms on Query Builder (57825)
  • Fixed NullReferenceException on switching the search mode in the Find Objects window when no connections exists in Database Explorer (57843)
  • Fixed NullReferenceException on executing changed SQL statement and showing data in Data Editor (57845)
  • Fixed automatic disabling of server-side operations if such operations are not valid for SQL Server (57846)
1.00.117 16-Dec-10

First release of dbForge Data Studio for SQL Server

© 2010-2017 Devart. All rights reserved.

www.devart.com

dbForge Studio for MySQL History

7.2.78 26-Jul-17
  • User reported issues with FK are fixed (T206260, T217492, T226234, T226259, T225935, T226290, T226142, T226265)
  • User reported issue with Database Projects is fixed (T217490)
7.2.76 12-Jul-17
  • Schema Compare issues are fixed (T221584, T222079, T224011,T224905, T222557)
  • Code Completion issues are fixed (T223857, T220754)
  • Issue with Used By node in Object Explorer is fixed (T224998)
7.2.63 15-May-17
  • The following Key Exchange algorithms are supported: diffie-hellman-group-exchange-sha1, diffie-hellman-group-exchange-sha256
  • The following Message Authentication Code algorithms are supported: hmac-sha2-256, hmac-sha2-512
  • User reported Schema Compare issues with synchronyzation script are fixed (T211159, T211618, T211834, T213946, T214003, T216161, T217109, T217721)
  • User reported issue with COMMENT and CALL in EVENT at projects is fixed (T204437)
  • User reported issue with long stored procedure text and multiple clipboard usage is fixed (T213258)
  • User reported issue with FK lost in Schema Compare script is fixed
  • Other Schema Compare issues are fixed (T207346, T208171)
7.2.58 24-Mar-17
  • Data Editor issues with TIME and DATETIME values are fixed (T195928, T196506, T198573, T199273, T200185, T200559, T200974, T202003, T198018)
  • Some formatting options were reorganized
  • Adding Unique Index is more convinient in Object Editor now (T203572)
  • Some users reported NRE when using Restore Tabs functionality (T199550, T200183, T204970, T205402, T206379, T207082, T207082, T210774)
  • Issue with debugging stored procedures with BLOB paramenters is fixed
  • Issue with double quote in SQL Document is fixed (T203234, T204773)
7.2.53 30-Nov-16
  • Issue with negative TIME value is fixed (T197993)
7.2.50 29-Nov-16

User reported bugs fixed

  • Incorrect display of TIME value is fixed (T196300, T196559, T196674, T195972)
  • Issue with ENGINE = ARCHIVE in Object Editor is fixed
  • Issue in Security Manager which required to type administrator password twice is fixed (T196970)
  • Syntax Check issue is fixed (T196712)
  • Issue with quotes in SQL Document is fixed (T196181, T196212, T196267)
7.2.34 10-Nov-16

New features and improvements

  • The Database Search tool has been completely redesigned for optimal search of both objects and data
  • Visual Object Editors have been totally redesigned
  • Redesigned Table Maintenance wizard
  • Improved SQL document parser performance
  • Connection through Named Pipe implemented
  • Improved XML View and new JSON View for Data Editor and Viewer Window
  • Additional SQL statements are supported (T187713)
  • Syntax Check supports new MariaDB 10.0 - 10.1 statements
  • Styled icons are used by default

User reported bugs fixed

  • SQL Document issues are fixed (T172883, T170496, T170657, T170658, T171035, T171119, T171171, T171358, T172047, T172177, T172347, T172491, T172529, T172813, T172819, T172860, T173321, T173388, T173541, T173902, T174088, T174189, T174361, T174501, T174735, T174849, T175163, T175361, T175410, T175607, T176062, T176333, T176695, T177759, T178102, T178126, T178142, T178249, T179232, T179847, T180034, T180154, T180158, T181197, T181512, T182119, T182210, T184208, T184503, T184558, T184679, T184814, T185168, T185192, T185218, T186194, T186233, T187174, T187362, T187744, T187984, T187984, T179770, T168373, T170778, T188130)
  • Query Builder issues are fixed (T165625, T166837, T167884, T171061, T171232, T178390, T179850)
  • Code Completion issues are fixed (T188385, T187713, T177066)
  • Code Debugger issue is fixed (T186674)
  • Data Compare issue is fixed (T188721)
  • Data Editor and Viewer issues are fixed (T182362, T187164, T175105, T173068, T178729, T185938, T165924, T160960)
  • Data Export\Import issues are fixed (T192786, T191551, T179580)
  • Database Backup\Restore issues are fixed (T182854, T182133, T120273)
  • Database Projects issues are fixed (T187982, T187819)
  • Object Editors issues are fixed (T164191, T169663, T169343, T174613)
  • Schema Compare issues are fixed (T194500, T117290, T184623, T169662)
  • Session Manager issues are fixed (T177351, T181276)
  • SQL Formatter issues are fixed (T179386, T170714)
  • Syntax Check issue is fixed (T187713)
  • SSH connection issue is fixed (T118405)
  • Layout issues are fixed (T174813, T177477)
  • Other user reported bugs are fixed (T130092, T164459, T170444, T174440, T189057, T182066, T180592, T180074, T180087, T181842, T181843, T182529, T183680, T183744, T182854, T184159, T184448, T185377, T186515, T186668)
7.1.31 30-Sep-16
  • Issue with SSL connection is fixed (T189584, T189661)
7.1.30 27-Sep-16
  • Issue with SSH connection is fixed (T164459)
  • Issue with Data Editor and Viewer when request to information_schema returns null is fixed (T170496, T170657, T170658, T171035, T171119, T171171, T171358, T172047, T172177, T172347, T172491, T172529, T172813, T172819, T172860, T173321, T173388, T173541, T173902, T174088, T174189, T174361, T174501, T174735, T174849, T175163, T175361, T175410, T175607, T176062, T176333, T176695, T177759, T178102, T178126, T178142, T178249, T179232, T179847, T180034, T180154, T180158, T181197, T181512, T182119, T182210, T184208, T184503, T184558, T184679, T184814, T185168, T185192, T185218, T186194, T186233, T187174, T187362, T187744, T187984, T187984)
7.1.29 23-Sep-16
  • User reported issue in Data Compare with very long server names is fixed
  • User reported issue with parsing source text is fixed (T188585)
7.1.26 19-Sep-16
  • User reportd issue with quick filter in Data Editor and Viewer is fixed (T187880)
  • Ability to copy table headers without types is implemented (T169314, T170395, T170546, T170790, T171003, T172242, T172559, T174105, T175481, T176860, T183864, T186808, T187218, T187896)
7.1.20 13-Sep-16
  • Latest MySQL builds are supported
7.1.13 27-Apr-16

New features

  • Data type information to the column header in Data Grid added
  • Data Grid now supports Generate Script As feature
  • Generate Script As now available for multiple objects in Database Explorer

User reported bug fixes

  • Issue with application launch on Windows 10 at some systems is fixed (T161952, T166969, T165345, T169104, T168315)
  • NRE when cloding tabs while opening a connection is fixed (T169106)
  • NRE when using auto-hide layout feature under some conditions is fixed (T168859, T168830)
  • Support for specific Unicode characters in SQL document is fixed (T168760)
  • Alias refactoring issue is fixed (T168760)
  • Database Explorer auto-scroll issue is fixed
  • NRE in Completion List under some circumstancies is fixed (T168188)
  • Issue when using Find & Replace in Data Compare document is fixed (T165954)
  • Issue with filtering in Data Viewer is fixed (T165224)
7.0.54 23-Mar-16
  • Issue with synchronizing table with project in Schema Compare is fixed (T164940, T164857)
  • Issue with focus when switching between SQL Document and Data Viewer is fixed (T165099)
  • NRE in Data Editor is fixed (T165224)
7.0.52 14-Mar-16
  • Issue with color of variable in Metropolis Dark skin is fixed (T162483, T163065)
  • NRE when using formatting on delimeter option is fixed (T162560, T163763, T163765, T162963)
  • ansi_quotes support is fixed (T163085)
  • Default comment style reverted to '--' (T163753)
7.0.49 29-Feb-16
  • Issue with connecting to MySQL 5.7 instance on Unix systems when lower_case_table_names set to 0 is fixed (T162055, T161962)
7.0.46 26-Feb-16

Support for MySQL 5.7

  • Support for the PASSWORD EXPIRE option in Security Manager
  • Support for computed columns
  • Support for the JSON Data Type
  • Support for Spatial Indexes

Other features and improvements:

  • Support Percona PAM authentication
  • Support for the Amazon Aurora connection

User reported bug fixes

  • Issue with viewing data comparison details is fixed (T123743)
  • Issue with Generate Script As for table is fixed (T123977)
  • Issue with saving 'Look In' option in Find and Replace window is fixed (T122242)
  • NullReferenceException while executing Report template through CLI with parameters is fixed (T126198)
  • Issue with report generation trough command line is fixed (T128900)
  • Issue with copying columns from one table to another is fixed
  • Some issues with debugger are fixed
  • Issue with connection via SSH is fixed (T133379, T133780, T135203, T144325, T156321, T157597)
  • IndexOutOfRangeException while opening SecurityManager on MySQL 5.7.x is fixed (T138146, T141443, T141640, T151208, T154251, T157386, T157580, T158368, T158801, T157480)
  • Issue with text replacement using regular expression is fixed
  • 'Current Document' is selected by default in Find and Replace window
  • Issues with Session Manager are fixed (T148676)
  • Issue with saving Snippets Folder is fixed (T138878)
  • ArgumentException during data comparison is fixed (T140016)
  • ArgumentException while trying to unlock removed connection is fixed (T140709, T145293)
  • Sending data report via CLI to several email addresses is supported (T140722)
  • NullReferenceException while creating a database is fixed (T141444, T145727)
  • Issue with query profiling is fixed
  • Issue with ignoring foreign key during schema comparison is fixed (T130146)
  • NullReferenceException when browsing to the last rows on the data view in Express edition is fixed (T146205)
  • Exception while executing a query is fixed (T148670)
  • Issues with connection to MySQL 5.7.x is fixed (T152158, T152648, T152709, T153183, T153489, T154109, T158606, T159165, T159384, T159417, T159468, T159601)
  • Issue with Save Changes button in Security Manager is fixed (T151866)
  • COLUMN_GET expressions are recognized correctly (T152603)
  • ArgumentException while lost connection is fixed (T140016)
  • NullReferenceException while saving database objects is fixed (T153915, T156551)
  • Bug when using CAST or CONVERT in stored procedure is fixed (T154606)
  • Viewing functions in GROUP BY are correct (T155234)
  • InvalidOperationException while debugging is fixed (T157468)
  • SQL compile error is fixed (T157498)
  • Text of the message while renaming a columns is correct (T158492)
  • Default path for log is changed
  • Exception while importing databases or trying to backup them is fixed (T159255)
  • Minor issues are fixed (T159322, T150989, T150361, T154089, T146978, T138878)
6.3.358 03-Jun-15
  • Improved application startup time
  • Several debug issues are fixed (T124585, T128025, T128625)
  • Find and Replace issues are fixed (T125864, T125379, T127103, T125379, T133137)
  • Issue with report is fixed (T128900)
  • Issue with data table editor is fixed (T126877)
  • Some formatting issues are fixed (T126448)
  • Data Export issues are fixed (T125522, T131135, T131393, T130436, T130487, T130826)
  • Find Object issue is fixed (T125367)
  • Database Diagram issue is fixed (T103032)
  • Layout issue when switching between different views is fixed (T132105)
  • 'Message: Cannot use named and unnamed parameters in the same command' is fixed (T127440, T129867)
  • Error report when attempting to close a sql tab is fixed (T127738, T128659, T132332)
  • Issue with procedure design mode is fixed (T130840)
  • Query Builder exception is fixed (T133011)
  • Issue in data comparison with big data sets is fixed (T125000)
  • Other improvements and bug fixes (T128679, T131376, T128654, T51955, T124871, T131996, T129833, T128422, T127190, T123388, T123895, T131442, T133283, T129982)
6.3.341 30-Jan-15
  • Stability improvements and bug fixes
  • Issue with SSL connection is fixed (T123387)
6.3.339 23-Jan-15

User reported bug fixes

  • Issue with metadata retrieval is fixed (T121706, T121815, T121873, T121968, T121988, T122003, T122043, T122126, T122135, T122532, T122469, T122479, T122515, T122711, T122722, T122772)
  • Issue with parsing labels is fixed (T122487, T121188, T122636)
  • Issue with Excel export is fixed (T122760)
  • Issue with data table editor is fixed (T122710)
  • Some formatting issues are fixed (T122242)
  • Some issues with search and replace functionality are fixed (T122242)
  • 'Message: The given key was not present in the dictionary' is fixed (T122210)
  • Issues with importing date values from Excel are fixed (T121674, T121681)
  • Issues with documentation not opened in some cases is fixed (T120794)
  • 'Message: Invalid operation. The connection is closed' is fixed (T121715)
  • Release also includes several other bug fixes, stability and performance improvements
6.3.337 5-Jan-15

User reported bug fixes

  • Issue with SSL connection is fixed (T120898, T121089)
  • Issue with editing connection when database restore is in progress is fixed (T120751)
  • Issues with filtering are fixed (T120762, T120805)
  • Issue with opening recent projects is fixed (T120616)
  • Issue with parsing labels is fixed (T121157, T121188, T121283)
6.3.330 25-Dec-14

User reported bug fixes

  • Error report when changing collation is fixed (T120306, T120429, T120485, T120502, T120600, T120603, T120614)
  • Issue with adjusting properties using the Pivot Table is fixed (T120301)
  • Some issues with data import of quoted text are fixed (T120342, T120373)
  • Issue with stored procedure Compile for Debugging is fixed (T119568)
  • Issue with schema comparision with CURRENT_TIMESTAMP columns is fixed (T119947)
  • Issue with 'Look in' field in Find and Replace window is fixed (T120330)
  • Issue with generating reports via command line is fixed (T120566)
  • Issue with rename in Object Editor is fixed (T120654, T120694)
6.3.325 19-Dec-14

User reported bug fixes

  • Issue with creating indexes is fixed (T119874, T119772, T120051)
  • Issue with warnings in data comparision command line is fixed (T112754)
  • Issue with search in projects is fixed (T119891)
  • Issue with reopening export template to modify data type is fixed (T119984)
  • Other minor improvemets and bug fixes
6.3.323 09-Dec-14

SQL Editing and Execution

  • Command-line interface for SQL formatting
  • Query execution pane
  • Option to change a snippets folder location
  • Phrase completion
  • Extended support of MySQL 5.7 in Code Completion
  • Option to set files encoding within the /execute command-line operation

Database Explorer

  • Alternative ways to create a new object
  • Sending objects to a database diagram
  • Displaying the objects number in the tree

Schema Comparison and Sync

  • Selecting object types for comparison

Data Comparison and Sync

  • Option to ignore differences in characters that signify the end of line
  • Show white spaces option
  • Ignore computed columns option
  • Setting up the limit size of bulk during synchronization

Data Export and Import

  • Export to the Excel 2007 (XLSX) format
  • Retaining records filtering when the Export Selected Rows Only option is selected
  • Export of BLOB fields as TEXT to Excel, TXT, HTML, PDF, RTF, and CSV formats
  • Export to Excel, RTF, PDF with/without a header
  • Force quotes option when exporting data to a CSV file
  • Option to select encoding when exporting to DBF
  • Import of dynamic values from Excel and Excel 2007
  • Detecting column types when importing data from the CSV format

Data Report

  • Support of report parameters in the command-line interface

Data Editor

  • Easy way to hide data results
  • Data Viewer and LOB Editor are combined in a single control
  • Redirect Data to Output is transformed into additional data editor

Database Restore

  • Option to set files encoding within the /restore command-line operation

GUI

  • Support of multiple monitors
  • Modeless Create Schema Snapshot and Data Report Wizard windows

Other Features and Improvements

  • Enhanced Find and Replace window
6.2.277 27-Aug-14

User reported bugfixes and minor improvements

  • Problem with stored procedure rename is fixed (T109743)
  • Issue with non standard TEMP path is fixed (T110668, T111808)
  • Application crashes are fixed (T111378, T111231, T11144, T110238)
  • Issue with lost mapping is fixed (T110791)
  • Issue with cache update using shortcut is fixed (T110076)
  • Issue with some select queries with SUBSTRING() is fixed (T105611)
  • Debugger issues are fixed (T111395)
  • Issue with syntax check with newer versions of MySQL is fixed (T111266)
  • Several problems with Data Editor are fixed
  • A lot of other improvements and bugfixes
6.2.234 24-Jul-14

User Interface

  • Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN key combinations
  • Windows connection coloring is added
  • Restoring document tabs from the last session is possible now
  • Switching between wizard window and primary window is possible now
  • Updated Database Explorer
  • Filtering options are available in the Database Explorer
  • New themes are added
  • Start Page is updated
  • Design is upgraded

Object Editors

  • Connection to Sphinx Search Engine
  • Viewing script while editing columns, indexes etc.

Code Completion

  • Alias refactoring
  • Quick Information for cursors
  • Detect changes on a server before refreshing suggestion cache

A lot of minor improvements and bugfixes

6.1.166 19-Mar-14
  • Problem related to InitializeCriticalSectionEx function during launching installation is fixed (R34601)
  • Incorrect behavior with openning stored routine editor is fixed (T99060)
  • ArgumentException on parsing text is fixed (T99110)
  • NullReferenceException in Data Editor is fixed (T98982)
  • Problem with shortcut is fixed (T98963, T98976, T99098, T99172, T99174, T99176, T99202, T99289, T99283, T99372, T99468, T99560, T99605, T99620, T99651, T99652, T99762, T99925, T99936, T100007, T100008, T100019, T100058)
  • InvalidOperationException on evaluating expressions in debugger is fixed (T98740, T99087)
  • OverflowException related to SQL Complete in SQL document is fixed (T98568)
6.1.164 24-Feb-14

New code formatter features

  • New Option: Enclose identifiers within brackets
  • New Option: Add parentheses when inserting functions
  • New Option: Enable autoformat words while typing
  • New Option: Alias Text Case - As in declaration
  • Code formatter functionality is available even if code completion is disabled
  • Do not format tag is implemented. Now it is possible to format a whole SQL document in the editor ignoring selected code fragments which you do not want to be formatted.

Refresh suggestions cache

  • Automatic refresh suggestions cache by specified time is added
  • New option: Refresh suggestions cache on detecting changes on a server

Minor improvements

  • Formatting CASE options are redesigned
6.1.154 05-Feb-14
  • NullReferenceException on a table script generating is fixed (T96763)
  • The ability to filter all string types, including MEDIUMTEXT, in Data Editor is added (R32952)
  • NullReferenceException on parsing text with syntax error in view editor is fixed (T97059)
  • Problem with saving print options in Data Editor is fixed (T96945)
  • Problem with lookup editor in Database Diagram is fixed (T96818)
  • TargetException in table editor is fixed (T96951)
  • CommunicationObjectAbortedException with MyDAC integration is fixed (T94850)
  • Problem with parsing view text in the Express edition is fixed (T96863, T97204)
  • NullReferenceException in Schema Comparison with column names which contain 'virtual' or 'persistent' is fixed (T97218)
  • Problem on editing TEXT columns in Data Editor is fixed (T97010)
6.1.142 24-Jan-14
  • A problem with server version identification is fixed (T96594)
6.1.137 23-Jan-14

Database connectivity support

All known MySQL and MariaDB servers' features are available to use. In this version the following servers are supported:

  • MySQL 5.6
  • MySQL 5.7
  • MariaDB 5.5
  • MariaDB 10.0

MariaDB Virtual Columns are supported in:

  • Data Export/Import wizards
  • Data/Schema Comparison tools

Microseconds support for TIME, DATETIME and TIMESTAMP data types

  • Data Editor
  • Data Export/Import wizards
  • Data Comparison tool

Pluggable authentication is supported

The product provides the extended support of pluggable authentication modules for MySQL servers

Minor features and improvements

  • The application launch time is decreased
  • Performance when worked with UI is improved (T74814, T75400)
  • Federated and Aria engines are supported
  • All new clauses and statements are supported in Syntax Check
  • The FOLLOWS and PRECEDES clauses are supported in the trigger editor
  • The ability to redo changes after undo in the table editor is added (R27345)
  • Microsoft Windows 8.1 is supported

User reported bug fixes

  • AppDomainUnloadedException on maximizing/minimizing the application is fixed (T74588)
  • NullReferenceException on dragging windows is fixed (T75820, T76009, T83924)
  • Incorrect script generating on database refactoring is fixed (T83805)
  • MySQL Embedded 5.6 is supported (R29696)
  • An error on saving a SQL document is fixed (T91012)
  • NullReferenceException on working with models in Database Designer is fixed (T91033)
  • OverflowException on opening an object editor is fixed (T90173)
  • Incorrect behavior while showing the difference between two objects in Schema Compare is fixed (T91476)
  • Incorrect filter data on choosing Today value in Data Editor is fixed (R31110)
6.0.622 26-Nov-13
  • An error occurred while compiling a procedure for debugging (that stores the ENUM data type) is fixed (T88061)
  • ArgumentException while sorting data in the Data Editor is fixed (T88214, T88234, T89919)
  • Wrong behaviour with showing the dialog window on displaying data is fixed (T88367)
  • An error occurred while opening a file without an extension is fixed (T88880)
  • Wrong behaviour with setting a position for a header, when importing from CSV file is fixed (R29019)
  • A syntax error on compiling a project is fixed (R29021)
  • An error occurred while debugging a stored procedure is fixed (T89542)
  • Short names are used now for editing data to avoid problems with replication (R29645)
  • NullReferenceException while displaying the Start Page is fixed (T90258, T91547)
  • NullReferenceException on generating schema script for FEDERATED tables is fixed (T90968)
6.0.568 22-Oct-13
  • An exception while changing a parameter type in the Edit parameters window is fixed (T87420, T87819)
  • A problem, related to displaying variables while debugging a trigger is fixed (T84478)
  • A mistype in the debugging procedure message is fixed (T85881)
  • A problem, related to displaying properties of columns with DOUBLE or FLOAT types, is fixed (R27619)
  • An exception on clicking a splitter button in the Find Results window is fixed (T86371)
  • A problem, related to the table columns prompting in the IN statement, in a subquery that contains WHERE condition is fixed (T86470)
  • An error, while executing Compile for Debugging command for stored procedures is fixed (T87529)
6.0.493 25-Sep-13
  • NullReferenceException on refactoring a table is fixed (T84310)
  • NullReferenceException on sorting data in the Data Editor is fixed (T84292, T84287)
  • NullReferenceException on using invalid file path in the Export wizard (T84136)
  • A table refactoring failure is fixed (T83805)
  • NullReferenceException on editing a condition in the HAVING clause is fixed (T83306)
  • NullReferenceException on editing a column in the table editor is fixed (T83967)
  • An error while inserting data in a table from the Data Editor is fixed (T83957)
  • In case columns are differ by the name, they will be renamed (instead of re-creating) (T83900)
  • NullReferenceException on editing code in the SQL editor is fixed (T83895)
  • NullReferenceException in the Objects Editor document is fixed (T83819, T86126)
  • An error related to scrolling in the table editor is fixed (T83359)
  • An error related to debugger freezing while debugging a function is fixed (T70402)
  • NullReferenceException on compiling a procedure is fixed (T83311)
  • An error occurring while editing parameters types in the procedure editor is fixed (T77234)
  • NullReferenceException on re-opening the procedure editor (after closing parameters window by pressing the ESC button) is fixed (T83238)
  • Receiving of meta data of default database is off (while the "Enable code completion" is disabled) (T83160)
  • An error related to SSH connection is fixed (T75300)
6.0.441 23-Aug-13
  • The problem with the replication is fixed (T24637)
  • InvalidOperationException on closing the application with opened documents is fixed (T74609)
  • The problem with setting the current date in a cell of Data Editor is fixed (T74754)
  • NullReferenceException on choosing an item in the Code Completion window is fixed (T75098, T83498)
  • NullReferenceException on editing an expression in Query Builder is fixed (T75448)
  • InvalidOperationException on describing Code Completion members is fixed (75692)
  • The problem with indentation on formatting a script with the CASE WHEN clauses is fixed (R25618)
  • NullReferenceException on invoking the Save All command is fixed (T76032)
  • Hanging of the application on opening the table editor in transaction mode is fixed (R24636)
  • NullReferenceException on refactoring a table in Database Diagram is fixed (T74916)
  • The problem with showing modifications on the SQL tab of the view editor is fixed (T75084)
  • ArgumentException on executing a script in SQL document is fixed (R25155)
  • The problem with changing a case of variables in the DECLARE clause on formatting a statement is fixed (R25322)
6.0.399 31-Jul-13
  • NullReferenceException on editing view is fixed (T72973)
  • Debugger errors connected with clearing debugging table (T70402)
  • InvalidOperationException on losing connection is fixed (T72844, T73975, T71393, T71700, T72844, T69852, T70596, T73043)
  • Error on creating long synchronization file name or path is fixed (T72510)
  • NullReferenceException on executing query is fixed (T72865)
  • NullReferenceException on compiling objects is fixed (T73797)
  • Error in Code Completion when working with quoted objects is fixed (T73749)
  • Error on displaying full file name or path in the "Windows" window is fixed (T74242)
  • Error on debugging a procedure name of which starts with a number is fixed (T72879)
  • Error on navigating in the FKLookup window of Data Editor is fixed (R23530)
  • Error on formatting the BINARY keyword in the Code Completion functionality is fixed (R24118)
  • NullReferenceException on adding invalid expression to GROUP BY or ORDER BY in Query Builder is fixed (R24196)
  • Error with suggesting the UNSIGNED keyword in the Code Completion functionality is fixed (R22572)
  • Error on deleting the last column in table on editing it is fixed (R23939)
  • Error on debugging procedures with SIGNAL/REGIGNAL operators is fixed (R22322)
  • NullReferenceException in Data Editor on switching view modes with unsaved data is fixed (T74100)
  • Error in Data Compare on generating synchronization script when the "Exclude comments" option is on is fixed (R24244)
  • NullReferenceException on working with SQL document is fixed (T72693)
  • Incorrect behaviour of LOB Editor with unsaved data is fixed (R22597)
  • The Code Debugger interruption error is fixed (R23913)
  • Error on line numbering while grouping data in Data Editor is fixed (R23179)
  • OverflowException when scrolling the Database Diagram is fixed (T70450, T75088)
6.0.315 27-Jun-13
  • Problem with editing multiline text in a VARCHAR column is fixed (R22636)
  • Problem with importing data from Access database is fixed (T72061)
  • Incorrect behaviour on deleting a user in Security Manager is fixed (R23383)
  • Incorrect syntax on creating a user in Security Manager on MySQL server 4.1 is fixed (R23377)
  • Problem on modifying the query text of a view in Database Designer is fixed (T71847)
  • Base64 encoding support is added for HTTP tunnel in the connection editor (T71684)
  • RowNotInTableException on removing a parameter in the procedure editor is fixed (T71001)
  • ArgumentException on showing data after execution of a query is fixed (T71375)
  • Incorrect number of records on showing data in paginal mode in Data Editor is fixed (T72465)
  • NullReferenceException on compiling a procedure is fixed (T72533, T73058)
  • Application crashing on denied access to MySQL services in Service Manager is fixed (R23037)
  • Problem on restoring a backup copy with nonexistent users is fixed (R22186)
  • KeyNotFoundException on canceling query execution in Data Report designer is fixed (T72052)
  • Problem with resetting of toolbar's customization is fixed (T70463)
  • Problem with the INTERNAL keyword in Code Completion is fixed (R22954)
  • Problem with execution of the DELIMITER statement is fixed (T72486)
  • Incorrect behaviour on changing the Primary property in Column Editor is fixed (T72690)
  • Incorrect behaviour on adding new snippets in Snippet Manager is fixed (T72625)
6.0.265 23-May-13
  • NullReferenceException on closing modified Master-Detail document is fixed (T71516)
  • Incorrect script on changing a view in view editor is fixed (R21578)
  • Incorrect data synchronization of the Date type is fixed (T70414)
  • Invalid 'Reset Toolbar Layout' functionality is fixed (R21587)
  • ArgumentOutOfRangeException on comparing a database with a project is fixed (R22031)
  • NullReferenceException on deleting a connection during schema comparison (R22105)
  • Function GREATEST is added to autocompletion list (R21960)
  • Incorrect behaviour with the length of a VARCHAR column on changing a charset is fixed (R21993)
  • ArgumentOutOfRangeException on canceling the formatting of a query is fixed (R21925)
  • InvalidOperationException on setting up markers in Data Import wizard is fixed (T70358)
  • Incorrect error message on importing data from third-party ODBC drivers is fixed (T70907)
  • Invalid navigation to an object from a SQL document is fixed (R21845)
  • ArgumentOutOfRangeException on writing a SQL query is fixed (T71402)
  • Integration with MyDAC on x64 operating systems is added (T70415)
  • CriteriaCompilerException on filtering data in Data Editor is fixed (T70637)
  • Incorrect determination of the current statement in SQL Document is fixed (T71402, T70359)
  • InvalidCastException on sorting data of the Date type in Data Editor is fixed (R22260)
  • Incorrect behaviour on a valid query in Query Builder is fixed (T70645)
  • A few problems on refactoring procedure's name are fixed (T71776)
  • RowNotInTableException on removing a parameter in the procedure editor is fixed (T71001)
6.0.189 25-Apr-13
  • Project building performance is improved (R20862)
  • Problem of building a project with references on 'information_schema' is fixed (R19762)
  • TypeLoadException on loading dbForge Studio is fixed (T69731)
  • Problem with database diagram links is fixed (T69636)
  • ArgumentException on generating schema script is fixed (T70015, T70114)
  • ArgumentOutOfRangeException after deleting column in Query Builder is fixed (T70078)
  • Some documentation problems are fixed (T69629, R20607)
  • ArgumentNullException in Database Diagram is fixed (T69596)
  • InvalidOperationException on loading dbForge Studio is fixed (T70007)
  • InvalidCastException on copying data with header in Data Editor (T70088)
  • Problem on compiling function is fixed (T69704, T70045, T70290)
  • Problem with formatting SQL statements is fixed (T70202)
  • Syntax checking for INSERT...SELECT statement is fixed (T70140)
  • Problem with Database Connection Properties window size is fixed (T70094)
  • The 'POSITION' is a MySQL reserved word (T70199)
  • Problem with Data Editor is fixed (T70089)
  • Problem with 'Delete' key in SQL Document is fixed (T69663)
  • NullReferenceException in object editor is fixed (T70350)
  • MissingMethodException on formatting is fixed (T70002, T70030)
  • Encoding pages 949, 1253, and 1255 are supported (T70478, T70469, T69968, T70212, T70480)
  • Problem with MyDAC integration in RAD Studio is fixed (T70415)
  • Problem with partitioned tables is fixed (T69867)
  • Problem with storing procedure parameters in object editor is fixed (T69619)
  • Problem with parsing procedure body is fixed (T70394)
  • Problem with foreign key in schema synchronization is fixed (T50213)
  • Problem with table named 'option' is fixed (T60303)
  • Option 'Treat NULL and EMPTY STRING as the same value' is added to Data Comparer (T61027)
  • Option 'Force Column Order' is added to Data Comparer (R16375)
  • NullReferenceException on parsing script is fixed (T70429)
  • NullReferenceException on executing a procedure from Database Explorer is fixed (T69922, T69909, T69873, T69866, T69587, T69987, T69945, T69948, T70005)
6.0.151 12-Apr-13
  • NullReferenceException on executing subquery from the modal Query Builder is fixed (R20304)
  • Incorrect behaviour of the Use Commit Mode option in Data Comparison is fixed (R20484)
  • Incorrect behaviour of some code editor's options of in the Express edition is fixed (R20515)
  • NullReferenceException on closing Data Editor is fixed (R20597)
  • ArgumentNullException on showing differences for BLOB fields in Data Comparison document is fixed (R20610)
  • ArgumentOutOfRangeException on canceling compilation of a procedure is fixed (R20661)
  • NullReferenceException on executing a procedure from Database Explorer is fixed (T69635, T69846, T69850)
  • InvalidOperationException on working with document views is fixed (T69709, T69708)
  • Storing parameters value for a procedure is fixed (T69619)
  • TypeLoadException on launching the application on the PC without .NET Framework 3.5 installed is fixed (T69731)
  • Database Diagram is included in the Standard edition without any limitations now
  • ArgumentException on generating the SELECT statement for a table from Database Explorer is fixed (R20821)
6.0.128 04-Apr-13

Database refactoring

This feature allows renaming objects in a database and automatically updates links to these objects in the whole database.

  • Renaming of tables, columns, views, procedures, functions, and indexes is supported
  • Preview of changes in the database with possibility to cancel them selectively is supported
  • Possibility to generate refactoring script of a database without changing it is supported
  • Refactoring functions can be accessed from the tree and object editors
  • Possibility to rename several columns from object editor
  • If an error in processing dependencies is encountered, a user can fix it manually

Query builder with support of DML statements and usability improvements

  • Visual building of INSERT, UPDATE, and DELETE statements is supported
  • Conversion of SELECT queries into INSERT statements is supported
  • One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition is supported
  • Execution of separate subqueries to check their correctness without leaving diagram interface
  • Usability of visual expression editor is improved
  • Query type is indicated on the diagram surface

Data export to SQL statements

  • Data export to INSERT, UPDATE, DELETE, and MERGE statements is supported
  • Ability to export query results as well as data directly from a table is supported
  • Quick generation of INSERT statements from data grid without opening wizard is supported

Improved database object editors

  • Editable column grid in the table editor now allows adding and editing columns without opening the popup dialog
  • Full-text search in the column grid in the table editor is added
  • Schema changes can now be viewed before updating database
  • Editor layout was revised, and now it allows viewing designer and table SQL simultaneously
  • F7 shortcut can now be used to toggle all editor views
  • Stored procedure editor Design tab is redesigned
  • Heuristics is supported

New features in the data comparison tool

  • New data comparison reports now contain table data (not just a summary)
  • Comparison of custom query results (along with tables and views) is added
  • "One-to-many" objects mapping when addressing columns that were separated as a table in the target database is added
  • Possibility to include objects into comparison by mask, which is useful when comparing groups of tables is implemented
  • Full-text data search in comparison results is supported
  • Analysis of comparison results is improved: 'Hide unmodified columns' option, per-column difference counters are added

Improved code completion

  • Column picker feature allows selecting multiple column suggestions from drop-down list
  • Asterisk expansion in SELECT statements is added
  • Context-specific suggestions is improved
  • Quick object information is improved
  • JOIN clause autogeneration is added
  • Autogeneration of table aliases is added
  • Sorting suggested keywords by relevance is added
  • Highlighting occurrences of an identifier in SQL document is added
  • Performance of describing objects' metadata is improved

Automated data report delivery

This feature enables users to set an automatic data report generation and delivery to the requested destination.

Setup of report's generation and delivery can be executed through the command line, providing an opportunity to use Windows scheduler for regular report generation:

  • Users can choose the format for report generation
  • Users can choose "Report delivery" method: e-mail, ftp, shared folder

Code Snippets Manager

Code Templates feature is now renamed to Code Snippets and extended with the Snippets Manager window for adding and editing SQL templates.

Improved code formatter

  • Format profiles are supported
  • Formatting options are extended
  • Preview window for viewing formatted code with support of code highlighting and editing is added
  • Search of options by name is added

New window docking system

  • Switching between tool windows on Ctrl+Tab is supported

Minor features

  • Amazon RDS is supported
  • If there is more than one SELECT statement in a document, query results are now displayed on separate tabs in the Data window after execution
  • Support of MySQL pluggable authentication on creating a connection to MySQL server is added
  • Support of Windows authentication on creating a connection to MySQL server
  • F5 shortcut now works for execution of a selected SQL fragment as well as for the entire script
  • Export of connection list from the application together with other settings is supported
  • Print setup for master-detail browser is supported
  • New skins added (Metropolis and VS2010)
5.0.98 23-Jul-12
  • Problem with missing functions in query designer is fixed (R10934)
  • Error during designing query is fixed (R8955)
  • Program crashing during database backup with Flush tables is fixed (R10055)
  • Error "Invalid argument" when designing query is fixed (R10169)
  • Error "Asynchronous operation already running" when creating pivot table is fixed (R10207)
  • Problem with using the same Build Order for different configuration is fixed (T41472)
  • Error "Out of memory" during database backup is fixed (R10970)
  • Problem with changing toolbar color is fixed (R11255)
  • Error after pressing Ctr+R in the Grid is fixed (T42264)
5.0.82 15-June-12
  • Error report when specifying Not Null in Filter is fixed (T40269)
  • NullReferenceException when editing indexes is fixed (T39663)
  • NullReferenceException when deleting index on a diagram is fixed (T39922, T40763)
  • Error report when editing grid is fixed (T39998)
  • ArgumentException in Data Import Wizard is fixed (T40209)
  • NullReferenceException when dropping an index in Database Explorer is fixed (T40278, T41243, T40278)
  • "EXECUTE" label is added to the "execute" button (R9992)
  • Disabling intellisense buttons on change focus from sql document is added (R9996)
  • The "Invalid parameter value" error when executing a stored procedure with parameters is fixed (T40501)
  • The "Can't get main profiling query." error report is fixed (T40713)
  • NullReferenceException in Data Report is fixed (T40796)
  • "Enter column name" and "Enter table name" phrases on the "Joins" tab are swapped (T41005)
5.0.76 18-May-12
  • Problem with reserved keyword MAXVALUE is fixed (T39661)
  • Problem with 'Execute Current Statement' command when the caret is placed after ';' is fixed (T39448)
  • Error report with a table in the Query Builder is fixed (T39207)
  • Problem with HTTP-tunneling is fixed (T38708)
  • Problem with unexpected focused row in the Data Editor is fixed (T38675)
  • Error report on opening *.dcomp is fixed (R9462)
  • Problem with subquery alias during project building is fixed (R9076)
  • Problem with encrypted password for users in Generate Schema Script and Backup wizards is fixed (R8737)
5.0.72 23-Apr-12
  • Error Report on Parameter information opening is fixed (T36601)
  • Error report on connection creating is fixed (T35423, T36597)
  • Error report on data import from *.xlsx file is fixed (T36030)
  • Error report on table editing is fixed (T36677)
  • Error report on database expanding is fixed (T36988, T38165)
  • Error report on changing current connection is fixed (T37408, T39190)
  • NullReferenceException on import from *.csv file is fixed (T37535)
  • Problem with foreign key dependencies is fixed (T37748)
  • Problem with incorrect dropdown list in SET clause of UPDATE statement is fixed (T38483)
  • NullReferenceException on profiling a query is fixed (T38464)
  • NullReferenceException with connection in multiple threads is fixed (T35192, T39096)
  • Problem on data synchronization in TEXT type columns is fixed (T36801)
  • Problem with out of view columns in comparison document is fixed (T36708)
  • Problem with automatically generated indexes is fixed (R7805)
  • Problem with quoted columns in subpartitions is fixed (R7541)
  • Problem with updating data after default values inserting is fixed (R8419)
  • Problem with function does not exists during debug is fixed (R7153)
  • Problem with wrong result while insert update on duplicate key is fixed (R8563)
  • Problem with subquery alias on project building is fixed (R6372)
  • Problem with UDF reference on project building is fixed (R6373)
5.0.67 02-Mar-12
  • NullReferenceException on starting debug of stored procedure is fixed (R6643)
  • NullReferenceException on sending objects to Chart Designer is fixed (R6642)
  • NullReferenceException on executing a procedure in Standard Edition is fixed (R6641)
  • Problem with showing foreign keys lookup editor in Data Editor is fixed (R5690, R5691)
  • IndexOutOfRangeException on compiling a procedure from Database Explorer is fixed (R6647)
  • InvalidOperationException on formatting SQL after pasting it in SQL document is fixed (T35115)
  • Showing duplicate warning about OutOfMemory in Data Editor is fixed (R5978)
  • NullReferenceException on importing data is fixed (R5416)
  • Few fixes for correct working with asynchronous connections are made (T35264)
  • ExternalException on pasting data in Data Viewer is fixed (T35506)
  • Few fixes on importing data through Thoroughbred ODBC driver are made (T36075)
  • Problem with activating an old object's editor without refreshing it on navigating from code is fixed (T36235)
  • NullReferenceException on closing Data Import wizard is fixed (T36315)
  • KeyNotFoundException on entering a filter in upper case in Query Builder is fixed (T36014)
5.0.63 13-Jan-12
  • NullReferenceException on refreshing connection with an opened SQL document is fixed (R5536)
  • ArgumentOutOfRangeException on wrapping a query to a subquery in Query Builder is fixed (R644)
  • OutOfMemoryException on exporting data is fixed (T34205)
  • Incorrect behaviour on working with the filter in a pivot table is fixed (R5045)
  • NullReferenceException on filtering data in Data Editor is fixed (T35232, T34698)
  • Incorrect behaviour on ignoring columns by mask in Data Compare is fixed (R4292)
  • OutOfMemoryException on generating report in Data Compare is fixed (R4079)
  • Incorrect showing of schema comparison results is fixed (R6198)
  • Conflicts with dbForge Fusion are fixed (T35700, T35770, T35788)
  • NullReferenceException on resizing SQL document is fixed (T35231, T35874, R2171)
  • Generating reports for data comparison results is supported in the command line interface (T32974)
  • Incorrect determination of boundaries for the current statement on executing a query in a SQL document is fixed (R5449)
  • NullReferenceException on wrapping a query to a subquery in Query Builder is fixed (R5766)
  • Incorrect behaviour with changing color of punctuation in code editor is fixed (T33640)
  • Incorrect renaming of alias on wrapping query to subquery in Query Builder is fixed (T34205)
  • ExternalException on synchronizing data in Data Compare is fixed (T34878)
  • Inability of editing data on MySQL 4.1.22 is fixed (R6228)
  • Few problems with showing the foreign key lookup editor in Data Editor are fixed (R5691, R5690)
5.0.60 06-Dec-11
  • A problem with showing the Product update dialog box is fixed (T33358)
  • NullReferenceException on designing a query in Query Builder is fixed (T33930)
  • NullReferenceException on generating text with the last_insert_id function in Query Builder is fixed (R4203, R5243)
  • NullReferenceException on terminating a debug session is fixed (T33166)
  • FormatException on showing data after executing a query is fixed (T33985, T33788, T34883)
  • Problem with restoring closed tool windows is fixed (R5019)
  • Buttons on the Diagram and Layout toolbars are enabled now (T34437)
  • DBConcurrencyException on updating records in Data Editor is fixed (T33830)
  • NullReferenceException on Undo operation in procedure editor is fixed (T34069)
  • IndexOutOfRangeException on opening procedure editor is fixed (T33806)
  • NullReferenceException on parsing text in SQL document is fixed (T33582)
  • Incorrect navigation on errors in object visual editor from Error List is fixed (T33786)
  • NullReferenceException on opening a master-detail document is fixed (T33931, T33559)
  • BadImageFormatException on product tour loading is fixed (T33949)
  • XmlException on opening the Code Templates window with and empty SnippetsIndex.xml file is fixed (T34140)
  • Incorrect editing of dates in Data Editor is fixed (T34205)
  • NotImplementedException on executing procedures is fixed (T33885, T33887)
  • ArgumentException on editing data in Data Editor is fixed (T33826)
  • InvalidOperationException on saving a Database Diagram document is fixed (T34656)
  • InvalidOperationException on loading a preview of Excel file in the Data Import wizard is fixed (T34269)
  • Incorrect behaviour of the filter in Pivot table is fixed (R5045)
  • Problem with importing DBF files with Integer fields is fixed (T34388)
  • Wrong order of tables in generated schema script is fixed (R5481)
  • OdbcException on importing data from ODBC driver is shown in a message box now (T34900)
5.0.54 09-Nov-11
  • Hanging of the application on sorting data in the Foreign key Lookup editor of Data Editor is fixed (R3539)
  • Refresh command is added for the Query Builder document to refresh objects on the diagram (T32015)
  • The problem with server-side sorting and filtering in Data Editor is fixed (R4336)
  • The problem with a table locked by a server in Data Editor is resolved (T32566, T31856)
  • NullReferenceException on editing data in Data Editor is fixed (T32173, T32138, T32104)
  • NullReferenceException on opening a SQL file by drag'n'drop operation is fixed (T32362)
  • NullReferenceException on pressing the Enter key in Data Editor after inserting a new record is fixed (T32393)
  • The problem with debugging a procedure that contains the "SET autocommit" statement is fixed (R3810)
  • The wrong behaviour of the Continue button in the error message appeared during script execution is fixed (R3691)
  • OutOfMemoryException on changing a page in Data Editor is fixed (R3508)
  • NotImplementedException on refreshing events in Database Explorer is fixed (T32833)
  • The problem with connecting to MySQL server using SSL tunnel is fixed (T32811)
  • ArgumentOutOfRangeException on switching from the Text view to the Design view in a SQL document is fixed (T32360)
  • The problem with the name of the temp procedure is fixed (R4215)
  • The problem with showing the Product Update dialog behind of the main form is fixed (T33358)
5.0.50 05-Oct-11
  • The problem with changing database for a document is fixed (R3338)
  • InvalidOperationException on deleting a record in Data Editor is fixed (T31439)
  • The problem with navigating to the found object in the Find Object Results window is fixed (R2478)
  • OutOfMemoryException on backing up a database is fixed (T30188)
  • The problem with showing context menu in the Database Designer on working with two monitors is fixed (R3951)
  • Incorrect behaviour of Code Debugger with the SET AUTOCOMMIT statement is fixed (T32554)
  • InvalidCastException on pasting LONGBLOB data in Data Editor is fixed (R3507)
  • Wrong behaviour on deleting a parameter in a procedure editor is fixed (T31865)
  • NullReferenceException on showing data in Data Editor is fixed (T31832)
5.0.48 26-Aug-11
  • UriFormatException on saving an SQL file on a mapped network drive is fixed (T30092)
  • OutOfMemoryException on backing up a table with large average record size is fixed (T30188, T31332)
  • ObjectDisposedException on executing a script in a SQL document is fixed (T31081)
  • The problem with windows layout on x64 operating systems is fixed (T31293)
  • The syntax error on showing a foreign key lookup editor in Data Editor is fixed (T30438, T30404, T30462)
  • ArgumentException on editing of several records in Data Editor is fixed (T31478)
  • The problem with importing data from ODBC is fixed (T31433)
  • ArgumentException on importing data through the console with the specified connection name as an argument instead of a connection string is fixed (T31433, T31579)
  • NullReferenceException on switching to the Data document view in the SQL document is fixed (R2311)
  • The problem with changing the "Unique" property of a column is fixed (T30482)
  • NullReferenceException on backing up a database on the previously modified connection through the console is fixed (T30487)
  • ArgumentOutOfRangeException on exporting data to SQL is fixed (R3277)
  • The error report on debugging a stored procedure on a stopped MySQL server is fixed (T30506)
  • Bad performance on server side sorting in Data Editor is fixed (T31581, T31511)
  • ArgumentOutOfRangeException on searching in Data Editor is fixed (T31142)
5.0.40 13-Jul-11
  • The error when working with Object Viewer and user without privileges is fixed (R1753)
  • InvalidCastException on paste data into the Data editor is fixed (R2050)
  • The problem with copying column in the table editor was fixed (T30126)
  • IndexOutOfRangeException when drag'n'dropping objects onto Database Diagram is fixed (T30116)
  • The problem with losing procedure's text with some syntax clauses is fixed (T30317)
5.0.37 23-Jun-11
  • NullReferenceException on adding/removing select list items in table wrapped to subquery is fixed (T29303)
  • The problem with spoiled data after data synchronization is fixed (T29750, R1074)
  • NullReferenceException on switching to Design document view in SQL documents is fixed (T29871, T29992)
  • NullReferenceException on showing data in Data Editor is fixed (T29872)
  • The list of editable session variables is expanded (R1818)
  • NullReferenceException on pasting large text to an SQL document is fixed (T29893)
5.0.36 16-Jun-11
  • Incorrect host name displaying in Data Comparison wizard is fixed (T29591)
  • NullReferenceException on refreshing data in Data Editor is fixed (T29562)
  • InvalidCastException on selecting content for backing up a database is fixed (T29505)
  • ArgumentOutOfRangeException on loading a SQL file is fixed (T29427)
  • Incorrect order of objects on generating objects schema is fixed (T29335)
  • NullReferenceException on fetching data after designing a query is fixed (T29277)
  • ArgumentNullException on trying to edit privileges for a connection is fixed (T29265)
  • Incorrect warning on comparing data of BIT fields is fixed (R891)
  • Encoding utf8mb4 is now supported (R890)
  • Incorrect order of statements in schema synchronization script is fixed (R883)
  • InvalidOperationException after editing data in Object Viewer is fixed (R875)
  • Problem with building a database project with disabled "Load completions from database" option is fixed (R871)
  • The Cancel button is now the default one in dialog about uncommitted changes in Data Editor (R870)
  • Annoying notifications in Data Editor are fixed (T28861)
  • ArgumentOutOfRangeException on renaming a procedure in Database Explorer is fixed (T29039)
  • Problem with exporting decimal data is fixed (R860)
  • Unnecessary warnings about exceeding data size during data comparison are removed (T29750)
5.0.33 18-May-11
  • Extra spaces on formatting SQL statements are fixed (T28282)
  • The default value for TIMESTAMP columns is CURRENT_TIMESTAMP now (T28536)
  • Problems with formatting CASE clauses are fixed (S12776963)
  • ArgumentException on trying to compile tables, views, triggers, or events is fixed (T28355, T28365, T28836)
  • ObjectDisposedException on working with autohidden tool windows is fixed (T28329)
  • IndexOutOfRangeException on minimizing and restoring the application is fixed (T28344)
  • Lost connection on executing SLEEP function in SELECT statements is fixed (S12783291)
  • Application hanging on working with irresponsible server is fixed (S12782055)
  • ExternalException on operating clipboard operation in LOB Editor is fixed (T28373)
  • ArgumentOutOfRangeException on displaying view in Object Viewer is fixed (S12791783)
  • Automatic diagram layout on its opening is fixed (S12828929)
  • The problem with changing configuration in database project is fixed (S13035917)
  • "Object doesn't exist in the current context" message on synchronizing or building a project is fixed (S13037877)
  • Incorrect object describing with ANSI server mode is fixed (T28591)
  • The problem with synchronization timeout on debugging procedures is fixed (T28388)
  • FormatException on exporting data to CSV with custom DATE delimiters is fixed (S13040337)
  • NullReferenceException on showing data in Data Editor is fixed (T28478, T28837)
  • InvalidOperationException on synchronizing schema of some procedures is fixed (T28615)
  • The problem with exporting data from DECIMAL columns is fixed (T28367)
  • NotImplementedException on refreshing triggers collection in Database Explorer is fixed (T28363)
  • The problem with bad handshake on connecting to a server is fixed (T28747)
  • FormatException on exporting decimal column to CSV is fixed (S13043575)
  • ArgumentOutOfRangeException on importing data from MS Excel is fixed (T28755)
  • Application hanging on openning a big SQL file with enormous count of JOIN clauses is fixed (T28716)
  • The problem with showing Code Completion window for SUM() function is fixed (S12744935)
  • Incorrect detection of default table engine on some MySQL server versions is fixed (R124)
5.0.30 27-Apr-11
  • The problem with retrieving the running process during product update operation is fixed (T28124)
  • The problem with an unreadable content in Excel files created by Data Export tool is fixed (T27376, T26456, T27435)
  • Hanging of the application on typing a big SELECT statement with enormous number of WHERE conditions is fixed (T28192)
  • The problem with Turkish letters on comparing database's schema and project's schema is fixed (T28274)
  • Extra space before brackets on SQL formatting is fixed (T28282)
  • The possibility to choose database column in Session Manager is added (S12678461)
  • The problem with losing the focused row on refreshing in Session Manager is fixed (S12678585)
  • ArgumentOutOfRangeException on typing some specific grammar constructions in SQL document is fixed (T28218, T28204)
  • The problem with quoted column identifiers in foreign key definition during schema comparison is fixed (T28304)
  • ArgumentNullException on refreshing data in Data Editor is fixed (T28311)
5.0.28 19-Apr-11

Support for MySQL server 5.5

Our product is fully compatible with MySQL server version 5.5

  • New features were added and obsolete clauses removed in the Syntax check functionality
  • New encodings were added to the encoding list in the Connection Properties dialog
  • New kinds of partitioning are supported in the table editor

Master-detail Browser

Explore and analyze master-detail data in a convenient browser with the following features:

  • Design view allows building relations between tables with setting where condition and fetch limit, choosing fields for output, and sorting them by default
  • Data of the parent table/view is shown in the upper part of the Data view to allow analyzing data of child tables/views without extra navigation.
  • The document allows saving and loading data and diagram for future use
  • Sorting and filtering data in the Data view
  • Ability to analyze self-referencing tables

Object dependency tree - unique feature

  • Easily explore object's references and dependents in Database Explorer.
  • Compilation of dependants for debugging is now also available through the object's context menu.

Enhanced Data Editor

Newly added features and a few totally redesigned ones provide even more freedom when working with data.

  • Foreign Key lookup editor added
  • Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
  • A few indications added to inform user about Data Editor's state
  • Editing of tables in join statements is enabled now
  • Option for numbering records added
  • Copy data with header functionality added
  • Ability to build graphical representation of your data with fully functional wizard added

Improved Security Manager

  • Ability to edit permissions for several users added
  • Virtual roles for users were added to allow granting a definite set of permissions to selected users
  • Grouping by hosts in the users list tree added
  • Editing users and working with Security Manager window simplified

Data Export and Import improvements

  • Ability to export data from several tables at once added
  • Exporting data from command line added
  • Importing data from command line added

Object Viewer - a simple way to view object's details

Object Viewer (formerly known as Summary Window) was totally redesigned to provide an easier way for analyzing objects and their structure:

  • There are three views to display properties, DDL (text), and data of the selected object
  • Inner navigation through object hierarchy
  • History with previously viewed objects
  • More information about each object is displayed in the Properties view now

Brand new start page

New functional start page providing the easiest way to learn the product's features and to run the most frequently used ones added.

New state-of-the-art skins

Four new UI skins added to improve the application appearance.

Other improvements

  • Ability to view internal SQL queries that are sent to the server with parameter's values added
  • A few UI improvements in Database Explorer were made
  • Options to ignore clauses during the comparison of events added to the Schema Comparison wizard
  • Highlighting of differences on comparing SQL profiling results added
  • More informative progress during Schema and Data comparison
4.50.348 31-Mar-11
  • Removing field's autoincrement sign on editing index in a table fixed (S11697967)
  • Syntax error on editing, creating or deleting a trigger fixed (T27508)
  • NullReferenceException on interrupting of query profiling in SQL documents fixed (T27349)
  • ArgumentException during query profiling in SQL documents fixed (S11328699)
  • Label caption's layout in the trigger editor fixed (T27186)
  • The problem with updating records on importing data fixed (T27322)
  • OverflowException on working with windows in IDE fixed (T27465)
  • The problem with incorrect displaying of NULL values in Data Editor fixed (S11495585)
  • Problems with displaying of the Query Profiler document view after executing a query in SQL Document fixed (S11495585)
  • The problem with incorrect values for autoincrement TINYINT columns on adding new record in Data Editor fixed (T27454)
  • NullReferenceException on loading the table editor fixed (T27422)
  • The problem with some symbols in identifier's names on building queries in Query Builder fixed (T27310)
  • Displaying 'System.Bytes[]' instead of correct values on some MySQL servers in the Plan view of Query Profiler fixed (T27297)
  • The problem with incorrect generating of DEFAULT clauses on schema synchronization fixed (S11382895)
  • Incorrect behaviour on building a query in Query Builder, if it contains USING UTF8 clause, fixed (T26585)
  • ArgumentOutOfRangeException during importing data to MS Excel fixed (T27247)
  • Displaying 'System.Bytes[]' instead of correct values in Session Manager on some MySQL servers fixed (T27323)
  • NullReferenceException on executing a procedure through the procedure editor fixed (T27596)
4.50.342 16-Mar-11
  • The error on entering selection criteria after selecting Group By fields in Query Builder fixed (T26884)
  • The problem with showing 0 as a parameter value instead of NULL in the parameter editor fixed (T26867)
  • Removing field's autoincrement sign on adding index in the table fixed (T24859)
  • Extra new line on copying data from a cell in Data Editor removed (T27021)
  • The problem with losing ON UPDATE CURRENT_TIMESTAMP during editing a table fixed (T27090)
  • The problems with connecting to MySQL Server via SSH tunnel fixed (T26911, T20079)
  • InvalidOperationExceptions on generating schema synchronization script in the Schema Comparison tool fixed (T27106, T27108)
4.50.339 02-Mar-11
  • The problem on adding records with autoincrement field in Data Editor fixed (S10516747)
  • InvalidOperationException during schema synchronization fixed (T26493)
  • The problem with losing procedure's text if it contains LIMIT statement with new syntax fixed (T26511)
  • NullReferenceException on modifying or saving the text in SQL document fixed (T26446)
4.50.335 18-Feb-11
  • The problem with updating to the new version of the product fixed (T26476, T26479, T26473)
4.50.334 16-Feb-11
  • IndexOutOfRangeException on resizing windows fixed (T26293)
  • Unhandled exception on application closing fixed (S9490001)
4.50.331 02-Feb-11
  • Fixed freezing of Query Builder on editing WHERE conditions (T25766)
  • ArgumentException on opening a database project fixed (T25783)
  • InvalidOperationException on evaluating expressions in the debug session (Quick Info or Watch) with unstable connection to the server fixed (T25657)
  • Fixed freezing of application on typing text in the SQL editor (T25663)
  • Error on editing table data in the Data editor on the MySQL server version 4.0 fixed (T25679)
  • Problem with Clipboard operations in Data Viewer fixed (T25733)
  • NullReferenceException on the Ctrl+V operation in the Data editor fixed (T25740)
  • Problems with backuping up large amounts of data to a compressed file fixed (T25682)
  • Zip64 format for compressing of a backup file is supported now (S9446335)
  • InvalidOperationException on closing application with the opened Schema Comparison document fixed (T26010)
  • ObjectDisposeException on closing the application via Task Manager fixed (T25919)
  • Automated determination of secondary screen's absence is supported now (T25919)
  • IndexOutOfRangeException during data comparison of a case sensitive database fixed (T25882, T25847, T25791)
  • Problem with lost join when working with complex joins in Query Builder fixed (S7174199)
  • Problem with incompatibility of dbForge Studio and other Devart products fixed (T25976)
  • Problem with showing data without formatting for non-unique field names in the executed SELECT statement fixed (S9384611)
4.50.321 19-Jan-11
  • NullReferenceException after procedure execution fixed (T25594)
  • Problem with the floatable Summary window on the secondary monitor fixed (S8483573)
  • Wrong behaviour on generating DEFAULT clause for VARCHAR data type fixed (T25381, T25571)
  • OutOfMemoryException on showing Quick Info in SQL Editor fixed (T25416)
  • OverflowException on viewing table's properties in the Summary window fixed (T25342)
  • NullReferenceException on showing the Generate Schema Script wizard without any connection in Database Explorer fixed (T25418)
  • Incorrect evaluation of ROW_COUNT, FOUND_ROWS, LAST_INSERT_ID in the debugging session fixed
4.50.316 05-Jan-11
  • Sending an extra DROP INDEX statement on altering table fixed (T25204)
  • Fixed problem with loading an assembly in the Express edition (T25282, T25307)
  • OverflowException on resizing documents in different tabbed groups fixed (T24187)
  • NullReferenceException on opening a saved file with query fixed (T25243)
  • Exception when running an update statement with Chinese data and utf8 encoding fixed (S7934055)
4.50.315 21-Dec-10
  • Fixed name quotation in the synchronization script after data comparison (T24989)
  • Fixed InvalidCastException on refreshing data in table editor after editing a table (T24892, T24139)
  • Added IF EXISTS clause to DROP TRIGGER statement on editing trigger (S7387423)
  • Fixed error report on backing up database with compressing to ZIP64 format (T24741)
  • Fixed NullReferenceException on activating Session Manager after reloading application (S6506785)
4.50.313 07-Dec-10
  • Fixed NullReferenceException on collapsing node in Document Outline (56493)
  • Fixed NullReferenceException on IDE closing (T24672, T24635, T24057, T24225, T24152, T23895, T24459)
  • Fixed problems with Web Browser on refreshing, navigating and so on (57419, 57417, 57396, 57418, 57397, 57380)
  • Fixed cleaning of Redo Stack in SQL Editor after mouse click (56690)
  • Fixed IndexOutOfRangeException in Find and Replace (54918)
4.50.311 27-Oct-10
  • Removed spaces in the integer and float format in Data Export wizard (T23612)
  • Fixed NullReferenceException on saving a database project with opened table editors (T23519)
  • Fixed NullReferenceException on deleting a table from a database with an opened inactive editor (56081)
  • Fixed NullReferenceException on auto hiding a tool window (T23494)
  • Added possibility to edit a definer for triggers in the trigger editor (T23357)
  • Fixed problem with BINARY(16) column type on selecting its data to the Data Editor (T23292)
  • Fixed problem with empty gray windows after editing a table in the modal editor from Database Designer (T23164, T23018)
  • Fixed link on the first page in the product tour (55629)
  • Fixed syntax checking for some constructions in CREATE TABLE statements (55161)
  • Fixed lost connection on the data comparing (T22521)
  • Impossibility to disable Code Completion in the Express edition was fixed (54932)
  • Files in database projects are saved with a relative path now (54378)
4.50.308 20-Oct-10
  • Fixed automatic check updates
  • The length of a watch value was expanded to the maximum value 65355 (T23348)
4.50.306 22-Sep-10
  • Fixed updating the stored procedure editor after saving (T18354)
  • Fixed an error in Data Editor (T22099, T22004)
  • Fixed an error on opening the column editor from Database Diagram (T22278)
  • Fixed search canceling in Data Editor when the Esc button pressed (T22354)
  • Fixed Data Import of large Microsoft Excel 2007 files (T22506)
  • Improved displaying ACTION properties of foreign keys (T22539)
  • Enabled the 'Use bulk insert' checkbox when importing data into a new table (54516)
  • Fixed opening connection before restoring a database (T22159)
  • Fixed corrupted statements after commit in Code Completion Window (54930)
  • Fixed an error on trying to edit a stored procedure in the opened editor if the procedure contains regions in the body (54223)
  • Fixed InvalidOperationException on opening user function in the editor (T21888)
  • Fixed corrupting statements in Query Builder (T21893)
  • Fixed inability to stop Code Debugger by the Stop button (55167)
  • Now .NET Framework 4.0 is supported (54701)
4.50.303 29-Jul-10
  • Fixed incorrect display of Product Tour on Windows 7 (T21994, T21986)
  • Fixed backup process hangup after it was canceled
  • Fixed error on deleting of column on mapping page in Data Import wizard
  • Fixed a couple problems with text markers in the data import from text file
4.50.300 19-Jul-10

New Features

Product Tour has been totally redesigned to provide more flexible navigation to topics.

User reported bug fixes

  • T12461 incorrect results of SQL Refactoring in database project
  • T20514 Stopping Code Debugger do not stop it
  • CR53409 Problem with updating view after saving
  • CR53449 Query Profiler must show date of profiling result in local format
  • CR53463 Cannot delete primary key on a column with autoincrement from Database Explorer
  • CR53472 Disable changing project configuration when building project
  • CR53497 Problem with backing up through the command line after lost connection
  • CR53501 InvalidOperationException on executing script in SQL document
  • CR53573 Unavailable documentation in Schema Compare wizard
  • T16516 Persistent modification marker in trigger editor after trigger saving
  • T16516 Problem with temporary procedure on procedure editing
  • CR53593 NullReferenceException after clearing all in the Where editor in Query Builder
  • T20339 All routines run twice after session killing
  • CR53640,CR53641,CR53643,CR53645 Problems with database projects
  • CR53644 NullReferenceException on getting new results in Query Profiler if the document was opened with the loaded database project
  • CR53646 Why the Refresh button is disabled after reopen SQL document?
  • T20888 NullReferenceException on refreshing data in Data Editor
  • CR53678 Hide password in log file on backing up database
  • CR53709,CR53719 Problems with navigating to result of data search
  • CR53720 Do not save opened document views in SQL document
  • T21284 Display System.Byte[] instead of default values of table columns on MySQL 4.1.x
  • T10942 Add option to ignore query cache on query profiling
  • CR53767 Problems with query profiling on MySQL 4.1.x
  • CR53792 Support relative path of log file in Database Backup Wizard
  • T21587 When exporting a table or backing up a database, date column is improperly exported/created
  • CR53843 Current statement marker hides on breakpoint removing
  • CR53852,53859 Breakpoint in code editor doesn't synchronize with Breakpoints window
  • CR53853 Problem with code debugger on procedure renaming
4.50.285 24-Jun-10
  • Fix of InvalidCastException on opening tables node in Database Explorer (T19199, T19210, T19284)
  • Fix of parameter count mismatch on debugging a procedure (53452)
4.50.282 23-Jun-10

Extended Express Edition

The following tools are added:

  • Session Manager
  • Server Variables
  • Table Maintenance Wizard
  • Flush dialog box
  • Database Backup Wizard with some limitations. It does not support command line, backup projects, autodeletion of old backup files, compression, and backup files larger than 1 MB.
  • Database Restore Wizard

Besides, Database Designer now supports 10 tables and Query Builder can work with 3 tables.

Redesigned Database Backup Wizard

Schema Export wizard has been totally redesigned to provide more freedom for backing up schemas. It features the following:

  • Capability to save backup options for future use
  • Support of command line interface. You can back up schemas in automatic mode using Windows task scheduler
  • Automatic archiving of schema backup scripts
  • Writing a report about backup process into a log file
  • Automatic removing old backup files based on date or quantity

New tool for database developers - Query Profiler

dbForge Studio offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN in a convenient and clear GUI. Besides you get STATUS variables for the required query automatically calculated.

Additional benefits:

  • Plan of the query displayed in the tree view for easy review
  • Profiling history that can be saved for further analysis
  • Capability to compare profiling results in two clicks
  • Capability to print profiling results

Revised Data Comparison tool

Diverse testing and close interaction with database developers, admins and casual users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now it embraces the following:

  • Capability to compare and synchronize database of any size
  • Increased performance of comparison processes
  • Generating accurate comparison reports in HTML and Excel formats
  • Capability to change synchronization direction in one click
  • New comparison options: Ignore columns by mask, Ignore trailing spaces, Round float types
  • Quick filtering tables in comparison results
  • Optimized object management during custom synchronization
  • Capability to edit values of default comparison options
  • New synchronization option Exclude Comments

Improved Query Builder tool

Meet a stronger Query Builder tailored for creating complex conditions with several clicks. The new power is based on the following:

  • Optimized usability of the Selection tab in the expression editor
  • New Wrap to Subquery option to wrap tables into a subquery
  • Visual addition of subqueries to any part of the main query
  • Optimized navigation in the editor, particularly between subqueries
  • Capability to edit view location in the query document
  • Joins show connection direction; better described connection properties
  • New skin for objects on the diagram

Quick generating template SQL scripts for database objects

Thanks to this new functionality, you can save your time while working with database objects. For example, you can quickly generate template SQL scripts CREATE, DROP, SELECT, INSERT, UPDATE or DELETE scripts for tables. This option is available in the context menu and called "Create Script As".

A few improvements in Schema Comparison tool

  • Extended capabilities of Schema Comparison wizard
  • New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions, default values for columns

Other improvements

  • New SQL document view layout - now you can see query text and retrieved data at the same time
  • Generate DDL wizard was renamed into Generate Schema Script

User reported bug fixes

  • T13265 Transport channel is closed
  • T10434, T10619 IndexOutOfRangeException on comparing data
  • CR51988 Error on foreign keys editing in Database Explorer window
  • T13766,T15231 ArgumentNullException at System.Windows.Forms.DataObject.SetText on working with Data Editor
  • T13619 Support of command line functionality for x64
  • T13003 The record pointer moves out of the actual edited record when Ctrl+0 was pressed (fill field with NULL)
  • T13110 Reset of VARCHAR column length to 20 in Column Editor on length editor focusing
  • CR51956 Incorrect displaying datetime values in Data Editor
  • T14852 Incorrect display of application toolbars on some operating systems
  • T12555 NullReferenceException on generating schema comparison reports
  • T13445 Generating a wrong SET NAMES statement
  • T12968 Inability to export data to Excel
  • CR49793 Removing two parameters in Parameter Editor on pressing the Del key
  • T9796, T10352, T10942 Missing SQL Profiler functionality
  • T9830, T10951, T11289 Missing script generating for objects (select, insert, update, create, drop, etc)
  • CR39462 Missing ignore options for schema comparison
  • CR52697 Table is locked by the server
  • T14848 Generating a redundant synchronization script in Schema Comparison
  • T15166 Expanding a collapsed region in Procedure Editor in case of any error after procedure compilation
  • T15997 MissingMethodException on showing the Code Completion window in the operating system without update pack on Microsoft .NET Framework
  • T12461 Leg parameter type case ignoring during procedure comparison
  • T16583, T17758 ArgumentNullException on saving a template with column mapping in the Data Import Wizard
  • T16250 Slow "Views" node opening in the Database Explorer
  • T15989 NullReferenceException on retrieving data from the Database Explorer
  • T16250 Problems with export data in Swedish format to Excel
4.00.224 15-Apr-10
  • NullReferenceException on switching view mode in Data Editor was fixed (T10961)
  • Reload of the editor after saving an invalid procedure was removed (T11596)
  • The number of elements in the filter list of Data Editor was increased (T10840)
  • The problem with inserting a space in the beginning of the line after code uncommenting in SQL editor was fixed (T10960)
  • The problem with quotes in table comments was fixed (50507)
  • InvalidCastException on reconnecting was fixed (T11155)
  • Support of UTF-8 for MySQL Server versions prior to 4.1 (50201)
  • The problem of retrieving tables metadata during mapping in Data Compare was fixed (T10434, T10619)
  • NullReferenceException during opening a database diagram from a demo-project, when no connection is found, was fixed (T11314)
  • The error on copying data from Data Editor was fixed (T11583)
  • IndexOutOfRangeException on editing invalid SQL statement in SQL document with enabled autoformatting was fixed (T11034)
  • Command out of sync on query execution was fixed (T10834)
  • Incorrect behaviour of undo command in SQL document was fixed (T10960)
  • The problem of data displaying during data selecting from a view was fixed (T11073)
4.00.206 10-Feb-10
  • NullReferenceException on creating a new procedure in the procedure editor was fixed (T10370)
  • Application locking up during saving modifications in the table editor was fixed (T9980)
  • Problem with user privileges during procedure editing was fixed (48968)
  • IndexOutOfRangeException on running data comparison was fixed (T10434)
  • NullReferenceException on showing context menu in Data Editor was fixed (T10427)
  • NullReferenceException on saving a table in the table editor was fixed (T10516)
  • Problem with product installation on some operating systems was fixed (T10353)
  • DBF III with memo is supported (T10286)
4.00.202 26-Jan-10
  • Capability to set connection encoding to get compatibility with prior product versions was added (T10131, T8475)
  • NullReferenceException while closing Data view of the document was fixed (T10254)
4.00.200 25-Jan-10
  • Data import from various formats (Text, CSV, Excel, ODBC, Excel 2007, Access, XML, DBF) implemented
  • Improved work with Data Editor
  • Pivot Grid for data analysis was added
  • Data Reports functionality was added
  • Capability to create virtual relations on Database Diagram was added
  • Capability to generate schema comparison reports
  • Customizable product updates check, downloading and installation
  • Product installation was redesigned to allow product updating without uninstalling a previous version
  • Enhanced management of schema comparison results
  • Capability to add an SQL-filter to every pair of tables, while comparing data, was implemented
  • Capability to ignore triggers during data synchronization was added
  • Design of Procedure editor wad extended, capability to edit procedure parameters was added
  • While working with an SQL document, it is easy to set a database for script execution
  • A mechanism to renew a server connection after its break was implemented
  • Interaction between database connections and a MySQL service in Service Manager was improved
  • Multiple usability improvements throughout the application
3.60.379 24-Nov-09
  • The problem with procedure or function parameters parsing was fixed (T9073)
  • Hang after Copy-Paste operations in the SQL document was fixed
3.60.376 12-Nov-09
  • Execute timeout setting works properly during editing objects or executing scripts (T7607)
  • New connection encoding mode compatible with connection properties in prior product versions was added (T8475, T8722)
  • Error with names in mixed-case while working with Database Diagram was fixed (46678)
3.60.368 22-Oct-09
  • Syntax check fixes(T7912, T7127)
  • All the styles of the text editor including numerical ones are applied during editing from the Options window (45304)
  • Hang-up on getting Quick Info while editing some procedures was fixed (T7660, T7864, T7679)
  • NullReferenceException during opening documents was fixed (T7577)
  • InvalidOperationException during working with Database Diagram (T7314) was fixed
  • Characters are correctly displayed with any selected encoding (T7430, T8234, T8173, T7484)
  • Commands work correctly during toolbars customization (T5201)
  • NullReferenceException while using "Best Fit" option for multiple data set was fixed (T6971)
  • Data vanishing from adjacent cells in Data Editor during copy-paste operations was fixed (T7454)
  • Now if creating table's index command takes a long time, Execute timeout value specified for the selected connection is applied (T7607)
  • Now keys generated by PuTTY are supported without conversion into an OpenSSH-supported format (T7582)
  • Clear Type was supported in Database Diagram (T8338)
  • Fixes in employing HTTP-tunneling (T8213, T8161)
  • Data Export feature was added in Express edition
3.60.360 16-Sep-09
  • TargetInvocationException occurs arbitrarily when performing various actions (T7314)
  • Fix of NullReferenceException on Data Compare result document showing with "Automatically adjust column width" option enabled (44420)
  • Fix of NullReferenceException on working with MySQL Server version less than 4.0 and with "Detect MySQL character set" option enabled (44059)
  • Problem with editing data in Data Editor with enabled paginal mode was fixed
  • Bugs with INSERT options in Schema Export were fixed
  • Bug with autoincrement value generation during editing data was fixed (T7182)
  • Problem with setting connection character set was fixed (44067)
3.60.351 28-Aug-09
  • Schema Compare skips differences between AVG_ROW_LENGTH values in code viewers (T6118)
  • Problem with inserting data into TEXT fields by LOB Editor fixed (T7011)
  • Problem with connecting to some SSH servers fixed
  • NullReferenceException on working with Summary Window fixed (T6969)
  • NullReferenceException on best fit columns with multiple results in the Data Editor fixed (T6971)
  • Bug with moving tables on the Database Diagram after modification fixed (T6769)
3.60.347 12-Aug-09
  • New HTTP tunneling is implemented
  • Public key authentication for SSH connection is supported
  • More flexible setting of connection character set is implemented
  • Performance on large databases has been improved
  • Stored procedures are executed asynchronously now
  • Retrieving data from tables has become more faster and convenient
  • Database connectivity was optimized. Better performance while opening connections, managing database objects, doing schema and data export.
  • Problem with executing stored procedures by limited user was fixed (T6061)
  • Problem with mixed case of column names was fixed (T6107)
  • Schema Compare skips differences between AVG_ROW_LENGTH values (T6118)
  • CryptographicException on loading connections was fixed (T6228)
  • Possibility to change file encoding in Schema Import and Execute Wizard was added (T6387)
  • LOAD DATA LOCAL INFILE statement is now supported (T6448)
  • Problem with regional value of decimal separator during data copy from Data Editor was fixed (T4656)
  • Bug with adding AUTOINCREMENT column was fixed (T6039)
  • NullReferenceException on renaming the table which is displayed in the Database Diagram document was fixed (T6502)
  • NullReferenceException on exporting data from Data Editor was fixed (T6688)
  • ArgumentException in Summary Window when a node in Database Explorer has been selected was fixed (T6771)
3.50.310 25-Jun-09
  • Problem with editing of some procedures was fixed (T5860)
3.50.305 23-Jun-09
  • Problem with obtaining the SQL code for procedures was fixed (42100)
  • The bug with application hang on parsing some view texts was fixed (41333)
  • The "Stop" button that stops query executing is working correctly now (41292)
  • The bug with removing of a procedure during its renaming was fixed (41284)
  • IndexOutOfRangeException on working with identifier's aliases in SELECT statements was fixed (41712)
  • IndexOutOfRangeException during tables editing was fixed (41716)
  • The problem with incorrect detection of relations between tables in Database Diagram was fixed (41799)
  • NullReferenceException on closing an SQL document was fixed (41876)
  • NullReferenceException on project opening was fixed (41458)
  • The problem with the unsaved "Use Unicode" option in connection properties was fixed (41427)
  • NullReferenceException and InvalidOperationException on closing the application were fixed (41864)
  • The problem with truncating data of the UTF8 database after editing in LOB editor was fixed (T5219)
  • ObjectDisposedException on the automatically hidden tool window display was fixed (41299)
3.50.290 21-May-09
  • NullReferenceException on closing SQL document after work with query builder was fixed (41213)
  • Wrong data result on SELECT executing in Paginal Mode was fixed (41199)
  • Shortcuts in SQL editor of trigger and view editor are working now (41138)
  • Blank Security Manager after changing connection's property was fixed (41135)
3.50.287 12-May-09
  • Problem with showing appropriate editor in the Data window for DATETIME columns fixed (40731)
  • Bug when another constraint has been added to tables which located on different containers in the Database Diagram fixed (40770)
  • Data Export to HTML is working with Unicode now (40871)
  • Bugs in DDL generation for tables with DATETIME columns fixed
  • Bug with importing settings that had been saved in 3.10 fixed (40885)
  • NullReferenceException related to closing of the database object document in the Express edition fixed (40886)
  • Application hang-up on Paste operation in stored procedure editor fixed (41004)
  • NullReferenceException when reopening pinned document from Database Diagram fixed (41008)
3.50.275 23-Apr-09
  • New excellent database diagram added
  • Custom mapping of tables, columns, and views with different names available
  • Custom mapping of columns with different types added
  • Capability to map a table and a view added
  • Capability to cancel custom mapping and return to the automatic one added
  • Detailed information about each mapped column and warnings before synchronizations shown
  • The Find box for quick search of objects added
  • Extended filtering of objects by their status added (the following are available: valid or invalid mapping, auto or user mapped, fully or partially mapped, included or excluded in comparison)
  • Ignore Case, Ignore Spaces, Ignore Underscores mapping options added
  • Data comparison speed boosted 5-10 times
  • Capability to filter schema comparison results by object type, update operation, or status added
  • Quick search by object name in schema comparison results added
  • Grouping by comparison difference type or update operation added
  • Capability to cancel grouping
  • Preview of the synchronization script for any object in the schema comparison results implemented
  • Execute Script Wizard added to execute large SQL scripts
  • Use Compression setting added to connection
  • Many other improvements
3.10.227 26-Feb-09
  • Problem with retrieving data from Database Explorer was fixed (38089)
  • Bugs occurred during removing errors of formatting from Error List were fixed (38120, 38124)
  • Bug on creating procedures with comments was fixed (38122)
3.10.225 12-Feb-09
  • 'Cannot access a disposed object' error is fixed while working with windows (37379)
  • NullReferenceException error is fixed while closing the document (35195).
  • NullReferenceException error is fixed while getting data in Data Editor and scrolling simultaneously (36252).
  • Unicode data output in LOB editor is fixed
  • Problem with changing connection string was fixed (36547)
  • Bug with debug starting on the server in replication slave mode was fixed (37198)
  • Bug with executing or debugging procedure which include BIGINT UNSINGED parameter was fixed (37200)
3.10.222 12-Jan-09
  • Bug with end date in event editor was fixed (35582)
  • Some problems with generation database export file were fixed (34262)
  • Many other small improvements were made.
  • NullReferenceException on using horizontal scroll bar in Data Editor was fixed (36252)
  • Procedure's input parameters are saved in the procedure editor between executions now
  • Problem with syntax error when deploying debug engine fixed
  • NullReferenceException after text replace operation fixed
3.10.209 17-Dec-08
  • Bug with showing second popup menu in left-top corner on any grid was fixed (35288)
  • Issues on Text Comparison module load failure were solved (35118)
3.10.205 08-Dec-08
  • Projects can have different connections for different configurations
  • Incremental database project synchronization with the server
  • Database object dependencies are now considered when generating scripts with Generate DDL, Schema Export, New Project, and Schema Synchronization wizards.
  • SQL Editor performance increased
  • Filter toolbar added to the Error List window
  • Sample database project added to the installation
3.00.192 06-Nov-08
  • NullReferenceException on text editing in the text editor was fixed (33628)
  • Lost connection while running the query was fixed (33520)
  • KeyNotFoundException on text editing in the editor was fixed (33546, 33682, 33844)
  • Exception during clipboard operations was fixed (29068)
  • NullReferenceException during exporting geometry data was fixed(33255)
  • NullReferenceException on open schema comparison file without connection or with modified connection's properties was fixed (32500)
  • Problem with automatic changing connection timeout was fixed (33465)
  • Problem with adding additional symbols in the text of procedure during opening procedure editor was fixed (33435)
  • SQL formatting errors were fixed (32352, 33413, 33599, 33611)
  • Reference resolving error when building project was fixed (33560)
3.00.183 18-Sep-08
  • Forced capitalization when saving a procedure fixed
  • NullReferenceException when trying to open a schema comparison fixed (32500)
3.00.146 01-Aug-08
  • MyDeveloper Studio becomes dbForge Studio for MySQL
  • Product divided into Express, Standard, and Professional editions.
  • Database Project enhanced
  • Schema comparison tool added
  • Data comparison tool added
  • SQL Code Formatting added
  • SQL syntax check supported
  • SQL refactoring added
  • Reference check added
  • Debugger for stored routines and SQL scripts added
  • Brand new Query Builder implemented
  • Project building to a result script
  • A range of data export formats extended
  • Tools for centralized Server Administration and Maintenance added
  • Summary Window added
  • Partitioning support
  • Merge and Falcon table support
  • Import and Export of dbForge Studio for MySQL Settings
  • Context-sensitive help revised and improved
  • Many other improvements
2.10.78 09-Jan-08
  • Bug fixed with default shortcut schema loading (25263)
  • Bug fixed with generic error in GDI+ (24902)
  • NullReferenceException when fulfilling data export fixed (25264)
  • NullReferenceException when retrieving data fixed (24961)
  • NullReferenceException when working with code templates fixed (24901)
  • NullReferenceException when file saving fixed (25394)
2.10.77 05-Dec-07
  • Bug fixed with exception on application loading under Framework 2.0
  • Bug fixed with installation process suspension under Framework 2.0
  • Bug fixed with breakpoints validation(23587)
2.10.76 26-Nov-07
  • Bug fixed with InvalidOperationException when stopping the server (24110)
  • Bug fixed with decimal type fields scale parameter (24203)
  • Bug fixed with generic error in GDI+ (24466)
2.10.74 23-Oct-07
  • Bug fixed with ArgumentOutOfRangeException in QueryBuilder (23954)
  • Now autoincrement in BIGINT columns is supported
  • Bug fixed with displaying of several foreign keys in the table
  • UTF-8 Encoding is supported in database export (23944)
  • Exception when inserting text to the stored procedure text editor is eliminated (23904)
2.10.71 02-Oct-07
  • Bugs fixed with foreign keys modification and creation (23722, 23724)
  • Bug fixed with expanding tables or views in the Database Explorer (23751)
  • Bug fixed with exception in Table Maintenance wizard (23787)
2.10.68 20-Sep-07
  • Code template preview added, template system usability improved
  • Navigation history added to Database Explorer
  • Column type and size can be displayed in Database Explorer
  • User comments for tables columns supported
  • SQL Log output customization supported
  • Setting of Date format can be fulfilled in Data Editor
  • Start Page added
  • Many other improvements
2.00.49 06-Jul-07
  • The problem with encoding 'Chinese Simplified (GB2312)' during execute fixed
  • Automatic indentation bug fixed in SQL editor
  • Bug fixed with arithmetic overflow/underflow on font initialization (FixFPU)
  • ArgumentOutOfRangeException during column check in the Query Builder Form bug fixed
  • NullReferenceException on query execution fixed
  • DllNotFoundException on connection refresh fixed (embedded server)
2.00.48 05-Jun-07
  • Cannot access a disposed object bug fixed (20693)
  • Bug fixed with "JOIN" statements parsing (20788)
  • Now engine is always added in the table DDL (20789)
  • NullReferenceException on submenu popup fixed (20861)
  • NullReferenceException in Security Manager fixed (20862)
  • Class not registered exception on showing Contents window fixed (20860)
  • Bug fixed in Query Builder with changing table aliases from text (20978)
  • NullReferenceException on Undo in stored procedure editor fixed (20979)
  • Incorrect behavior of the AutoHide menu in the Windows menu fixed
2.00.36 07-May-07
  • Stored function and trigger debugging enabled for MySQL server version 5.1.13 and higher
  • Stored procedure compilation bugs fixed. Improper exception handler parsing. (20535, 20537)
  • Breakpoint validation added for stored routines that does not contain debug info
2.00.35 26-Apr-07
  • Bug fixed with debugger hanging on MySQL server under Linux
  • Bug with parsing INT UNSIGNED procedure parameter fixed (20463)
  • Several minor bug-fixes
2.00.34 20-Apr-07
  • Bug fixed with opening tables in Database Explorer. Overflow exception. (20033)
  • Bug fixed with closing document during data fetch (19993)
  • Bug fixed with table dependencies in New Project Wizard (19892)
  • Bug fixed with default values for autoincrement fields
  • Documentation revised
  • Many other bug-fixes
2.00.31 06-Apr-07
  • Stored routines and SQL debugging support
  • Context-sensitive code completion
  • Code navigation and quick info
  • Project support
  • Fully customizable keyboard mapping schemes
  • Completely redesigned Security Manager
  • Table maintenance, flush and server variables support
  • Extended object search
  • MySQL service manager
  • Event object support
  • Session manager
  • Text editor syntax customization
  • Code templates
  • Document outline window
  • Data printing supported
  • Card data view added
  • View data as text feature
  • Pin/unpin document feature
  • Many other improvements
1.51.33 18-Sep-06
  • Bug with dropping current database fixed
  • Bug in SQL document with opening design view if text view is not visible fixed
1.51.32 25-May-06
  • Output overflow bug fixed
  • Bug with storing connection options fixed
  • Bug with opening icon file in LOB viewer fixed
1.51.30 21-Apr-06
  • Large database import improved
1.50.24 26-Jan-06
  • Bug with stop execution fixed (9504)
  • Bug with refresh node after lost connection fixed (8871)
  • CASE WHEN clause supported in parser (9804)
  • Read-only files saving enabled (8470)
  • Minor SQL editor improvements
  • Inserted row is not removed now when apply changes fails (9714)
  • Begin transaction when connection is lost bug fixed (10022)
  • Data window observer mode bug with invalid view fixed (9875)
  • Query builder bug with invalid names in generated text fixed (9805)
  • Bug with trying to use Import(Export) without connection fixed (9985)
  • A few Data view and parameter editor bugs fixed
1.50.23 03-Nov-05
  • Security problems in Generate DDL wizard fixed
  • Bug with default value for autoincrement column fixed
1.50.22 03-Nov-05
  • User and privileges management support
  • Database export/import to/from SQL script
  • Trigger support
  • Script support
  • Stop execution feature
  • Execution of the selected SQL fragment feature
  • Data Export feature
  • Dynamic data viewing of the tables and views in DbExplorer
  • Paginal data access mode
  • LOB viewer/editor
  • Database object search
  • Secure SSL and SSH connections support
  • Query plan tool
  • Duplicate object feature
  • DDL generation wizard
  • Embedded server support
  • Data grid colors customizing
  • Tabbed groups for documents
  • Drag-n-drop files from shell
  • Many other improvements
1.0.5 16-Sep-05
  • Bug with generating text of the stored function parameter list fixed. (7255)
  • Edit PrimaryKey from column editor bug fixed. (8240)
  • Duplicate entry bug on tables having autoincrement fields fixed. (8198)
1.0.4 10-Jun-05
  • SQL editor speed increased.
  • Bug with altering stored procedure on MySQL server 5.0.3 and higher fixed.
1.0.3 19-May-05
  • Bug with "camel-cased" tables on Linux server fixed.
  • Help->Index menu item now points to correct window.
1.0.2 04-May-05
  • Programs menu shortcut changed.
1.0.1 25-Apr-05
  • Documentation in HtmlHelp 1.x format added.
1.0.0 12-Apr-05
  • First release of MyDeveloper Studio.

© 2004-2016 Devart. All Rights Reserved.

www.devart.com

dbForge Studio - менеджер MySQL баз данных

Некоторое время назад я начал пользоваться dbForge Studio for MySQL, программа оказалась очень неплохой, с бесплатной версией для некоммерческого использования и интересными возможностями, о которых я и хочу рассказать. Кроме того, разработчики пошли на встречу и согласились сделать небольшой подарок для всех читателей этого блога, но о нём в конце статьи.

На сегодняшний день существует множество инструментов для работы с MySQL базами данных. Основные возможности, такие как просмотр и редактирование данных, реализованы во всех инструментах, но дополнительные функции отличаются довольно сильно и очень часто именно они экономят наше время.

Условно все программы такого типа можно разделить на два класса: с web интерфейсом и без него (десктопные).

Наиболее известным представителем первого класса является phpMyAdmin. Так или иначе, с ним сталкивались практически все web разработчики. Дело в том, что web приложения для администрирования баз (и не только) очень популярны на shared хостингах, т.к. для работы с базой не нужен SSH доступ и довольно легко устанавливать различные ограничения. С точки зрения пользователей тоже есть положительные моменты:

  • не нужно ничего устанавливать и настраивать на своём компьютере;
  • получить доступ к базе можно с любого устройства, подключённого к интернет;
  • в phpMyAdmin реализованы практически все необходимые возможности (просмотр и редактирование данных, поиск, выполнение SQL запросов, экспорт, импорт и т.д.).

Но, как только вы переезжаете на VPS или выделенный сервер, ситуация меняется. И проблемы в использовании web приложений становятся заметнее:

  1. Ограничения времени выполнения и ресурсов скриптов создают проблемы при экспорте/импорте данных. Т.е. для экспорта/импорта больших баз придётся использовать другие инструменты.
  2. Т.к. приложение доступно из интернета, нужно следить за его безопасностью. В случае VPS или выделенного сервера это полностью ваша проблема, а не хостера.
  3. Не получится работать одновременно с несколькими базами данных, расположенными на разных серверах.

Поэтому в таких случаях использовать десктопные приложения гораздо удобнее.

Подключение к базе данных

Тут очень важно, чтобы была возможность подключиться через SSH. Если её нет, то должны быть другие, очень веские причины для использования такого MySQL менеджера. Конечно, вы можете открыть доступ к MySQL серверу снаружи, но при этом придётся обеспечивать его безопасность (например, создавать списки IP адресов, с которых можно к нему подключаться), а это дополнительная работа.

В dbForge подключение через SSH реализовано, нужные настройки находятся на вкладке «Безопасность».

 

 

Примечание. Скриншоты для этой статьи я сделал с локального сервера, установленного в VirtualBox, поэтому использована аутентификация с помощью пароля. Для рабочих серверов лучше использовать ключи и запретить вход под root’ом.

Основные возможности

Под ними я понимаю: просмотр, изменение, удаление и добавление данных, а также поиск. Т.к. CRUD операции реализованы практически одинаково во всех подобных программах, я просто покажу скриншот из dbForge. Вы выбираете нужную таблицу, и программа покажет информацию о таблице и первые 1000 строк данных. Естественно, вы можете использовать постраничную навигацию, редактировать данные, структуру таблицы, создавать индексы и т.п.

 

Для создания правил фильтрации данных предусмотрен «Конструктор фильтра». Открывается из меню «Данные» -> «Фильтр» -> «Условие...». Конструктор сделан достаточно удобно, есть календарь для ввода дат, выпадающие списки с перечнем полей таблицы и условиями сравнения.

 

В целом, интерфейс достаточно приятный. Но если вы раньше пользовались другими MySQL клиентами, то нужно будет привыкнуть.

Переходим к более «продвинутым» возможностям.

Создание запросов

В dbForge Studio реализовано два режима создания запросов:

  1. редактор SQL;
  2. дизайнер запросов.

Для того чтобы создавать запросы, вы должны хотя бы на базовом уровне знать SQL. В противном случае никакие инструменты вам не помогут. Инструменты могут только сделать работу комфортнее. Например, выделить цветом ключевые слова, добавить отступы и алиасы для таблиц, показать варианты автодополнения. Кстати, автодополнение сделали в dbForge очень удобно (см. скриншот), они сгруппировали списки полей по таблицам.

 

Дизайнер запросов на первый взгляд очень напоминает аналогичный инструмент в Access. Но всё-таки он ближе к SQL режиму, чем реализация в Access. Это хорошо видно по представлению информации на вкладке «Соединения» (я специально показал её на скриншоте). Формат, в котором представлена связь, практически совпадает с записью в SQL режиме.

 

Также есть возможность переключиться в SQL режим и обратно.

Профилирование запросов

Ещё одна удобная функция. Вы указываете запрос, а программа вам показывает вывод

EXPLAIN ...request... SHOW PROFILE FOR QUERY ...

и

SHOW SESSION STATUS;

Всю эту информацию можно получить с помощью обычных SQL запросов, но dbForge позволяет выбрать несколько результатов и сравнить их. Данные выводятся в соседних колонках (показано на скриншоте), которые можно отсортировать по возрастанию или убыванию.

 

Создание диаграмм

Этот режим полезен для разработки структуры MySQL баз. Вы можете либо добавлять новые таблицы на диаграмму, создавать поля и устанавливать связи, либо сформировать диаграмму из существующих таблиц. Последний вариант удобно использовать для подготовки документации и статей для блога 🙂

 

Обратите внимание. При создании связей между таблицами на диаграмме у вас есть возможность получить запрос, который эту связь создаёт. Для этого нажмите кнопку «Скрипт изменений» (показана на скриншоте).

 

Для данного примера вы получите следующий скрипт:

USE workshop; -- -- Изменить таблицу "table2" -- ALTER TABLE table2 ADD CONSTRAINT FK_table2_table1_id FOREIGN KEY (t_id) REFERENCES table1(id) ON DELETE NO ACTION ON UPDATE NO ACTION;

Сравнение баз данных

В идеальном мире эта функция не нужна, т.к. структуры баз данных у всех разработчиков и в продакшене должны совпадать. Многие современные фреймворки поддерживают миграции, предназначенные для удобного обновления структуры баз. Но в реальной жизни получается по-разному 🙂 поэтому возможность быстро сравнить две базы совсем не лишняя и может сэкономить много времени.

Результаты сравнения в dbForge Studio выглядят следующим образом

 

Как видите, в данном случае в БД, которая расположена справа, отсутствует таблица wp_td_terms и используется движок MYISAM вместо INNODB.

Также можно сравнить и содержимое баз.

Резервное копирование и восстановление данных

Ради эксперимента я создал копию базы размером около 800 МБ. Процесс прошел довольно быстро и без ошибок. При создании копии можно указать множество настроек, например, заблокировать таблицы и т.п.

 

При восстановлении нужно только правильно указать кодировку дампа.

Также есть возможность экспорта данных в разные форматы, вроде CSV и XML.

Создание отчётов

Это ещё одна возможность, которая сильно напомнила Access. Отчеты создаются с помощью мастера, который предлагает либо использовать существующие таблицы, либо создать запрос. Также предлагается выбрать вариант оформления, группировку и сортировку. После завершения работы мастера открывается дизайнер отчета в котором можно сделать окончательные настройки.

 

Результат можно распечатать или экспортировать в один из поддерживаемых форматов (HTML, XLS, JPEG, PDF).

 

Заключение

В этом обзоре я останавливался в основном на возможностях, которые показались мне наиболее интересными, и доступны в версии для некоммерческого использования. А вообще dbForge распространяется в трёх редакциях: Express, Standard и Professional, которые отличаются ценой и набором поддерживаемых функций. Сравнить их можно здесь. При этом использование любой из версий упрощает MySQL разработку.

Подарок

Специально для вас компания Devart предоставлет 20% скидку на продукты линейки MySQL версий Standart и Professional.Для того, чтобы ей воспользоваться, при заказе товара введите промо код

simplecoding

Промо код действителен до 20.11.2014.

Успехов!

www.simplecoding.org


Смотрите также