Migrate a SQL Server Database to a PostgreSQL Database
Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.
2024-07-26
Migration
SQL Server to PostgreSQL Database Schema Conversion
In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.
2024-03-13
Migrations are Worth the Effort
Steve prefers database migrations as a way of making changes to a database, though he knows they are hard. He gives a few reasons to choose them.
2023-12-18
173 reads
Post-migration Validation and Optimization Guide
SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.
2023-09-29
Post-migration Validation and Optimization Guide
SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.
2024-01-09 (first published: 2022-10-10)
2022-09-28
450 reads
2022-09-14
444 reads
2022-08-31
576 reads
Fixing "The Distributor has not been installed correctly" Error with AWS
When migrating a database from SQL Server on premises to AWS, you might receive this error. Learn how to get rid of it.
2022-06-17
5,583 reads
2022-04-25
402 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...