Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
Duplicating database stucture |
Fri, Apr 25 2008 11:56 AM | Permanent Link |
"Robert" | Does anybody have code that will look at two tables and generate the
appropriate alter table statments to make the structures identical? Thanks. Robert |
Fri, Apr 25 2008 12:27 PM | Permanent Link |
A. Ibarra | "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. |
Fri, Apr 25 2008 3:58 PM | Permanent Link |
"Robert" | "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 |
Thu, May 15 2008 4:11 AM | Permanent Link |
Pat | >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 |
Thu, May 15 2008 6:35 AM | Permanent Link |
"Hüseyin Aliz" | 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 |
Thu, May 15 2008 9:03 AM | Permanent Link |
"Iztok Lajovic" | 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |