Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 9 of 9 total |
Schema comparison tools: Suggestions? |
Thu, Feb 23 2006 2:53 PM | Permanent Link |
Sam Jones | Hello all!
I have an old DBISAM 4 db (from over a year ago), and a new one. The schemas are similar, but not the same. Is there a schema comparison tool I can use to spot the differences? (I thought of going table by table and exporting all the DDL, but there are a lot of tables) Thanks!! |
Thu, Feb 23 2006 3:07 PM | Permanent Link |
Jeff Cook | Sam Jones <sjones9@gmail.com> wrote on Thu, 23 Feb 2006 14:53:46 -0500
>Hello all! > >I have an old DBISAM 4 db (from over a year ago), and a new one. The schemas are similar, >but not the same. > Sam Why not just use DBSYS Reverse Engineer to get the schemas in text files and then use something like "Beyond Compare" (free 30 day trial version) to spot the differences. Jeff Cook -- Jeff Cook Aspect Systems Ltd Phone: +64-9-424 5388 Skype: jeffcooknz www.aspect.co.nz |
Thu, Feb 23 2006 3:19 PM | Permanent Link |
Sam Jones | Beyond Compare I have been a licensed user of for years (it is hot!)
Does DBSYS work against a whole dir of tables, or one table at a time? (I need to do the whole stack in one go) |
Thu, Feb 23 2006 4:14 PM | Permanent Link |
Steve Forbes Team Elevate | Hi Sam,
You can choose a whole dir, or any combination of tables to reverse engineer in DBSYS. -- Best regards Steve "Sam Jones" <sjones9@gmail.com> wrote in message news:D4AEACE2-2A63-458D-ACC0-E417A3AB9A5E@news.elevatesoft.com... > Beyond Compare I have been a licensed user of for years (it is hot!) > > Does DBSYS work against a whole dir of tables, or one table at a time? > > (I need to do the whole stack in one go) > |
Thu, Feb 23 2006 5:06 PM | Permanent Link |
Sam Jones | Thanks!
Will check it out. |
Thu, Feb 23 2006 5:14 PM | Permanent Link |
Michael Baytalsky | Hi Sam,
You can try our Context Database Designer. http://www.contextsoft.com/products/dbdesign You can reverse engineer two databases into two schemas and then use Compare Schemas to compare them. You might find the tool useful for other things too Trial version will allow you to compare and is fully functional otherwise, except it shows watermark on designer window. Regards, Michael Sam Jones wrote: > Hello all! > > I have an old DBISAM 4 db (from over a year ago), and a new one. The schemas are similar, > but not the same. > > Is there a schema comparison tool I can use to spot the differences? > > (I thought of going table by table and exporting all the DDL, but there are a lot of tables) > > Thanks!! > |
Thu, Feb 23 2006 10:25 PM | Permanent Link |
Steve Gill | >You can try our Context Database Designer. >http://www.contextsoft.com/products/dbdesign > >You can reverse engineer two databases into two schemas and >then use Compare Schemas to compare them. You might find >the tool useful for other things too Trial version will >allow you to compare and is fully functional otherwise, except >it shows watermark on designer window. I haven't used Context Database Designer for comparing schemas but I just wanted to say it is a great product! Regards, SteveG |
Fri, Feb 24 2006 10:40 AM | Permanent Link |
"David Farrell-Garcia" | Steve Gill wrote:
> I haven't used Context Database Designer for comparing schemas but I > just wanted to say it is a great product! > I am using v2 beta and it is a great product and if you used it to create your original schema then keeping your database structure updated is automatic with a line or two of code. |
Mon, Aug 14 2006 8:51 AM | Permanent Link |
Damien Collings | Sam Jones <sjones9@gmail.com> wrote:
Hello all! I have an old DBISAM 4 db (from over a year ago), and a new one. The schemas are similar, but not the same. Is there a schema comparison tool I can use to spot the differences? (I thought of going table by table and exporting all the DDL, but there are a lot of tables) Thanks!! >> You can try my component. You choose a source folder and ONE OR MORE TARGET FOLDERS that you wish to compare your source against. The system then looks for the target folders and performs an sql based table restructure,compare and/or merge. It exists as a component which you can drop into any delphi app and call a compare/restructure each time your application starts. It has full event driven restructuring options allowing you to display progress, obtain/modify the sql's it generated and abort. Options also exist for backing existing files before compare/restructure. I highly recommend you look at it, it has been used in three commercial products very successfully for this type of use. It is also widely used for mass source target operations for inhouse datastores when multiple datasets need to be upgraded with the touch of a button. It can also completely reorganise your field ordering based on source, target , alphabetic or index optimised/alphabetic. You will need to contact me at support@bwsoftwaretools.com should you require the source. Home: www.bwsoftwaretools.com Download: http://www.bwsoftwaretools.com/f/setup.exe Kind Regards, Damien Collings. BW Software Tools. |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |