Blog

dbForge Team

MySQL Documenting Has Never Been Easier!

Posted by on April 18th, 2018

We just love to make our users’ life a bit easier. This time, we are excited to treat you with a brand new addition to our dbForge for MySQL product line, – dbForge Documenter for MySQL. The tool automatically generates documentation for multiple MySQL and MariaDB databases in the HTML, PDF, and MARKDOWN file formats and allows customizing the generated documentation with help of a rich set of options and settings.

Our team has done its best to make the new MySQL documentation tool fast, productive, simple, and good-looking. Now it’s your turn to try it out! (more…)

Reinvented dbForge Tools for MySQL Have Arrived!

Posted by on April 12th, 2018

After a grand update of dbForge Studio for MySQL, we haven’t forgotten about the rest of the dbForge for MySQL product range. Our developers took maximum care of each and every MySQL tool and revamped them with specific new features and updates. All the tools have been enhanced with the cutting-edge connectivity and compatibility options which means you can work with a greater number of databases and database engines. Also, we have implemented a new activation mechanism to ensure that our users can use the tools with all possible security and reliability. (more…)

No one has ever imagined dbForge would do it to Google Sheets!

Posted by on March 27th, 2018

”Wow!’, ”Cool!’, “Fantastic!”, “A revelation!” – this was the first reaction of our colleagues when we presented fresh dbForge Studio for MySQL, v7.4 to them. Indeed, our team has done a huge work in to meet our customers’ needs and expectations. In a bid to fulfill this objective, we have enhanced our renowned MySQL GUI tool with the most timely and essential features, improvements and updates. And now, we are eager to unveil all these awesome additions to dbForge Studio for MySQL to you. The list turned out to be quite impressive and long, but believe us, it is worth at least looking through. To put the story short, let’s start!

(more…)

Meet the most anticipated client for PostgreSQL developers ever!

Posted by on March 20th, 2018

Devart always pursues better ways to meet the needs of our customers. We have already developed such excellent tools as dbForge Studio for SQL Server and dbForge Studio for MySQL. Our IDEs are famous for their unified and intuitive user interface that resembles the Microsoft Visual Studio interface and maintains its similar standards. Therefore, many users do not have to learn again when switching between databases on different servers.

Now, we set a new goal – to create a new powerful IDE, dbForge Studio for PostgreSQL, for working with PostgreSQL databases that will make the development, management, and editing process enjoyable and easy.

In this version, we are glad to introduce the following keys features:

  • SQL document with prompts that boost your coding productivity
  • Object Explorer with expandable objects
  • Data Editor with the spreadsheet like data editing similar to Google Sheets and MS Excel

(more…)

What’s New in dbForge SQL Complete v5.8

Posted by on January 31st, 2018

dbForge SQL Complete for SQL Server receives improvements on an ongoing basis. To stay up to date with the most recent developments, this article provides you with information about:

  • New features
  • Ongoing updates
  • Bug fixes

This topic includes release notes for version 5.8.

(more…)

How to Compare Multiple Databases through Command Line

Posted by on August 30th, 2017

Very often, there is a need to compare or synchronize data between two databases on the same server. To detect differences, you can simply use dbForge Data Compare for PostgreSQL, which allows you to perform this process with a few clicks. However, what if we need to compare data of multiple target and source databases located on different servers?

This post describes the way to compare multiple databases on different servers through the command line.

(more…)

How To Import a .CSV file through the Command Line

Posted by on August 14th, 2017

In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio for MySQL.

You will not have to waste your valuable time on manually specifying properties each time you need to create a new MySQL table. With this option, you can forget about going through this process over and over again. Instead, you can import data by creating a template based on the .csv file fast and in a few clicks.

(more…)

How to automatically generate SQL Server documentation

Posted by on November 2nd, 2016

In this blog post, we will learn how to quickly create a comprehensive documentation of an SQL Server database using dbForge Documenter for SQL Server, a database documentation generator from Devart.

There are a lot of benefits you get when generating database documentation automatically using dbForge Documenter for SQL Server. You don’t have to spend hours retrieving and writing technical information from scratch. Documenter builds an accurate and error-free documentation in just a few minutes. Besides, the documentation tool from Devart provides a rich set of features for customizing documentation output to meet your specific requirements.

Documenter presents documentation in an easy to view format, so you can share it with your boss or clients, other developers, DBAs, testers, project managers, business executives or other related persons.

The following example demonstrates how to generate documentation for the AdventureWorks2012 sample database.

(more…)

SQL Server 2016 Stretch Database

Posted by on July 12th, 2016

SQL Server 2016 Stretch Database

On June 1, SQL Server 2016 was released. It brought a large number of novelties into normal development, including the long-announced Stretch Database technology that allows migrating data from SQL Server dynamically to Azure.

From the marketing point of view, Stretch Database has been well promoted. Reasonable arguments were stating that with the growth of historical data the complexity and cost of its maintenance grows as well. As a rational solution to the problem, the automatic migration of obsolescent archival data to the cloud was introduced. Frankly speaking, I enjoyed the idea.

As from SQL Server 2016 RC0, I began testing the Stretch Database technology on two projects I’m helping to develop. The first one is TMetric, a free time tracker with OLTP load, and the second one is an internal project with DW load.
(more…)

Find invalid objects in your databases

Posted by on January 4th, 2016

DBA has a number of duties that are primarily targeted at supporting of database performance capabilities and data consistency. The administrator can use the CHECKDB command to easily verify the data consistency; however, in case they need to find an invalid object in a database schema, some difficulties may occur.

ORACLE for instance, allows you to get a list of invalid objects:

SELECT owner, object_type, object_name
FROM all_objects
WHERE status = 'INVALID'

SQL Server doesn’t allow to do that directly. In most cases, you need to execute a script to see that an object is invalid. This is very inconvenient…
So let’s create a script that will search invalid objects: (more…)