SQL Deployment Tool?

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
Daz
Forum Newbie
Posts: 18
Joined: Thu Mar 19, 2009 2:12 am

SQL Deployment Tool?

Post 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?
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: SQL Deployment Tool?

Post 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.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: SQL Deployment Tool?

Post 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
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: SQL Deployment Tool?

Post 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.
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Post Reply