Re: [gentoo-user] [OT] Looking for a tool to produce 'reverse' SQL

2006-06-17 Thread Daniel Iliev
On Thu, Юни 15, 2006 9:15 pm, Benjamin Blazke wrote: Hi, I'm looking for a tool that given an existing (base) database schema and an 'update patch' DDL .sql script on input would produce a 'reverse' script that could be used to undo the changes done by the patch. For example: base.sql:

[gentoo-user] [OT] Looking for a tool to produce 'reverse' SQL

2006-06-15 Thread Benjamin Blazke
Hi, I'm looking for a tool that given an existing (base) database schema and an 'update patch' DDL .sql script on input would produce a 'reverse' script that could be used to undo the changes done by the patch. For example: base.sql: CREATE TABLE xxx (...); patch.sql: CREATE TABLE yyy (...);

Re: [gentoo-user] [OT] Looking for a tool to produce 'reverse' SQL

2006-06-15 Thread kashani
Benjamin Blazke wrote: Hi, I'm looking for a tool that given an existing (base) database schema and an 'update patch' DDL .sql script on input would produce a 'reverse' script that could be used to undo the changes done by the patch. For example: base.sql: CREATE TABLE xxx (...); patch.sql:

Re: [gentoo-user] [OT] Looking for a tool to produce 'reverse' SQL

2006-06-15 Thread Benjamin Blazke
--- kashani [EMAIL PROTECTED] wrote: The tool you're looking for is called a DBA. :-) I see. So it's up to QA to test extensively and up to the DBA to recover from a disaster. I hoped there would be a more automated solution but it seems that it's not really doable. Thanks for such a quick

Re: [gentoo-user] [OT] Looking for a tool to produce 'reverse' SQL

2006-06-15 Thread kashani
Benjamin Blazke wrote: --- kashani [EMAIL PROTECTED] wrote: The tool you're looking for is called a DBA. :-) I see. So it's up to QA to test extensively and up to the DBA to recover from a disaster. I hoped there would be a more automated solution but it seems that it's not really doable.