Devart Blog

command line

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 Email Comparison Report

Posted by on September 9th, 2014

dbForge Studio for MySQL allows you to automate report creation process by using command line utility. There is a simple way to send comparison reports automatically via email.

To accomplish this task we will use the Collaboration Data Objects (CDO), previously known as OLE Messaging or Active Messaging. CDO is an application programming interface included with Microsoft Windows.

Below is the simple BAT file that automatically saves a comparison report in the HTML format on the “D:\\” drive and runs the send.vbs script file.

call “C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.com” /datacompare /compfile:d:\project.dcomp /reportformat:HTML /report:d:\report.html
start send.vbs

(more…)

How To: Setup Daily MySQL Backup on Windows

Posted by on August 4th, 2010

Protecting information in databases and possibility to restore databases in case of need is the highest priority task in many companies. But not all DBMSs have built-in tools for data protection (tools to backup and restore databases). And MySQL is one of such DBMSs.

Making database backups is one of the most important things in the process of administrating MySQL databases, because some critical data loss can be irreplaceable.

The task of making daily mysql backup can be solved with the help of the backup database function of dbForge Studio for MySQL. To use it, you should setup backup in the wizard manually and schedule making backups.

(more…)

Synchronizing data between a company database and a data warehouse

Posted by on April 15th, 2010

Recently we’ve received a question from one of our customers asking how to synchronize data between companies servers and a data warehouse server. Let’s see how easy it can be done with the help of  dbForge Data Compare for SQL Server, a professional tool for data comparison and synchronization.

What we have:

We have two companies ( they use ERP software), each having their own SQL Server database with one table. The companies tables with their customers’ data are saved in the data warehouse as follows:

  • The SQL table for company1 is Company1$Customer.
  • The SQL table for company2 is Company2$Customer.

What we need:

We need to create a data warehouse with all information stored in one set of SQL tables. For example, the created data warehouse should contain a Customer table that contains all records of Company1$Customer and Company2$Customer.  This table should contain an extra field with a company name to make the records unique. We need to synchronize only changed records.

How to complete the task:

(more…)

Backup Comparison and Database Versioning Added in Schema Compare for SQL Server 2.00

Posted by on January 29th, 2010


Schema Compare for SQL Server 2.00 compares schema snapshots, database backups, and database changes in version control systems to accelerate the work of advanced database developers.

Devart today announced the public availability of  Schema Compare for SQL Server 2.00 that delivers new capabilities to help customers more effectively compare databases and more quickly migrate schema changes across different SQL Server versions.

Featuring new functionality, the tool is better equipped to span a full spectrum of database comparison and synchronization tasks and allows completing them at a professional level.

The highlights of Schema Compare for SQL Server 2.00 include:

(more…)

dbForge Studio for MySQL 4.00 Beta Treats MySQL Data like the Users Want

Posted by on December 11th, 2009

Devart today previewed dbForge Studio for MySQL 4.00, scheduled for release this December, and announced the immediate availability of a beta release that supplies database-dealing people with the very data management capabilities they want.

Having accumulated extensive knowledge in data management preferences and routines, Devart has created dbForge Studio for MySQL 4.00 Beta that predicts and delivers expected capabilities in any phase of dealing with data. The users can manage the data from soup to nuts in one place and with the same little effort as usual.

The highlights of dbForge Studio for MySQL 4.00 Beta include:

(more…)

10 reasons to try database projects

Posted by on June 22nd, 2009

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

Let’s inspect the reasons why you should:

(more…)