Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL: Data Migration Strategies

- 16.08.26 - ErcanOPAK

🔄 Data Migration = Database Changes

Databases evolve. Data migration strategies handle database changes safely.

📝 Migration Strategies

# 1. Schema Migration
-- Create new table
CREATE TABLE new_table (
    id INT PRIMARY KEY,
    name VARCHAR(100)
);

-- Copy data
INSERT INTO new_table (id, name)
SELECT id, name FROM old_table;

-- Drop old table
DROP TABLE old_table;

# 2. Data Transformation
-- Add new column
ALTER TABLE users ADD COLUMN full_name VARCHAR(200);

-- Transform data
UPDATE users 
SET full_name = CONCAT(first_name, ' ', last_name);

-- Remove old columns
ALTER TABLE users 
DROP COLUMN first_name,
DROP COLUMN last_name;

# 3. Rolling Update
-- Add column with default
ALTER TABLE orders ADD COLUMN status VARCHAR(20) DEFAULT 'pending';

-- Update in batches
UPDATE orders 
SET status = 'completed' 
WHERE completed_at IS NOT NULL 
LIMIT 1000;

🎯 Migration Tools

# Entity Framework Migrations
dotnet ef migrations add AddUserTable
dotnet ef database update

# Flyway
flyway -url=jdbc:postgresql://localhost:5432/mydb \
    -user=postgres -password=password migrate

# Liquibase
liquibase --changeLogFile=db.changelog.xml \
    --url=jdbc:postgresql://localhost:5432/mydb \
    --username=postgres --password=password update

# Migration Script Template
-- 20240115_001_add_users_table.sql
-- Up Migration
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

-- 20240115_001_add_users_table.sql
-- Down Migration
DROP TABLE users;

💡 Migration Tips

  • Always backup before migration
  • Test migrations on staging
  • Use version control for migrations
  • Implement rollback strategy
  • Monitor migration performance

Data migration requires careful planning. A good strategy minimizes downtime and data loss.

— Database Engineer

Related posts:

SQL Server: Fix a Query That Falls Back to an Expensive Key Lookup Because One Extra Column in the S...

SQL Server: Fix a Query That Falls Back to an Expensive Key Lookup Because One Extra Column in the S...

SQL: Use Indexing for Query Performance

SQL: Use Indexing for Query Performance

SQL: Use COALESCE to Handle NULL Values

SQL: Use COALESCE to Handle NULL Values

Views: 10

Post navigation

.NET Core: Building Microservices with .NET
C#: Async/Await in Console Applications

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (609)
  • Average of all values in a column that are not zero in SQL (570)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (547)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com