Hi- This is sort of random, but I was curious if anybody has built a database schema differ/updater? I often do a bunch of changes on my devel database, and I want to update just the schema (but not trash the data) in my "production" database, so it would be handy to have some sort of tool that looked at the schemas for both DBs and built the correct ALTER TABLE commands. Has anybody seen anything like this in the wild? If not... I might try working on one myself... just think it would be a handy tool to have around. Thanks Ben
Ben Schumacher wrote:> Hi- > > This is sort of random, but I was curious if anybody has built a > database schema differ/updater? I often do a bunch of changes on my > devel database, and I want to update just the schema (but not trash > the data) in my "production" database, so it would be handy to have > some sort of tool that looked at the schemas for both DBs and built > the correct ALTER TABLE commands. > > Has anybody seen anything like this in the wild? If not... I might try > working on one myself... just think it would be a handy tool to have > around.Yes, definitely sounds nice. +1 to the interested people count.
Marten Veldthuis wrote:>> This is sort of random, but I was curious if anybody has built a >> database schema differ/updater? I often do a bunch of changes on my >> devel database, and I want to update just the schema (but not trash >> the data) in my "production" database, so it would be handy to have >> some sort of tool that looked at the schemas for both DBs and built >> the correct ALTER TABLE commands. >> >> Has anybody seen anything like this in the wild? If not... I might try >> working on one myself... just think it would be a handy tool to have >> around. > > > Yes, definitely sounds nice. +1 to the interested people count.There are a number of products out there like that. Some good others bad. Search for SQLDiff on Google will give a couple of different products. Eric _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Jan 10, 2005, at 10:12 AM, Ben Schumacher wrote:> Has anybody seen anything like this in the wild? If not... I might try > working on one myself... just think it would be a handy tool to have > around. >I had used a mysqldiff before http://search.cpan.org/~aspiers/MySQL-Diff-0.33/ Sounds like something else to port to Ruby. - - Jason -----BEGIN PGP SIGNATURE----- Version: PGP 8.1 iQA/AwUBQeLQvFUyB+ajXkCLEQKfsQCeJZSkznqCNzODkgD/Xap51LcX8sUAn3bs D7ASDeQKRjUv3XAtjHKCBE3X =L/TW -----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Jan 10, 2005, at 11:00 AM, Jason Hoffman wrote:> On Jan 10, 2005, at 10:12 AM, Ben Schumacher wrote: >> Has anybody seen anything like this in the wild? If not... I might try >> working on one myself... just think it would be a handy tool to have >> around. >>And there are also ones for postgresql and data in mysql http://pgdiff.sourceforge.net/ http://www.mrjoy.com/datadiff/ - - Jason -----BEGIN PGP SIGNATURE----- Version: PGP 8.1 iQA/AwUBQeLRXFUyB+ajXkCLEQI1PACg2pZmMU1bRut6mgNsuyO3MFPNP5cAoN0G AGmonx5om57PCPxwXiGWzfz1 =Pzz6 -----END PGP SIGNATURE-----