Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

What is wrong with using database tables with phpmyadmin or mysql? What are the benefits, if I'll use 'migration'?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

I don't use CodeIgniter, but as a Rails developer who used to just use phpMyAdmin and now uses migrations I'd say the primary benefits are:

  1. It's an easy way to port the code to a different workstation. Instead of having to dump the SQL file and import it into the other workstation, you just run the migrations.
  2. It allows you to keep your database schema in sync with your co-workers. When a table is modified, everyone can just run the migration and you're good to go.
  3. It allows you to easily roll back database changes if they cause problems.
  4. It documents the changes made to the database structure.
share|improve this answer
    
Thank you. I think its good to go. –  Su As Mar 25 '13 at 2:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.