Deep Dive into Enterprise IT
If database migration involves a schema redesign, we need to follow certain forms. I have good instinct what these forms are. However, I got some questions are particular normal forms and I realized that I cannot spell them all out clearly, except that I learned it all in university (10+ years ago). I decided to … Read moreRelational Database Normalization
Database migration may involve many different types, such as hardware platform migration, one technology to another (relational to relational, relational to NoSQL), on-premise to cloud, etc. In this posting, I outline some key steps at high level to a successful database migration, assuming the migration involves changing DBMS platform. Assessment and discovery – this is … Read moreHigh level steps for database migration