Devart is glad to announce the release of dbForge Data Compare for PostgreSQL — a powerful and easy-to-use tool for table data comparison and synchronization. This tool allows you to review all the differences in compared tables and execute an automatically generated script to remove these differences. Customizable comparison and synchronization process allows you to select tables and fields for comparison and adjust many comparison options. User friendly wizard, guides you through the data comparison and synchronization process step by step. A possibility of using Windows Task Scheduler enables you to automate database synchronization process.

The key features of Data Compare for PostgreSQL include the following:

Flexible customization of database object mapping. Data Compare for PostgreSQL allows you either automatically or manually map schemas, tables, views, columns. You can use custom mapping to map schemas or database objects that can not be mapped automatically.

Comfortable view of data differences. Processing data comparison results is easy and quick, as they are displayed in a convenient way in the Data Comparison document. Database objects can be filtered by the differences.

Full control over data to synchronize. After comparison you can easily exclude tables or individual records from synchronization.

Easy to use Data Synchronization wizard. Data Synchronization wizard enables you to customize synchronization settings. You can backup target database before synchronization. Generated synchronization script can be immediately applied to the target database or saved in a file.

Warnings of possible data loss and various notifications. Before synchronization you will be warned if errors or data loss may occur because of types incompatibility. Also you will be notified about data overflow, roundings, etc.

Large script execution. dbForge Data Compare for PostgreSQL allows you to execute large scripts without opening script in the SQL editor and loading the whole script in memory. When you try to open a large script, you will be prompted to execute it instead with the help of the Execute Script Wizard.

Compare and sync data via command line. You can compare and synchronize data via command line. There is no need to open the application and go through the wizard pages any more.

Friendly GUI. Data Compare for PostgreSQL provides a self-intuitive user interface, so you will quickly learn how to use the product to your advantage.

Enhanced working with data. You will get new opportunities for analyzing and processing received data the best way:

• Group, filter, and sort data in the grid
• View data rows as neat cards
• Display data in the paginal mode
• Find the required data using the auto-search mode

Download dbForge Data Compare for PostgreSQL and see the benefits.

Some of our users have faced the situation when they need to change the connection details of the existing Database Diagram file.

Let’s assume the situation when you have several databases with identical schemas which are only located on different MySQL servers and you have created a database model that was saved in a Database Diagram file. Now, you want to avoid redesigning the database model from scratch and only reassign the existing database model to another MySQL server.

Here are some steps you can follow to achieve this:

1. Create a database diagram.

2. Arrange objects on the diagram so you can easily read them (create containers, notes, etc).

3. Save the diagram and close dbForge Studio for MySQL.

4. Open the Database Diagram file using a third-party text editor, for instance, notepad.

Open Database Diagram as XML

5. Find the <Connection></Connection> tag that may look as follows:

...
<Connection>
    <Name>MyConnectionToDB</Name>
    <ConnectionString>User Id=root;Host=db;Port=3310;Database=sakila;Ping Interval=120;Character Set=utf8;</ConnectionString>
</Connection>
...

and make the following changes:

...
<Connection>
    <Name>new_connection_name</Name>
    <ConnectionString>User Id=new_user_id;Host=new_host;Port=new_port;Database=new_db_name;Ping Interval=120;Character Set=utf8;</ConnectionString>
</Connection>
...

i.e. modify the <Name></Name> tag (change it to something different) and the <ConnectionString></ConnectionString> tag (connection details for another server).

6. Find all the <DbOid></DbOid> tags that may look as follows:

...
<DbOid>
    <Path>sakila.actor</Path>
    <TypeName>Table</TypeName>
</DbOid>
...

and change the database name to the new one:

...
<DbOid>
    <Path>new_db_name.actor</Path>
    <TypeName>Table</TypeName>
</DbOid>
...

Make sure you specify the new database name in the same letter case as it exists on the server.
7. Save the modified file with the new name.

Now, you have a new Database Diagram file adjusted to another server.

NOTE: The article applies to dbForge Studio for MySQL, dbForge Studio for SQL Server, and dbForge Studio for Oracle.

