How To
How to automatically synchronize data in two SQL Server databases on a schedule
Data in SQL databases often needs to be synchronized in real time – this can be achieved by checking one database for updates and...
How to Work With dbForge Studio for MySQL on macOS Using Parallels Desktop
Many database professionals use Mac for their daily work. Devart is going to develop its software products for Mac platform in future. But for...
How to Compare Multiple Databases From the Command Line
Very often, there is a need to compare or synchronize data between two databases on the same server. To detect differences, you can simply...
How To Import a .CSV file through the Command Line
In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio...
How to retrieve data from Dynamics 365 to MS Access Using ODBC
Custom relational management is very important once you run a business. It helps to improve marketing strategy, sales and customer service. There are many...
How to import data to Excel using ODBC
In this article, we will discuss how to access data using ODBC driver in Microsoft Excel. We will examine in detail the data retrieving...
Use VirtualDataSet to Access Objects List via TDataSet Interface
TVirtualDataSet is a virtual dataset that can be used as an intermediate between data stored in an application and data-aware controls used in forms....
Installation & Configuration of Devart ODBC Driver for QuickBooks
The article describes installation and configuration of Devart ODBC Driver for QuickBooks on Windows, as well as authorization and connection to a QuickBooks...
Tidy SQL with SQL Complete
In this article, we will talk about how to keep SQL code clean and highly readable. We will also discuss how to stop suffering...
Migrating Entity Framework 6 projects to Entity Framework Core 1 (EF7)
For the purpose of this tutorial, we will use a test project from the "Entity Framework 6 Support for Oracle, MySQL, PostgreSQL, SQLite, DB2,...
