HomeHow To

How To

Version-controlling Static Data: Conflicts

Version-controlling static data is vital to maintaining a normalized database structure. The article presents a simple and comprehensive guide through the process of resolving...

Export and Import SQL Server Data to SQL Script (SSMS, CLI, dbForge) 

Data migration is a common challenge in the field of database development, management, and administration. This guide will illustrate the process of exporting database data to a .sql file and subsequently importing it into the target database.

Searching for Invalid Objects with SQL Complete

The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and...

Data Export from Amazon RDS MySQL Instance

The necessity to export data from Amazon RDS to the on-premises MySQL database may be spawned by various reasons such as a user request,...

Import MySQL data to Amazon RDS

Importing and exporting data are common tasks involved with administering databases. Migrating data between on-premises and cloud databases can be frustrating especially if...

Find Invalid Objects in SQL Server Databases

In the course of time, we can experience situations when some certain database objects have not been distributed on one or several databases...

Compare and Find Data Differences Between Two Tables in SQL Server With SSIS and dbForge Tools

Systems often work with distributed databases that contain distributed tables. Distribution is supported by various mechanisms, including replication. In this case, it is...

Is UNPIVOT the Best Way for Converting Columns into Rows?

To start, let's give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server. The PIVOT and UNPIVOT relational operators are used...

How to Import and Export CSV Files Into a PostgreSQL Database

CSV files provide a great way to collect and store data, and they are often used as a reliable way to move table data...

SSL Connection to MySQL From Delphi With UniDAC and SecureBridge

This article explains how to establish an SSL connection to MySQL from Delphi with UniDAC and SecureBridge. UniDAC has had MySQL SSL (using certificates) connection...

Social

Topics

Products