How To
MySQL Primary Key: CREATE and ALTER TABLE Statements
Following the best practices of RDBMS involves the consistent usage of Primary Keys when designing databases to create and enforce Referential Integrity which is...
How to Export and Import JSON Data Via dbForge Data Pump for SQL Server
In the previous articles, we studied the basic rules of SQL database design, created a database schema diagram for a recruitment service, and filled...
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...
Pivot Tables and Reporting in SQL
Quite enough, there’s a need to change how data is displayed in a database so that the users could analyze it more easily. One...
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...
How to Convert MySQL Data to PostgreSQL
Transferring data between two different servers is not an easy task as it requires a great deal of effort and accuracy, especially when...
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...
