For recognizing Modified Objects

minty_friend

Hi,

I want to know which is the best and fastest method to find the modified objects between two Database,

Actually I have a scenario in which I am having 2 database from a same client, for ex one old databse is of "may 2012" and another is "October 2012", Now what i have to do is to find out the list of modified objects between two DB's.

can anyone help me in this, which is the easies and fastest way of doing this...????

mohana_cse06

You should have easily copied all objects to excel and comapred with excel formulas using date and time..

himanshi

hello, try this...
first you open the datbase "may 2012" and in object designer click on all to filter all the objects then filter them through modified column by pressing ctrl+F7 nad set the modified filter to yes....
then export all the objects and save them
then open another databse öctober 2012" and select all then again filter them through modofied column and set it to yes. and export all objects and save them
then make a new database and import all the objects in it.......
hope it will solve ur problem.....

minty_friend

Thanks for the reply,

The problem with the solution you provide me does not work in my case as the client has modified the objects by including an additional language into every object, now the problem is that Date and time and Modified Flag is ticked but in terms of code there is no change.

this is the irony part, I want the list of the objects which is modified in terms of code. :-k :-k :-k

Luc_VanDyck

Via Tools -> Language Module -> Export, you can export AND delete all language elements of your NAV objects. Then you can export these objects to text (which contains no captions) and do the compare on these set of objects.

krzychub83

Hi,
I am assuming that you are using some restored dev copies of those databases.

1. Please use steps provided by Luc Van Dyck to remove additional language.
2. Update Object table's fields listed by me, so they would match values from second database. This way you shouldn’t get a list of all objects instead of only those ones only modified:
- Date
- Time
- Modified
3. Import both databases’ objects to Developer's Toolkit (Developer's Toolkit can do it from open NAV's client or from exported objects as txt. This is an additional tool which you can download from partner source and if I remember it correctly from Mibuso download section too). There you can compare two different database versions to each other. You should get a nice picture of all changes made between those databases. Please be aware that Pages/Reporting Services Layout is not supported by Developer's Toolkit. However because you posted this issue in the Classic NAV folder, I would bet that this is not the case here.

If you need to compare Pages/Reporting Services Report Layout then you need to export them as TXT and compare in any text compare program.

Unfortunately this tool is not continued (as far as I know it)… It helped me a lot... It is very usefull in case where database has been heavily modified by different persons. You can use it to very easly trace where object/field/function had been used and for what. You can use it to compare different versions of databases and marge them... etc.

Good luck
KB