Is there a version control system for database structure changes?

by

In Ruby on Rails, there’s a concept of a migration — a quick script to change the database.

You generate a migration file, which has rules to increase the db version (such as adding a column) and rules to downgrade the version (such as removing a column). Each migration is numbered, and a table keeps track of your current db version.

To migrate up, you run a command called “db:migrate” which looks at your version and applies the needed scripts. You can migrate down in a similar way.

The migration scripts themselves are kept in a version control system — whenever you change the database you check in a new script, and any developer can apply it to bring their local db to the latest version.

More Related Contents:

  1. How do I reset a sequence in Oracle?
  2. ORA-00904: invalid identifier
  3. How can I get column names from a table in Oracle?
  4. Is there any boolean type in Oracle databases?
  5. SQL ROWNUM how to return rows between a specific range
  6. MySQL equivalent of DECODE function in Oracle
  7. SQL recursive query on self referencing table (Oracle)
  8. create table with sequence.nextval in oracle [duplicate]
  9. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  10. Deferrable Constraints in SQL Server
  11. Oracle (Old?) Joins – A tool/script for conversion?
  12. How to populate calendar table in Oracle?
  13. What is it exactly a BLOB in a DBMS context
  14. What can cause an Oracle ROWID to change?
  15. Does ‘Select’ always order by primary key?
  16. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  17. How do I list all the columns in a table?
  18. How do you interpret a query’s explain plan?
  19. Oracle DB: How can I write query ignoring case?
  20. How do NULL values affect performance in a database search?
  21. Query a Table’s Foreign Key relationships
  22. Oracle , != , ^= operators
  23. SQL Server equivalent of WM_CONCAT function [duplicate]
  24. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?
  25. GROUP BY / aggregate function confusion in SQL
  26. Oracle “(+)” Operator
  27. Select without a FROM clause in Oracle
  28. Is there any way to flush output from PL/SQL in Oracle?
  29. How can I solve ORA-00911: invalid character error?
  30. What is difference between foreign key and reference key?

Leave a Comment