Devart proudly presents dbForge Studio for SQL Server — a new set of SQL Server tools for database developers and administrators.

All users who have used our previously elaborated solutions (such as SQL Complete, Data Studio, Schema Compare, Data Compare and Query Builder for SQL Server) can now benefit from having them at hand in a single integrated development environment.

A new GUI tool by Devart for SQL Server is ready.

Product Editions

Studio for SQL Server comes in 4 editions so that each user could decide which set of tools meets their requirements best:

• Free Express edition provides 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 is a fully-featured edition that provides additional functionality
• Data edition includes all the functionality of the discontinued Data Studio for SQL Server

dbForge Data Studio for SQL Server has been discontinued and become the Data Edition of the Studio (that’s why the new product inherits Data Studio’s versioning — 3.0)

Not only have we integrated the existing products into one, but also added a number of new features.

Major New Features

• Table Designer that allows to:
  • Set table properties in the visual editors
  • Edit a script that creates the table
  • Rebuild tables when complex changes are introduced
  • Preview changes before modifying a database object
• Database Diagram for when you need to get a quick look at the database structure. It provides:
  • Visual editing, easy manipulation and scaling
  • Containers for grouping objects
  • Printing large diagrams
  • Virtual connections
• T-SQL Debugger A must-have tool for building server-side logic. Being integrated into the stored procedure editor it allows to start debugging by clicking on the Database Explorer tree
• Query Profiler to locate bottlenecks and optimize slow query execution time with many advanced options unavailable in a standard tool
• Security Manager that incorporates visual editors for logins, users, and roles; batch object editing, etc.

Availability

Consumers can give dbForge dbForge Studio for SQL Server 3.0 a test drive by downloading the 30-day trial Professional edition at the product download page. dbForge Studio for SQL Server 3.0 price starts at $149.95.

Tell us what you think about the new release, on the dbForge Studio for SQL Server feedback page. We are looking forward to your comments and suggestions!

Some of our users have encountered problems with establishing a connection over the tunnel.php script despite the fact that the tunnel.php script is installed correctly. The following error message occurs:

‘Can’t connect to MySQL server on ‘your.sitename.com’ (10061): Authentication failed.’

The problem appears to be with cached proxy servers and will be fixed in one of the next builds of our product.

Currently it can be fixed by replacing the dbforgemysql.exe.config file, that can be found in dbForge Studio for MySQL installation folder, with the attached one.

Devart Team is glad to announce the new release of SQL Complete v3.5. It includes support of all versions and editions of SQL Server, column picker, extended T-SQL syntax support and many other features.

In the new version, we’ve made a huge effort to improve usability of our Intellisense and paid a lot of attention to the application quality in general. Together with the new features, meet new look of the suggestion list and new level of the usability of our application!

New features

• Support of SQL Server 2012 and SQL Server Compact Edition As support for the new version of SQL Server was introduced together with full support for Compact Edition, developers got an opportunity to use the advanced SQL Intellisense functionality with any server version and edition, starting with SQL Server 2000 and up to SQL Azure.
• Column picker feature New functionality will make it possible to create SELECT and INSERT queries, as it allows defining column lists for selecting, grouping, sorting and inserting without typing any code at all. The suggestion list appearance was changed – now it supports hierarchical view for table columns and shows information about data type.
• Intellisense in SQLCMD mode Scripts that are executed with the help of the command line utility, are usually parameterized. But often it is the reason of the fact that ability to show correct suggestions for objects is lost, because database or schema name can be a variable. Now SQL Complete solves this problem. Values of variables are taken from the text of the document and object suggestions work as with an ordinary SQL script.
• Automatic formatting of keywords on typing Keywords are formatted according to the option settings. This will help to avoid appearance of keywords written in different registry, when part of them was inserted from the suggestion list and part was typed manually.
• Extended and revised SQL Snippets We’ve revised existing code templates, added new ones, and changed the behavior of the suggestion list on selecting a template. This will allow choosing the needed template as quickly as possible and reducing time needed for typing recurring code constructions. Also keep in mind that users can create their own SQL snippets with the help of the special editor.
• Extended T-SQL syntax support Context-sensitive prompt of objects in the MERGE statement and a number of SQL Server 2012 T-SQL construction is supported.
• SQL formatting improved Formatting of procedure and function code, CASE statements, comments, and column list inserted on wildcard expansion is improved.
• Express edition feature set extended The free Express edition of our product is also improved. Now it supports SQL Server 2012 and SQL Server Compact Edition. Besides, information on columns is expanded, and hierarchical list structure that simplifies working with SELECT and INSERT statements is also available in the free edition.

