Update Db tool

Posted in 2017

jorge valenzuela — Mon, 03 Jul 2017 22:25:11 — source: IIUG Forums & Mailing Lists

Hi, I need a tool to update the dbshema of a database. Is there a tool to compare 2 databases to know, which changes I need update? I have server studio DB diff tool, but I have not the complete licencie to compare diferencies. Thanks in advance.

↪ replying to jorge valenzuela

Art Kagel — Mon, 03 Jul 2017 22:56:07 — source: IIUG Forums & Mailing Lists

In my utils2_ak package there is a script, mydbdiff, that compares two database schema, either two live databases using myschema or else a live database to a saved myschema output file. Myschema is included in the package. (Note I just found a typo in the script, you have to delete the first line in the script if it says "select". Don't know when that got in there, I haven't looked at the script for a long time. You can download the latest utils2_ak package from my web site at: www.askdbmgt.com/my-utilities.html Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 3, 2017 at 6:25 PM, jorge valenzuela <jorgervt@gmail.com> wrote: > Hi, > > I need a tool to update the dbshema of a database. Is there a tool to > compare > 2 databases to know, which changes I need update? I have server studio DB > diff > tool, but I have not the complete licencie to compare diferencies. > > Thanks in advance. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Art Kagel

jorge valenzuela — Tue, 04 Jul 2017 17:18:53 — source: IIUG Forums & Mailing Lists

Thanks very much. > El 03/07/2017, a las 15:56, Art Kagel <art.kagel@gmail.com> escribió: > > In my utils2_ak package there is a script, mydbdiff, that compares two > database schema, either two live databases using myschema or else a live > database to a saved myschema output file. Myschema is included in the > package. (Note I just found a typo in the script, you have to delete the > first line in the script if it says "select". Don't know when that got in > there, I haven't looked at the script for a long time. > > You can download the latest utils2_ak package from my web site at: > www.askdbmgt.com/my-utilities.html > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > >> On Mon, Jul 3, 2017 at 6:25 PM, jorge valenzuela <jorgervt@gmail.com> wrote: >> >> Hi, >> >> I need a tool to update the dbshema of a database. Is there a tool to >> compare >> 2 databases to know, which changes I need update? I have server studio DB >> diff >> tool, but I have not the complete licencie to compare diferencies. >> >> Thanks in advance. >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >