Welcome to ModelRight Database Design Tool - Database Modeling Done Right Sign in | Join | Help
in

Compare with Database doesn't detect wrong column order

Last post 11-13-2009, 5:09 AM by hklinge. 4 replies.
Sort Posts: Previous Next
  •  11-09-2009, 5:37 AM 1371

    Compare with Database doesn't detect wrong column order

    I currently evaluate ModelRight 3.5.0.28 for Oracle 10g.

    I have a different column order in one table of the model and the physical database.  When I use "Compare with Database..." (Compare Filter "Table > Column Physical Order" is checked) the difference between model and physical database is not detected.

  •  11-09-2009, 6:07 AM 1372 in reply to 1371

    Re: Compare with Database doesn't detect wrong column order

    Are you sure your diagram is displaying the columns in Generation Order?
    Scott Reynolds
    Technical Support Engineer
    ModelRight, Inc.
    www.modelright.com
    p: (609) 423-9296
    f: (866) 812-3742
  •  11-09-2009, 8:25 AM 1373 in reply to 1372

    Re: Compare with Database doesn't detect wrong column order

    Yes. The Column Order "Generation" is checked in the Property Browser Tab "Table" of the diagram. Switch to Column Order "PK/non-PK" does not change the order of columns.

  •  11-09-2009, 1:08 PM 1374 in reply to 1371

    Re: Compare with Database doesn't detect wrong column order

    Ok.  We have spotted the problem.  Will release a fix later today in Build 3529
    Scott Reynolds
    Technical Support Engineer
    ModelRight, Inc.
    www.modelright.com
    p: (609) 423-9296
    f: (866) 812-3742
  •  11-13-2009, 5:09 AM 1387 in reply to 1374

    Re: Compare with Database doesn't detect wrong column order

    Many thanks for your quick response.

    ModelRight recreate the table with the right column order now. But the triggers of the table are not recreated, so they are missing after Compare with Database.