Read more: SQL Complete is ready for SQL Server 2012 now!

Since one of our users has encountered a problem when modifying data via Data Editor, we decided to bring such a situation to our users’ attention.

Let’s assume you have the following table:

CREATE TABLE dept(
  DeptNo INT(10),
  DName VARCHAR(14),
  loc VARCHAR(13),
  Salsum FLOAT
);

Let’s execute the following query in the SQL document:

SELECT DName, loc FROM dept WHERE DeptNo = 20;

Now if you change any of the values of the first record in Data Editor, the changes will be applied to all records of the original table that have ‘DName’ = ‘Research’ and ‘loc’ = ‘Dallas’.

It happens because when dbForge Studio for MySQL generates the internal UPDATE statement, only the fields returned by the previous query are included in the WHERE clause of the UPDATE statement. In our example DeptNo = 20 that was stated in the WHERE clause of the SELECT statement was not included in the internal UPDATE statement as there was no the ‘DeptNo’ field in the grid when modifying data.

So that if you’re planning to modify data that will be returned as a result of the SELECT statement in the grid, we suggest you to make sure that all the fields that are specified in the WHERE clause of the SELECT statement are also specified in the SELECT clause of the statement.

In our example, you have to specify the ‘DeptNo’ field in the SELECT clause of the statement.

SELECT DeptNo, DName, loc FROM dept WHERE DeptNo = 20;

Now if you modify any of the values of the records in Data Editor, the above actions will exclude accidental changes in the records that are not displayed in the grid.

Finally, to avoid such problems that may occur when modifying data that was returned as a result of the ‘SELECT’ statement inside of which the ‘WHERE’ clause is used, make sure you’re specifying the ‘*’ in the ‘SELECT’ clause or at least all the columns listed in the ‘WHERE’ clause of the statement.

Merry Christmas and Happy New Year!

As Christmas holidays are drawing closer, we offer you to get 20% off any product license order.

Don’t think twice, just save 20%. And what more, you get free access to all future releases of the respective products for one year.

Hurry up, this offer is available only from December 01, 2011 till January 10, 2012. Decide and order right now.

We wish you all the best in the coming year, let joy and happiness be your constant partners and friends!

Best Christmas Wishes,
Devart Team

We’ve analysed user feedbacks received after the release of the completely redesigned dbForge Studio and defined prior points for further development of the product.

As a result we’ve devoted the new release of dbForge Studio for Oracle to improving the possibilities for users who work with PL/SQL code and data. And in addition we’ve improved the application performance and added support for Win-x64 platform.

dbForge Studio for Oracle v3.1

New Features

• 150 improvements in the code autocompletion system
  We’ve made nearly 150 changes and improvements in the dbForge Studio for Oracle component that helps users edit PL/SQL code. Among them:
  • Oracle SQL and PL/SQL syntax support is expanded
  • Work of quick info hints for schema objects is improved
  • Keywords case is changed automatically on typing (if the corresponding options are set)
  • Usability shortcomings and errors are fixed
• SQL document works with additional PL/SQL file types:
  • Support for editing .pls, .plb, .pks, .pkb, .pck Oracle PL/SQL files is added
  • Support for editing files with PL/SQL code created in some competitor products is added
• Data export to SQL statements
  • Possibility to export data to INSERT, UPDATE, DELETE, and MERGE statements is added
  • Data can be exported from a table or data grid using a wizard
  • Quick export from data grid without opening wizard
