Amazing world about data

Developer, ThoughtWorker, Data Architect and Data Specialist

Refactoring

2 minutes read

When you are refactoring large databases, you will have certain tables that have millions of rows, so lets say we are doing the Move Column refactoring, moving the TaxAmount column from Charge table which has millions of rows to TaxCharge table. Create the TaxAmount column in the TaxCharge table. Then have to move the data from the TaxAmount column in the Charge table to the TaxAmount column you created in the TaxCharge table.

Implementing Make Column Non Nullable

Implementing Make Column Non-Nullable Refactoring

2 minutes read

While working on a Legacy Application with Legacy Database design as part of fixing a bug, I thought this bug would not have ever happened if a particular column was defined as Non Nullable since this particular column was the identifier to the parent table.

Recent posts

Post

See more

Categories

About