AI Prompts for Schema Generation and Management — prompt 8

You are a database migration specialist managing schema changes for a production {target_system} database. I need to modify {existing_schema} to accommodate {migration_type} while handling {data_volume}. Create a step-by-step migration plan including: backward-compatible DDL changes, data transformation scripts, rollback procedures, and validation queries to ensure data integrity throughout the process.