Looking for best way to sync data structure

Howdy,

I'm looking for a good tool to use (can be nothing more than a
script...) to sync database structure from one DB to another. Best
case scenario is that it would generate a .sql script file to run
against the target DB.
(I'm running mySQL 5.x)

I am mainly running OS X, but I have access to windows machines.

Is there a standard tool/script out there to do this?

I've tried using Navicat for OSX with limited success.

Thanks,
Jason

jreljac@gmail.com wrote:
> Howdy,
>
> I'm looking for a good tool to use (can be nothing more than a
> script...) to sync database structure from one DB to another. Best
> case scenario is that it would generate a .sql script file to run
> against the target DB.
> (I'm running mySQL 5.x)
>
> I am mainly running OS X, but I have access to windows machines.

mysqldump, comes with mysql, run it in the OSX terminal.

On the machine where you want to import the .sql file you only need the
console front end (mysql) where you can import it with \,

--

//Aho

On Jun 3, 10:43 am, "J.O. Aho" <u...@example.net> wrote:
> jrel...@gmail.com wrote:
> > Howdy,
>
> > I'm looking for a good tool to use (can be nothing more than a
> > script...) to sync database structure from one DB to another. Best
> > case scenario is that it would generate a .sql script file to run
> > against the target DB.
> > (I'm running mySQL 5.x)
>
> > I am mainly running OS X, but I have access to windows machines.
>
> mysqldump, comes with mysql, run it in the OSX terminal.
>
> On the machine where you want to import the .sql file you only need the
> console front end (mysql) where you can import it with \,
>
> --
>
> //Aho

Thanks...

I do use mysqldump when creating new DBs, but will it let me sync
structure?
Lets say I have 2 DBs, A &B.
A has three tables - 1,2 and 3 while B has 2 tables - 1 & 3
I need to be able to compare the two DBs and create a script to
generate table #2 in DB B
(I need this down to the column level)

Thanks,
Jason

jreljac@gmail.com wrote:

> I do use mysqldump when creating new DBs, but will it let me sync
> structure?

The dump will create a copy of the original database/table, including the data.


> Lets say I have 2 DBs, A &B.
> A has three tables - 1,2 and 3 while B has 2 tables - 1 & 3
> I need to be able to compare the two DBs and create a script to
> generate table #2 in DB B
> (I need this down to the column level)

If you want only inject data missing, mysqldump won't be the optimal, even if
you could dump the both databases and then use the diff command to get the
difference between the tables and then use the result.

In a such case it could be easier just write a small php script that will read
each line on one database and check if that on is in the other, if not, do an
INSERT.
MysqlAdmin may have such functionality, but not sure as I don't use that so much.


--

//Aho