Relational Database Normalization

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

High level steps for database migration

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