command line

Automatic Schema Comparison Log Delivery via Email

In this article, we will show how to set up automatic email delivery of the log file when a comparison of multiple SQL schemas fails. The task will be completed by means of dbForge Studio for SQL Server. Specifically, we will use its command-line functionality, allowing to perform routine tasks in both, command prompt and PowerShell. In this article, we will focus on the command prompt.

(more…)

How to Compare Multiple Databases through 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 use dbForge Data Compare for PostgreSQL, which allows you to perform this process with a few clicks. (more…)

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 for MySQL.

(more…)

How to specify parameters in a report through the command line

dbForge Studio for SQL Server gives you an opportunity of automating the variety database management processes. One of them is specifying parameters in a report making use the command line.

(more…)

Adding Timestamp to a Filename

Summary: This article describes how to add time and date to a filename using the command line.

Sometimes it is crucial to append time and date to the name of a file. For example, we would like to have separate log files for each execution of data synchronization script. To prevent file overriding, we want to specify date and time in the name of each log file.

(more…)

How To: Automatically Email Comparison Report

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.

(more…)

dbForge Studio for MySQL on Linux family operating systems

Despite the fact that dbForge products were developed only for Windows platforms, our active users (thanks to Tsvetkov) have found a way to use some features of dbForge Studio for MySql on Linux family operating systems.

Tests were run under .Net Framework 2.0 on Wine emulator. (more…)

Export a MySQL Table to a CSV File Methods Overview

To perform successful export of a MySQL table to a CSV file you will need the dbForge Studio for MySQL database management tool. You can download it for free and evaluate its features during a 30-day trial period.

(more…)

How To: Setup Daily MySQL Backup on Windows

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 SQL data between a company database and a data warehouse

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 SQL data comparison and synchronization. (more…)