The Developer Space

2 0

A newer version of this book is available. Please check out this post: Book: Migrate your SQL Server Workloads to PostgreSQL: Quick Reference – Second Edition – The Developer Space

Introduction

This concise Book is intended to be a ready reference and a checklist for migrating your databases, applications and services from Microsoft SQL Server to PostgreSQL and discusses all the important information you need to be aware of before beginning a migration project.

I have had the opportunity of designing and executing a large migration involving several big SQL Server Instances (with over 100 databases in total) to AWS Aurora (PostgreSQL compatible) with a total size of over 20 terabytes. During the migration, many mistakes were made, and a lot of rework done resulting in several learnings for the team. These learnings are shared here.

While I have taken every effort to make sure that the information presented here is accurate; things might have changed, features that were not supported in older versions might be supported in newer versions, etc. If you find something inaccurate, misleading or grossly wrong, please feel free to leave a comment with the details and the links to support your claims, I would be glad to update the Book with the correct information.

Chapters

This Book is divided into four chapters:

Chapter 1: Getting Started

1. Introduction to Open Source Software, its advantages and disadvantages
2. Moving from Licensed software to Open Source software
3. Basics and the history of Microsoft SQL Server and PostgreSQL
4. Choosing the right PostgreSQL Edition and Version for your needs
5. Production, Development & Testing Workloads
6. On-Premise vs Cloud comparison

Chapter 2: Platform Comparison

1. In-depth comparison of SQL Server and PostgreSQL
2. Concurrency Control
3. Database Structure comparison
4. Feature comparison
5. Data Type Mapping
6. Built-In Functions and Operators
7. SQL Syntax differences
8. Areas where PostgreSQL has an edge
9. Areas where SQL Server has an edge
10. GUI Client Tools

Chapter 3: The Actual Migration

1. Schema migration
2. Data migration
3. Code migration
4. Jobs migration
5. ETL/ELT Tools
6. Reporting Platforms
7. Analytics Platforms
8. Scheduling Options
9. Application/Services Migration

Chapter 4: Maintenance and Monitoring

1. Maintenance and Monitoring
2. High Availability, Load Balancing, and Replication
3. Environment Stabilization via Parallel Deployment

Buy the book here at:

Amazon

If you are on Kindle Unlimited, you can read it for free.

Available in all regions: US, UK, India, France, Italy, Australia, New Zealand, Japan, Mexico, Brazil, Spain. Click on the link above to shop in your local Amazon portal or search for the title in your respective site or app.