Question Re: PowerDesigner : Column Order in Database Syncronization in Technology Q&A

PowerDesigner : Column Order in Database Syncronization

asoft — Sat, 31 Dec 2016 10:26:50 GMT

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.

Re: PowerDesigner : Column Order in Database Syncronization

GeorgeMcGeachie — Fri, 06 Jan 2017 09:29:44 GMT

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".

Re: PowerDesigner : Column Order in Database Syncronization

asoft — Tue, 10 Jan 2017 08:04:59 GMT

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 ?

Re: PowerDesigner : Column Order in Database Syncronization

Former Member — Tue, 10 Jan 2017 14:21:12 GMT

Hi Alberto,

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

BR,

Rafal

Re: PowerDesigner : Column Order in Database Syncronization

asoft — Wed, 11 Jan 2017 09:23:30 GMT

Ok ..thanks to all

have a nice day

Alberto

Re: PowerDesigner : Column Order in Database Syncronization

GeorgeMcGeachie — Wed, 11 Jan 2017 12:33:11 GMT

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