SQL Server to PostgreSQL Migration
1 month of Skillshare
Available with PurchaseFree
All memberships will be billed automatically on a recurring basis until canceled. If eligible for a free trial, cancel before the trial ends to avoid being charged. Offer only valid for new paid subscribers. See full terms of service here.
About this product
Course Description: SQL Server to PostgreSQL Migration (Complete Hands-On Training)
This comprehensive course teaches you how to successfully migrate databases from Microsoft SQL Server to PostgreSQL, covering real-world methods, tools, strategies, and live demonstrations used by modern Database Administrators, Cloud Engineers, and Data Migration Specialists.
Whether you're moving to PostgreSQL for cost savings, open-source flexibility, or cloud modernization, this course provides a full end-to-end roadmap—from assessment to cutover. Through step-by-step labs, architecture guides, CLI commands, and troubleshooting techniques, you’ll learn exactly how to execute smooth, zero-data-loss migrations using industry-proven approaches.
You will explore multiple migration methods including AWS SCT + AWS DMS, pgloader, SQL Server Export Wizard, SQLines, ETL Tools (SSIS, Pentaho, Talend), and GUI-based DBConvert solutions. Each method is broken down with practical examples, pros/cons, and best-fit scenarios so you can confidently select the right approach for your environment.
This hands-on training also includes detailed comparisons of SQL Server vs PostgreSQL features, data type mapping cheat sheets, schema conversion rules, CDC-based replication, validation techniques, performance tuning, and a full production-ready migration plan.
By the end of the course, you'll be able to migrate databases of any size—from small workloads to enterprise-level systems hosted on-premises or in the cloud.
✅ What This Course Covers
1. SQL Server → PostgreSQL Migration Overview
Migration phases: Assessment, Schema Conversion, Data Migration, Validation
Key differences between SQL Server & PostgreSQL
Migration readiness checklist
2. Detailed Schema & Data Conversion
Identity, date/time, string, UUID, money, BIT, binary, and GUID mappings
T-SQL vs PL/pgSQL differences
Handling stored procedures, triggers, and views
3. All Major Migration Methods
✔ AWS SCT + AWS DMS (Enterprise method)
Schema assessment & auto-conversion
DMS endpoints, tasks, CDC migration
Cloud cutover strategy
✔ pgloader (Open-source automation)
One-command schema + data migration
Linux, macOS, Docker setups
Real-time CLI logs, error handling
✔ SQLines (Schema conversion)
Converting T-SQL scripts
Applying converted objects in Postgres
✔ SQL Server Export Wizard + PostgreSQL Import
CSV/flat file workflows
COPY and \copy commands
✔ ETL Tools (SSIS, Talend, Pentaho)
Complex mapping transformations
Scheduling and automation
✔ DBConvert / DBSync GUI Tools
Windows-friendly visual migrations
🔧 4. Hands-On Real-Time Labs
Create SQL Server & PostgreSQL databases
Use AWS SCT to convert schemas
Use AWS DMS for full load + CDC
Execute pgloader migration with live tables
Validate row counts, schemas, and checksum
Apply performance tuning & indexing
📊 5. Validation & Post-Migration Steps
Data integrity verification (COUNT, SUM, CHECKSUM)
Schema comparison
Constraint and index validation
PostgreSQL performance tuning (VACUUM, ANALYZE, configs)
Application connection updates
Final cutover & rollback plan
🚀 6. Real-Time Production Migration Scenario
A full 100GB SQL Server database migration to PostgreSQL with:
AWS RDS PostgreSQL
SCT schema conversion
DMS real-time replication
Data validation
Downtime-free cutover checklist
🎯 Learning Outcomes
By completing this course, you will be able to:
Understand all SQL Server → PostgreSQL migration paths
Convert schemas, functions, triggers, and SQL logic
Use AWS SCT, AWS DMS, pgloader, SQLines, SSIS & more
Validate migrated data and troubleshoot issues
Tune PostgreSQL for performance after migration
Execute production-ready, enterprise-level migrations
FAQs
What are digital products?
Digital products at Skillshare are expertly crafted tools, resources, and templates developed by top creatives that are available to you for purchase. With a wide range of resources to suit every creative need, they are actionable, making your learning experience real and unforgettable.
How can I purchase a digital product?
Anyone can purchase a digital product on Skillshare — click Buy now to enter your payment information and complete your purchase. Once payment is complete, all files will be available for download instantly from this page. You'll also receive an email with a link to download your digital product after purchase.
Is there a limit to how many times I can download a digital product?
No, there is no limit to how many times you can download a digital product. Even if a product is removed by the creator, you can still access the download page in most cases by logging in to your Skillshare account.
Can I get a refund or cancel my digital product purchase?
Digital products are non-refundable and cannot be returned or canceled. To learn more, see our refund policy in the Skillshare Help Center.
Can I make and sell my own digital products?
Absolutely! Visit How can I sell a digital product on Skillshare? to learn how you can create, list and sell your own digital products on Skillshare.