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?
SQL Deployment Tool?
Moderator: General Moderators
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
Re: SQL Deployment Tool?
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?
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
- AbraCadaver
- DevNet Master
- Posts: 2572
- Joined: Mon Feb 24, 2003 10:12 am
- Location: The Republic of Texas
- Contact:
Re: SQL Deployment Tool?
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.