Friday, July 22, 2011

Build your own updated Moodle Schema

This particular post is to assist in getting a Moodle DB schema specific to your database. It is especially handy if there are non-standard plugins installed on Moodle.

As mentioned in an earlier post, getting a relevant ERD on Moodle.org is almost herculian. This tool will reverse engineer the databse ERD.

The application is Fabforce4 located at http://www.fabforce.net/dbdesigner4/

Installation on Windows is straightforward, simply download, install and configure to point to your database.

Installation on CentOS linux was not as good. The application refused to launch. I decided to run it on Wine (which I had to install here).

I'll update with a sample schema of my test database as soon as the operation completes.

-n

2 comments:

  1. Note: I'm able to retrieve the tables fine, but the relationships are not being built. The applications hangs (I even left it running over a weekend with 100% CPU Util).
    Back to the drawing board for a decent ERD.

    ReplyDelete
  2. can you tell me how did you retrieve the tables from moodle please ?

    ReplyDelete