Page 1 of 1

SQL Deployment Tool?

Posted: Sat Jan 02, 2010 12:42 am
by Daz
I have a code base (w/ database) I use on several websites which I develop on a home machine. It's easy to update the websites themselves (ssh & diff) but is there any easy way to update the databases?

So far I've just been making MySQL 'scripts' and then running them on the websites individually. Are there any tools that can help with this?

Re: SQL Deployment Tool?

Posted: Sat Jan 02, 2010 12:58 am
by alex.barylski
SQLyog I believe has a tool or functionality to make this easy -- I seem to recall a developer at work doing something like this.

Re: SQL Deployment Tool?

Posted: Sun Jan 03, 2010 10:43 am
by josh
Yep I used to use SQLyog it will diff 2 schemas and write an SQL to write the ALTER statements to move you from the before to the after, now I keep my changes in .sql files as I make them, and number each step, and give each step a name. Much "safer" and keeps your changes in version control

Re: SQL Deployment Tool?

Posted: Sun Jan 03, 2010 1:25 pm
by AbraCadaver
I use a combination of things. I used to use PHPMyAdmin, but I normally now use the MySQL tools: MySQL Administrator, MySQL Query Builder and MySQL Workbench.