db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Phillip Rhodes" <spamsu...@rhoderunner.com>
Subject generate data migration scripts
Date Fri, 21 Mar 2003 21:34:12 GMT
I am using torque, and sometimes I change my data model and need to write
a bunch of insert/select statements that select from one database and
insert into the other, with perhaps some handcrafting in the sql to
provide for the addition columns.

It would be nice if torque could generate some data migration scripts that
could be hand tweaked.

Sort of like this:
insert into new_db.orders(x,y,z)
select x,y,z from old_db.orders;

Thanks for any pointers.  It's such a drudgery to do these scripts.

View raw message