dbForge Team Blog

Introduction

MySQL Server (starting from v 5.0), as Oracle and SQL Servers, allows creating stored procedures and functions.

Stored procedures are a set of SQL commands that can be compiled and stored on the server. Thus instead of storing a frequently-used query, we can refer to a corresponding stored procedure. This provides better performance (as this query is analyzed only once) and reduction of traffic between client and server.

While developing business logic of procedures, we often use a great number of variables (e.g., temporary outputs) to store. To assign static values to a variable or values of other variables, SET operator is used. SET operator in stored procedures is an extended version of usual SET operator. This allows using extended syntax SET а=х, Ь=у, where different variables types (local and server variables, global and session ones) can be mixed.

Problem

(more…)

Dear users,

Devart Development Team has released today a new build 3.50.305 of dbForge Studio for MySQL, which includes the following bug fixes:

(more…)

Why not distract your attention from usual database development and facilitate your work with projects?

Let’s inspect the reasons why you should:

(more…)

It was long ago observed that efficiency of code depends on its appearance. Good code is usually readable and quickly understood by colleagues. Of course, code formatting won’t speed up the execution of your queries, but will definitely simplify finding the errors and prevent ambiguity.

Make your code standards-driven and clear for other people using formatting functionality of dbForge Studio for MySQL. Based on your needs, you can benefit from 3 types of formatting:

(more…)

Need more confidence in comparing and synchronizing schemas? Find where the secret lies.

Read the updated article “The Basics of Qualitative Schema Comparison” and do it yourself.

In the article:

• Convenient Setting Up of Comparison Parameters
• Easy Handling of Schema Differences
• Safe Schemas Synchronization

Moreover, learn how to compare a schema and a database project, understand the compared results, reduce time ..

Forget tedious hours of searching links to the renamed object and replacing them.

To save your efforts, dbForge Studio for MySQL automates renaming of objects:  tables, columns, views, aliases, stored routines, local variables, triggers, events, UDFs, and users and even offers a convenient preview of the changes before applying them.

To rename an object in the script, right-click it and select the Rename option from the menu. The Rename dialog box opens where you can enter a new name and view all references to the renamed object in the expressions, strings, and even comments.

All you have to do is to select required references and press OK!

The refactoring functionality is indispensable while working with database projects. You can export a database to a project, rename objects and references in multiple project files, and synchronize the project with the database.

So “…take arms against a sea of troubles, And by opposing end them…” using automatic renaming!

Enjoy!

Of course, it’s just a joke, but in every joke there is a grain of joke. Remember how many times you wished you never saw Database Explorer again, switching from the SQL script each time to view a required database object. It is really inconvenient to search database objects mentioned in the script using Database Explorer.

Your way out is one-click access to definitions of schema objects and variables from the script. Right-click an object in your code and select the Go to definition option (default shortcut F12) from the menu.

The object editor or a corresponding DDL script will open in another window.

Use the same option to navigate to a required object or definition within a script. For example, you will breathe freely moving with lightning speed to alias declarations in complex expressions or to object declarations in the script. For speedy navigation in large scripts use the Navigation bar at the top of the document or the Document Outline window.

Devart has released today the improved version 1.10 of dbForge Schema Compare for SQL Server, a sophisticated tool specially designed to meet your specific comparison tasks, help analyze schema differences at a glance, and synchronize them correctly, saving time and efforts.

dbForge Schema Compare for SQL Server 1.10 features the following enhancements:

(more…)

Recently, one of our customers asked us how to synchronize large databases if the size of the generated synchronization script couldn’t be opened by dbForge Data Compare for SQL Server for editing. He tried to synchronize his large database, but the generated synchronization script (Table Data Update Script of all tables) was of a great size, so the program could not open it and recommended direct execution. However, the user wanted to review the script and edit it before execution.

Such cases are quite common, so here is the solution we recommend.
If you have a big database, synchronize it in three stages:

(more…)

Dear users,

Devart has released today dbForge Schema Compare for MySQL 1.00 – a special advanced tool for modern comparison and synchronization of MySQL databases. dbForge Schema Compare for MySQL 1.00 meets the needs of both database administrators and developers to automate and simplify the diversity of tasks related to updating and migrating of MySQL databases.

Being part of dbForge Studio for MySQL, a company’s bestseller product for MySQL database administration and development, the functionality of dbForge Schema Compare has met approval of many DBAs and developers.

Speed, simplicity, and safety

As a modern MySQL database management tool, dbForge Schema Compare is based on the solid cornerstones vital for smooth updating and migrating of MySQL databases. They are speed, simplicity, and safety.

The new product provides database administrators and developers with capabilities to quickly compare databases regardless of their structure or MySQL server version. It reduces the intensive hours of schema differences management to minutes and guarantees quick databases synchronization without errors and program misoperation.

dbForge Schema Compare has passed hundreds of usability tests to simplify schema comparison and deliver the clear display of comparison results listing object differences in the grid and showing their DDL differences under the grid. Multiple options for quick sorting, filtering, and search of schema differences ensure easy management.

In modern fast-pace environment safe and error-free schema synchronization is one of key points. dbForge Schema Compare generates a standards-driven synchronization script to guarantee the smooth synchronization. Prior to the script generation, a preview of the synchronization script for every compared schema object is available.

Main product features include:

(more…)