• Convenient work with result sets of several SELECT queries
  If there is more than one SELECT statement in a document, after execution query results will be displayed on separate tabs in the Data window.Such approach allows working with each data set independently.
• Editing data of object fields
  The new product version provides possibility to edit data in object fields in tables using a pop-up editor.
• Support for editing temporary tables
  There is a capability to create and edit temporary tables in Table Editor.
• Document Outline window for code navigation is improved
  • Grouping nodes by IF, FOR, etc. flow-control statements blocks is added
  • Displaying labels and navigation among them is added
• More convenient working with query execution plan
  • Quick query plan obtaining (without turning the Profiling mode on) is added
  • Displaying of the EXPLAIN PLAN results without creating an additional table in the user’s scheme is added
• Performance improvements
  • Time required on application startup and connection opening is reduced
  • Building of the Database Explorer tree, refreshing it, and receiving table list is quicker now
  • Getting metadata for code completion becomes faster
  • Work of Schema Export with large amount of objects and data is improved
  • Data Editor working speed is increased
  • Object Viewer and Property Browser windows working speed is increased
  • Navigation to schema object editors from code is improved
• Win-x64 Native Support
  Now the application does not require 32-bit Oracle client software installed when working with 64-bit Windows operating system – the application works with 64-bit Oracle client software.

Availability

Consumers can give the updated dbForge Studio for Oracle a test drive by downloading the free Express edition or the 30-day trial Professional edition at the product download page. dbForge Studio license price starts at $149.95.

To leave feedback, users can go to the dbForge Studio for Oracle feedback page. The Devart team is looking forward to receiving any comments and suggestions.

Devart Team is glad to announce the new release of SQL Complete v3.1. The new version includes some improvements in both Standard and free Express editions to make your work easier, more effective and convenient.

SQL Complete SSMS add-in

New Features

• Linked servers support The new version of SQL Complete features support for IntelliSense when working with linked servers. Just imagine – now you can type your queries with the kind of IntelliSense you are accustomed to even when using all advantages of linked servers configuration!
• SQL statements support extended Standard edition provides support for GRANT, REVOKE, DENY, ENABLE/DISABLE TRIGGER, and ALTER SCHEMA statements.
• New Highlight Occurrences option The new option allows you to turn highlighting of occurrences on and off. Besides, all existing options were rearranged to improve product’s usability.

Improvements

• Usability of code completion improvement We revised rules for showing suggestion list especially when editing existing SQL queries. Now the suggestion list does not appear for arithmetic operations, numbers, and semicolons.
• Installation process customization We improved the product’s usability basing on users’ requests. Now you can select the development environment in which SQL Complete will function when installing the add-in – just select the needed environment from the list of available environments on a special page of the installation wizard.
• Tracing support We added tracing support for you to help us find and fix errors in our application – if you encountered any problems with SQL Complete, start tracing and send the created file to Devart afterwards.

Express Edition Extension

• SQL statements support extended Support for DROP, EXEC, DECLARE, and SET statements was added.
• Variables and parameters support
• Qualify Column Names option is available

Availability

Consumers can give the updated dbForge SQL Complete a test drive by downloading the 30-day trial Standard edition at the product download page. SQL Complete’s Standard edition is available for an estimated retail price of $99.95.

If you don’t need advanced code completion features but want to get more than SSMS IntelliSense can give, you are welcome to try free Express edition.

To leave feedback, users can go to the dbForge SQL Complete feedback page. The Devart team is looking forward to receiving any comments and suggestions.

Introduction
Debugging SQL code is a very important task these days. Unfortunately not all database servers support this feature. And MySQL is one of such servers. In spite of its wide feature set, debugging is not implemented in it. So the problem is that MySQL provides no API functionalities for code debugging. But the necessity to debug SQL code does not disappear and becomes more and more important each year. Some companies that develop tools to access data of MySQL server databases create their own debuggers that solve this problem to some extent.

Types of Debuggers
Now we will consider the types of debuggers that can be implemented for MySQL server and principles of their work.
Read more: MySQL Debugging Methods Overview