Migrating database storage objects from Oracle to Postgres

By TECHCOMMUNITY.MICROSOFT.COM - 2021-02-08

Description

Welcome to part 2 of the four-part blog series on navigating Oracle to Postgres migrations. I am super stoked to let you know the first post in the

Summary

  • Welcome to part 2 of the four-part blog series on navigating Oracle to Postgres migrations.
  • from Oracle, let me walk you through a practical experience with data types to show you how important testing each conversion is.
  • If you’re migrating from a typical Oracle workload, there is a high chance you will hit this issue in the way Oracle treats NULLs in strings vs. Postgres.
  • If your application depends on shared cache values for sequences, it would be good to think about changing the design in the app itself given this difference.

 

Topics

  1. Database (0.31)
  2. UX (0.13)
  3. Backend (0.12)

Similar Articles

Python and MySQL Database: A Practical Introduction

By realpython - 2021-01-22

In this tutorial, you'll learn how to connect your Python application with a MySQL database. You'll design a movie rating system and perform some common queries on it. You'll also see best practices a ...

How to use IndexedDB to build Progressive Web Apps

By Medium - 2020-09-01

In this previous post, I talked about implementation of IndexedDB inside Service Workers. If you don’t understand that part, please read that article to clear up some concepts about service workers…

Spring Data Neo4j - Developer Guides

By Neo4j Graph Database Platform - 2021-01-05

For Java developers who use the Spring Framework or Spring Boot and want to take advantage of reactive development principles, this guide introduces Spring integration through the Spring Data Neo4j pr ...

How to Create an Index in Django Without Downtime

By realpython - 2020-12-06

In this step-by-step Python tutorial, you'll get a solid understanding of the limitations of Django migrations by tackling a well known problem: creating an index in Django with no downtime.

Introduction to Python SQL Libraries

By realpython - 2020-12-28

In this step-by-step tutorial, you'll learn how to connect to different database management systems by using various Python SQL libraries. You'll interact with SQLite, MySQL, and PostgreSQL databases ...

Dump and load a database in Neo4j Desktop

By Graph people - 2020-11-11

Have you ever wanted to share a database you created in Neo4j Desktop with your colleague but not sure exactly how to go about it? Maybe you want to clone the database locally to perform various write ...