What are the best practices for handling schema changes in relational databases using safe migration scripts in modern development teams?