Post reply

Database Structure Compare Tool

  • March 17, 2005 at 6:25 am

    #88296

    Hi !

    What's the best tool for database structure compare ?

    I've tried RedGate SQL Compare, but is to slow.

    Lockwood SQLDiff v2.3 has bugs.

    The best tool I've found so far, is ApexSQL (but the trial is over, eheheh). Is there another one better than this ?

    Thanks in Advance,

    Regards,

    Pedro Martins


    Rechousa,
    V.N.Gaia
    Portugal

  • March 17, 2005 at 7:03 am

    #547520

    Give Speed Change Manager a shot from Imceda (www.imceda.com)

  • March 17, 2005 at 8:44 am

    #547570

    I use AdeptSQL's SQLDiff - it is smokingly fast and very affordable.  (http://www.adeptsql.com)

    I use this tool each time I deploy a new release.  I compare my production databases to my QA server where we have all of the final scripts and adjustments made.  This way I can find out if we didn't deploy something and get it out before we turn the app back on.

    Bill

     

    Ad maiorem Dei gloriam

  • March 18, 2005 at 7:17 am

    #547771

    We use Imcedas Speed Change Manager and are really happy with it.

    It has saved us considerable time building migration scripts and has identified changes that we would have missed when building our migration scripts manually.

    Mike

  • March 18, 2005 at 7:33 am

    #547776

    A couple of guys here use Embarcadero's Change Manager, and they seem to really like it.  Simple, and quick.  Plus it does cross-platform (Oracle, DB2, etc.) where others won't.

  • March 18, 2005 at 9:24 am

    #547811

    I use AdeptSQL Diff and have been very happy with it.

  • March 18, 2005 at 9:56 am

    #547829

    On a side note... Lockwood Technologies became ApexSQL some time ago. So the ApexSQL one is obviously much newer.

    K. Brian Kelley
    @kbriankelley

  • June 15, 2005 at 9:53 am

    #565755

    We have been using Embarcedro ER/Studio ( I have been told that this has the basic components as Change Manager) for producting upgrade script , and the method of creating a new column is by

    - Drop all RFI referencing table

    - Rename table to some temp name

    - Create new table

    - INSERT into new table select from temp data

    - ADD RFI / Indices

    but I would like a product that simply produces ALTER TABLE ADD/DROP/ALTER COLUMN statements that have been in existance from SQL 2000 ( I think )

    The old method has worked well in the past , but in a SQL 2005 demo , the new improved replication automatically supported columns that were changed using ALTER TABLE, without any other interaction which was very impressive !  

  • June 16, 2005 at 1:34 am

    #565990

    There is free tool called dbMaestro

    http://www.dbmaestro.com/products/ActivatedbMaestro.aspx

    http://www.sqlservercentral.com/columnists/dasanka/reviewdbmaestro.asp




    My Blog: http://dineshasanka.spaces.live.com/

  • June 20, 2005 at 8:45 am

    #566758

    Hi All,

    I'd go with Red Gate SQL Compare for accuracy reasons. It will attempt to alter your columns if it can rather than trying to rebuild the table every time, provided you haven't enabled the switch to preserve column order. Of course, in that case, it's going to go through the process above in dropping the table and all dependent objects and rebuilding the table and copying the data back. This can be a headache in tables with millions of rows of data!

    Regarding the speed of it, it's fairly quick since version 3. Version 2 was  slow indeed.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply