Devart Blog

dbForge Team posts

Devart was the sponsor of SQLSaturday #660 at Lviv

Posted by on September 8th, 2017

Devart was a sponsor of SQLSaturday#660 held on August 19, 2017, in Lviv, Ukraine.

We were very glad to take part in this event, talk to users of our products, make new acquaintances and support our Ukrainian SQL Server community.

We would like to thank the organizers of the event: Sergey Lunyakin, Andrey Zrobok, Oleg Deyneko, Marina Lunyakina and volunteers for organizing SQLSaturday Lviv and the opportunity to be a part of the event.

(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…)

Devart was the Gold Sponsor of SQL Saturday #616

Posted by on May 31st, 2017

SQL Saturday #616 was the biggest training event for SQL Server professionals and those wanting to learn about SQL Server in Ukraine. The event was held on May 20, 2017, in Kiev, Ukraine.

We would like to thank the organizers of the event – Denis Reznik, Eugene Polonichko, Eugen Niedaszkowski, Alesya Zhuk, Nick Pobyivovk, Oksana Tkach and Oksana Borysenko, as well as all speakers for the remarkable event!

We highly appreciated the opportunity to share thoughts and ideas, discuss challenges as well as to present our software products to the professional community.

(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…)

Devart Took Part in the Kharkiv International Marathon

Posted by on April 14th, 2016

Devart team took part in the 3rd Annual Kharkiv International Marathon, that took place on April 9, in city of Kharkiv, Ukraine.

Gorgeous sunny weather, wonderful organization and cheerful atmosphere helped our runners to get through both, 4.2K ad 10K runs and finish with pretty good results.

(more…)

IT NonStop 2015 – Kharkiv (Ukraine)

Posted by on December 4th, 2015

The international IT conference IT NONSTOP was held in Kharkiv (Ukraine) on November 28, 2015 and gathered a lot of enthusiastic participants.

A speaker of the conference, Syrovatchenko Sergey (SQL Server DBA / DB Consultant from Devart) talked to the participants of the conference about the «Mortal sins in the development on SQL Server». Here is a brief of his report:

“When people start to deal with something new, they pass though thorny path of trial and error. In my report, I tried to give a list of “traps” I got in many times when I’d just started working with SQL Server. Typical errors relating to filtering values, implicit type conversion, and the proper use of indexes were briefly discussed…”

Awarding dbForge Studio license during the event was a pleasant bonus.
(more…)

How to generate SQL Linked List Data with Python Generator

Posted by on November 30th, 2015

In this post, we would like to show how to quickly generate table values that are based on the values of another column of same table. For this purpose, we will use the Python Generator being a part of dbForge Data Generator for SQL Server.

First, let’s create a test table using the following script:

CREATE TABLE [dbo].[TestLinkedListTable](
[id] [int] NULL,
[name] [nchar](100) NULL,
[previous_id] [int] NULL,
[next_id] [int] NULL
)
GO

(more…)

Devart was the Bronze Sponsor of SQLSaturday #416 – Odessa 2015

Posted by on July 27th, 2015

Devart was a Bronze sponsor of the 416th edition of SQLSaturday, that was held on July 25, 2015 in Odessa, Ukraine.

We would like to thank the organizers of the event – Anton Vidishchev, Oleg Chorny and Alex Tumanoff, and all speakers for the remarkable event! We highly appreciated the opportunity to share thoughts and ideas, discuss challenges as well as to present our software products to the professional community. (more…)

SQL Complete Enhanced Functionality

Posted by on July 16th, 2015

While working on the new version of SQL Complete, we focused on adding the most needed features discussed on Devart’s uservoice site – devart.uservoice.com. Here, users leave their feedbacks regarding any of the Devart’s products as well as vote for new features to be added. Thus, we do our best to address user needs for most desirable functionality. This is an early preview of the upcoming functionality that will be available in SQL Complete v5.0!

In this article, we will discuss newly added features that will speed up and simplify SQL code writing. (more…)