command line

Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool

This article will be useful for those who have already installed PostgreSQL on their personal computer. In case you still haven’t, this blog post will come in handy. Now, we will focus on some of the most popular ways of accessing the PostgreSQL database on Windows. We will describe the PostgreSQL connection options using psql, pgAdmin, and fast and convenient dbForge Studio for PostgreSQL by Devart. Moreover, here you will find the instructions on connecting to local and remote PostgreSQL servers.

(more…)

How to Automatically Synchronize Multiple Databases on Different SQL Server Instances

In this article, we share a step-by-step guide on how to compare the schema and data of multiple SQL Server databases from the command line.

(more…)

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

dbForge Studio for MySQL on Linux Operating Systems

Despite the fact that the dbForge database tools 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…)