Developing with SVN and CI - best practices?

[eluser]Jonas G[/eluser]
I like the idea about working on an online test database - i'll do that for my next project. If you like the idea about working offline (as I do), here's my method:

What I do now is dump the database to an .sql file and then have a controller which imports the sql file:

Code:

$sql_file = APPPATH.'sql/dump_all.sql';
                echo 'This might take some time...';
                $handle = @fopen($sql_file, "r");
                $query = "";
                while(!feof($handle)) {
                    $sql_line = fgets($handle);
                    if (trim($sql_line) != "" && strpos($sql_line, "--") === false) {
                        $query .= $sql_line;
                        if (preg_match("/;[\040]*\$/", $sql_line)) {
                            $this->db->query($query);
                            $query = "";
                        }
                    }
                }
                echo 'Done...';

That way you can add the .sql file to the repo and when there is updates to the database just run a local URL which calls the above.

I use this with mysql dumps but would be much more versatile if it used ALTER TABLE and the like... Be careful about this way though - there's no reverting.