command line

How to Connect to MySQL Server

In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server.

(more…)

Entity Developer 6.7 with Console App, .NET Core Support Improvements and More

Devart is glad to announce the release of Entity Developer 6.7 – a visual ORM designer for a wide variety of ORMs. The new version comes with a console application added for convenient development processes automation and improves support for .NET Core development and third-party providers.

(more…)

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