The Developer Space

Developer's Cafe

  • Cloud
  • Database
  • Open Source
  • Programming
  • Web Dev
  • Mobile
  • Security
  • QuickRef
  • Home
  • Cloud
  • Book: Migrating your SQL Server Workloads to PostgreSQL

Book: Migrating your SQL Server Workloads to PostgreSQL

Shameel Ahmed - AWS, Azure, C#, Cloud, Database, Java, Open Source, PostgreSQL, Programming, SQL Server
May 5, 2020October 22, 2022 No Comments
Migrating your SQL Server Workloads to PostgreSQL AWS migration postgresql sqlserver
2 0
Read Time2 Minute, 38 Second

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.

Share

Facebook
Twitter
LinkedIn
Email

Post navigation

Minimize Non-Critical Database Workload costs in AWS
MYSWP – Book Links

Related Articles

ChatGPT landing page

Learn Python with ChatGPT

Shameel Ahmed
December 26, 2022December 26, 2022 7 Comments
Migrate your SQL Server Workloads to PostgreSQL: Quick Reference: Second Edition

Book: Migrate your SQL Server Workloads to PostgreSQL: Quick Reference – Second Edition

Shameel Ahmed
October 18, 2022October 22, 2022 1 Comment

Increase Visual Studio Code Terminal Buffer Size

Shameel Ahmed
July 14, 2022July 14, 2022 No Comments

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
(Add your review)

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

.NET Architecture Artificial Intelligence ASP.NET AWS Azure Books C# Career Cloud CodeProject Conversational Bots Database Data Security Facade IDEs Java Mobile MongoDB MySQL Open Source Patterns PostgreSQL Programming Python Redis Security SQL Server Tools Uncategorized Web Development Windows Phone

Recent Posts

  • Developer to Architect Series (Red Hat Enable Architect) January 16, 2023
  • Can ChatGPT replace Google Search? January 11, 2023
  • Learn Python with ChatGPT December 26, 2022
  • Book: Migrate your SQL Server Workloads to PostgreSQL: Quick Reference – Second Edition October 18, 2022
  • Increase Visual Studio Code Terminal Buffer Size July 14, 2022

Archives

  • January 2023 (2)
  • December 2022 (1)
  • October 2022 (1)
  • July 2022 (2)
  • February 2022 (1)
  • November 2021 (1)
  • July 2021 (1)
  • June 2021 (1)
  • September 2020 (1)
  • May 2020 (2)
  • April 2020 (1)
  • October 2019 (1)
  • September 2019 (4)
  • July 2019 (2)
  • May 2018 (1)
  • September 2017 (1)
  • April 2017 (1)
  • April 2014 (1)
  • August 2011 (1)
  • June 2009 (1)
Copyright 2022. The Developer Space | Theme: OMag by LilyTurf Themes
  • DbStudio
  • Re:Link
  • shameel.net
  • Privacy Policy
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
SAVE & ACCEPT