Description

---

Are you looking for resources to get started with migrating SQL Server Databases to PostgreSQL? This is the book for you. This concise eBook 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.This eBook is divided into four chapters: Chapter 1: Getting Started1.Introduction to Open Source Software, its advantages and disadvantages2.Moving from Licensed software to Open Source software3.Basics and the history of Microsoft SQL Server and PostgreSQL4.Choosing the right PostgreSQL Edition and Version for your needs5.Production, Development & Testing Workloads6.On-Premise vs Cloud comparisonChapter 2: Platform Comparison1.In-depth comparison of SQL Server and PostgreSQL2.Concurrency Control3.Database Structure comparison4.Feature comparison5.Data Type Mapping6.Built-In Functions and Operators7.SQL Syntax differences8.Areas where PostgreSQL has an edge9.Areas where SQL Server has an edge10.GUI Client ToolsChapter 3: The Actual Migration1.Schema migration2.Data migration3.Code migration4.ETL/ELT Tools5.Reporting Platforms6.Analytics Platforms7.Scheduling Options8.Application/Services MigrationChapter 4: Maintenance and Monitoring1.Maintenance and Monitoring2.High Availability, Load Balancing, and Replication3.Environment Stabilization via Parallel Deployment.