3

Is there any way of using database migrations with Joomla? I'm looking for a mechanism like the one found in Rails or Symfony.

I would like to apply changes to the database whenever my model changes, e.g. adding a column, creating a new relationship, dropping some tables,...

In this question, the accepted answer seems like a very cool option, but I don't know if there is something specific to Joomla.

Thanks!

Community
  • 1
  • 1
elitalon
  • 9,191
  • 10
  • 50
  • 86
  • are you asking if there is a tool to migrate current data in a Joomla! database to a database of the same build or to something different like mysql -> mssql ? – a.stgeorge Mar 04 '11 at 08:34
  • Just looking for applying structural changes to the actual database (I edited the question to explain it) – elitalon Mar 04 '11 at 08:51

3 Answers3

3

If you want to update your own component's DB schema you can refer to the following thread: http://forum.joomla.org/viewtopic.php?p=1607199

If you need just migrations without components, check these standalone solutions:

Sam Dark
  • 5,291
  • 1
  • 34
  • 52
0

there is 2 real ways to do migration in Joomla, and each based really on one solution:

1) Just place you SQL changes(like ceate table, or alter, or any thing) /administrator/components/com_admin/SQL/updates/YOU_DB_ENGINE/anyfilename.sql go to web interface then /administrator => extension => manage => database and simple press fix.

2) you can take a look at /administrator/components/com_installer/models/database.php and implement you custom migration process based on this so you can use custom folder

Alexandr
  • 121
  • 1
  • 5
0

I'm working a lot with Joomla for functionnalities implementations and the model changes are made by sql queries mostly or via phpMyAdmin.

Also we do not changes the model of joomla tables (core or plugins one) because the source code without modifications will not handle the changes. We are only adding tables using external ids (like jos_users id).

Futhermore if you change the model of joomla tables, you will not be able to update it (or the plugins impacted) easily.

GMO
  • 669
  • 1
  • 6
  • 11