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

Read the rest of this entry »

What’s New in Devart Excel Add-ins 1.7

Posted by on March 20th, 2018

We proudly announce the release of Devart Excel Add-ins 1.7 — add-ins for Microsoft Excel that allow connecting Excel to cloud and database data, edit this data, and save it back to the data source. The new versions of Devart Excel Add-ins allow much more convenient and flexible editing and refreshing cloud and database data.

Advanced Edit Mode

Excel Add-ins 1.7 present a completely new advanced Edit Mode, eliminating a lot of previous limitations. Now you can freely copy and paste data in the Edit Mode, including pasting multiple rows, and copying data in the same workbook and worksheet with the imported table.

The new Edit Mode allows you to use many Excel editing features, like formulas, scripts, AutoFill, etc. It allows sorting and filtering of the table with imported data, hiding and unhiding columns, allows editing data outside of the imported table on the same worksheet, etc.

Read the rest of this entry »

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.

Read the rest of this entry »

Devart presented EntityDAC at this year’s Coderage XII conference

Posted by on November 14th, 2017

Devart was pleased to participate in the annual online conference for Delphi developers – Coderage XII organized by the Embarcadero company and held on November 7-9, 2017.

During the session, we presented the solution how using ORM for Delphi – EntityDAC can simplify and speed-up the application development process. In our presentation, we used real samples, as well as other Devart products (UniDAC, dbForge Studio for Oracle) to clearly demonstrate this.

Read the rest of this entry »

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.

Read the rest of this entry »

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.

Read the rest of this entry »

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.

Read the rest of this entry »

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.

Read the rest of this entry »

Fast and simple database application development and deployment to Linux in RAD Studio

Posted by on April 20th, 2017

The Devart company released UniDAC with support for Linux 64-bit platform. UniDAC makes application development and maintenance easier and simpler because the use of the Direct mode in a custom application does not require the installation of client libraries, additional drivers, etc. This helps to avoid the overhead when accessing a DBMS, hence increasing performance.

So, in this article, we will demonstrate the capability of UniDAC to establish a connection to various DBMSs in the Direct mode:

  • ASE
  • DBF
  • MongoDB
  • MySQL
  • Oracle
  • PostgreSQL
  • SQLite
  • SQL Azure
  • SQL Server

Read the rest of this entry »

How to retrieve data from Dynamics CRM to MS Access using ODBC

Posted by on March 6th, 2017

Custom relational management is very important once you run a business. It helps to improve marketing strategy, sales and customer service. Today there are many systems providing Cloud-based CRM services on the market. The main benefits of using these systems are scalability, costs, and integration with commonly used office applications (e.g. MS Excel, Access and others).

MS Dynamics is one of the most popular CRM platforms in the world. The system offers a wide range of CRM applications for any business. Using such services will be beneficial for manufacturing, wholesale, financial and IT areas.

As well as Dynamics CRM system, MS Access is a good choice for any business, by virtue of the fact that it can handle external data from various sources. It also provides a possibility to open, modify and update cloud-based databases. But what can connect Dynamics and Access when we need to retrieve data?

Read the rest of this entry »