Skip to Content
avatar image
Former Member

PowerDesigner : Column Order in Database Syncronization

Hi,

When I apply the PDM changes to Database ( Choice Menu - > Database - > Apply Model Changes to Database ) I would ignore the warning that the columns of a database table are not in the same order as in the PDM.

I don't found any point in the Database Syncronization Dialog Windows to ceck "Ignore columns order"

Is it possible configure PowerDesigner for not view this warning ?

Thanks

Alberto.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jan 06, 2017 at 09:29 AM

    Hello Alberto

    You can change the comparison options, so that the order of columns in a table is ignored. Take a look at the Help Topic "Excluding Objects and Properties from a Compare or Merge".

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2017 at 08:04 AM

    Hello George,

    first of all thanks and happy new year.

    I had looked at what you show me but I have not found what I need to set to ignore the sort order.

    I had looked in Table Options or in Column Options

    You know what voice I have to set ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2017 at 02:21 PM

    Hi Alberto,

    what George is saying - in the merge dialog window, you can deselect the "order" option for columns:

    BR,

    Rafal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 09:23 AM

    Ok ..thanks to all

    have a nice day

    Alberto

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 12:33 PM

    Thanks for taking the time to include a screen shot, Rafal. I was in a rush :)

    Add comment
    10|10000 characters needed characters exceeded