Compare Development and Production Server

Post Reply
HighKeys
Posts: 117
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Office 365

Compare Development and Production Server

Post by HighKeys »

Hello friends,

i'm woundering about the best practice how to compare the Datafiles from Dev and Prod Server.


So i develop small changes (like a small rule change, or simple 5 line rule) dirctly in Prod, but bigger projects like a rolling forecast in Dev enviroment.

What is the best way to compare the files and match them togheter?


I just found TM1 Compare, but its a lil bit expansive for this, anyone have a good alternativ?

Thanks and BR
User avatar
gtonkin
MVP
Posts: 1198
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Compare Development and Production Server

Post by gtonkin »

I use an old but trusted program called FolderMatch - there are probably similar newer programs but have not looked.
FolderMatch will show files side by side and line up code that is the same and highlight differences like new lines or changes within lines.
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Compare Development and Production Server

Post by Mark RMBC »

Every developer will hate me for saying this, I hate me for saying this, but good quality documentation and audit of any changes would, in theory, reduce the need to have to compare both environments.

So if you document all changes you should just have to refer to the document to see where dev and prod differ (I have yet to work out what great documentation actually looks like!).

Of course in the real world...
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Compare Development and Production Server

Post by Wim Gielis »

WinMerge ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
HighKeys
Posts: 117
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Office 365

Re: Compare Development and Production Server

Post by HighKeys »

gtonkin wrote: Fri Oct 18, 2019 8:49 am I use an old but trusted program called FolderMatch - there are probably similar newer programs but have not looked.
FolderMatch will show files side by side and line up code that is the same and highlight differences like new lines or changes within lines.

Hi,

Thanks i will check this and come back to the thread :)

Wim Gielis wrote: Fri Oct 18, 2019 9:22 amWinMerge ?
Hi,

same here, i will check this tool and come back :)


Thanks for your help!
User avatar
PavoGa
MVP
Posts: 617
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: Compare Development and Production Server

Post by PavoGa »

Beyond Compare (BC). I've used winmerge, but BC is better at matching up lines without false positives and tons of features. Use it for awhile and you'll throw rocks at winmerge. We have four environments (D, Q, S and P) that our code moves through and BC sessions are easy to setup to allow quick comparisons of code.
Ty
Cleveland, TN
Post Reply