Does anybody have code that will look at two tables and generate the
appropriate alter table statments to make the structures identical? Thanks.

Robert

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote:

Does anybody have code that will look at two tables and generate the
appropriate alter table statments to make the structures identical? Thanks.

Robert

Well what i did is create a small app that will read in a sql script created with the reverse engineer function in dbsys.
Then it will update a target DB, in what I call a brute force method, by simply using if exsists and so on.
It basicly creates a script to update every table regardless of the state of the target DB.
I can send you the file if you would like to check it out, it works great for me.

"A. Ibarra" <elevate@valware.com> wrote in message
news:4EAAF02F-57C7-4862-B2FB-244614846464@news.elevatesoft.com...
> "Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote:
>
> Does anybody have code that will look at two tables and generate the
> appropriate alter table statments to make the structures identical?
> Thanks.
>
> Robert
>
> Well what i did is create a small app that will read in a sql script
> created with the reverse engineer function in dbsys.
> Then it will update a target DB, in what I call a brute force method, by
> simply using if exsists and so on.
> It basicly creates a script to update every table regardless of the state
> of the target DB.
> I can send you the file if you would like to check it out, it works great
> for me.
>

would be very much appreciated

rkaplan at advantsoft.com

Robert

>Well what i did is create a small app that will read in a sql script created with the reverse engineer function in dbsys.
>Then it will update a target DB, in what I call a brute force method, by simply using if exsists and so on.
>It basicly creates a script to update every table regardless of the state of the target DB.
>I can send you the file if you would like to check it out, it works great for me.

Could you also be kind enough to send it to me? I will have a need for
such a procedure very shortly.

patabc at ozemail.com.au

Thank you,
Pat

Hi,

I am also interested

haliz at consit.dk

Thanks.

Regards,
Hüseyin


"Pat" <pat@downunder.com> skrev i en meddelelse
news:karn24ln93kho8sojtprb2r5dth79m838e@4ax.com...
> >Well what i did is create a small app that will read in a sql script
> >created with the reverse engineer function in dbsys.
>>Then it will update a target DB, in what I call a brute force method, by
>>simply using if exsists and so on.
>>It basicly creates a script to update every table regardless of the state
>>of the target DB.
>>I can send you the file if you would like to check it out, it works great
>>for me.
>
> Could you also be kind enough to send it to me? I will have a need for
> such a procedure very shortly.
>
> patabc at ozemail.com.au
>
> Thank you,
> Pat

Robert,

> Does anybody have code that will look at two tables and generate the
> appropriate alter table statments to make the structures identical?
> Thanks.
>

We use in all our applications DBSYS's reverse engineering procedure. In one
module which is called at the beginning of program run, we put all table
structures and possible modifications and at the end of a module all table
structures are updated to recent table structure. This is possibly a method
which you are looking for.

Here is link to my reply in one of previous threads - maybe you find there
something usefull:
http://www.elevatesoft.com/newsgrp?action=searchopenmsg&group=5&msg=57192&keywords=Lajovic*#msg57192

Regards
Iztok Lajovic