Hi,
Have you checked out our tool "Database Workbench" yet? It
includes a Schema Compare tool that generates a script.
See www.upscene.com
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL,
>> What is the best way to synchronize the database schemas? db_test has had a
>> few indexes and constraints added to several tables and I need to generate a
>> MySQL script to apply these changes to db_prod.
Ruby on Rails comes with tools to dump and load db schemas;
it's trivial to create a sk
On 1/21/10 12:03 PM, "Price, Randall" wrote:
> I have a two databases, one in a production environment (let's call it
> db_prod) and the other in a testing environments (Let's call it db_test).
>
> What is the best way to synchronize the database schemas? db_test has had a
> few indexes and con
One of the ways is to keep db scema under revision control system. And
update it every N minutes.
% crontab -l
0 * * * * mysqldump testdb --no-data > testdb_schema.sql && svn ci -m
"db schema: `date`" > /dev/null
> I have a two databases, one in a production environment (let's call it
> db_prod)
vegiv...@gmail.com [mailto:vegiv...@gmail.com] *On Behalf Of *Johan
> De Meersman
> *Sent:* Friday, January 22, 2010 1:06 AM
> *To:* Daevid Vincent
> *Cc:* mysql@lists.mysql.com; Price, Randall
>
> *Subject:* Re: Best way to synchronize two database schemas
>
> Simple: pr
've ever used, it has a feature to create the schema differences between
> two live databases. I've used it before to get a DEV and PROD server in
> sync, so that I could then implement the above methodology.
>
>
> > -Original Message-
> > From: vegiv...@gmail.com [m
to:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Friday, January 22, 2010 1:06 AM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; Price, Randall
Subject: Re: Best way to synchronize two database schemas
Simple: prefix the change files with mmddhhmm formatted timestamps, so
they sort corr
above methodology.
>
> > -Original Message-
> > From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On
> > Behalf Of Johan De Meersman
> > Sent: Thursday, January 21, 2010 10:35 AM
> > To: Price, Randall
> > Cc: mysql@lists.mysql.com
> > Subject: Re:
-Original Message-
> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On
> Behalf Of Johan De Meersman
> Sent: Thursday, January 21, 2010 10:35 AM
> To: Price, Randall
> Cc: mysql@lists.mysql.com
> Subject: Re: Best way to synchronize two database schemas
>
&
The best way is to keep track of all individual changes to your
staging environment, including fire-and-forget style scripts; and
apply those to your production environment as needed. This is part of
the process of change management, and generally a very good idea :-)
Lacking that, there are sever
10 matches
Mail list logo