tag:blogger.com,1999:blog-3369503819828617336.post1702681768698925665..comments2024-03-16T06:54:24.994+01:00Comments on Yet Another Dynamics AX Blog: Create a new Baseline Database for AX2012tommy.skauehttp://www.blogger.com/profile/13189067870996112658noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-3369503819828617336.post-27688109871138165602013-06-03T15:25:38.601+02:002013-06-03T15:25:38.601+02:00Dude, lol... you should blog about it instead hide...Dude, lol... you should blog about it instead hide it in a comment here. ;-)<br /><br />Perhaps I will blog about it. It makes perfect sense to do what you just describe, and I will try it myself. <br /><br />Thanks for sharing!tommy.skauehttps://www.blogger.com/profile/13189067870996112658noreply@blogger.comtag:blogger.com,1999:blog-3369503819828617336.post-11629443979278107622013-06-03T14:35:15.613+02:002013-06-03T14:35:15.613+02:00Ok so, using Baseline to install updates from SYP/...Ok so, using Baseline to install updates from SYP/ISV/VAR is actually very good. Not sure why I didn't use this before. Especially when ms sends us a Hotfix that is the size of a CU.<br /><br />Before I install anything I take a database backup, and instead of initialising the model store like you outlined I instead restore my backup over my (new/old/variable) baseline. Development environments don't have much data anyway.<br /><br />Now I run the import into my development database, layer by layer go into Tools- Code Upgrade - Detect upgrade conflicts (you should run a full compile before I think). That will catch most problems, you will still struggle with SSRS reports changed underneath you. And you still can't be sure all is well before a full xpp compile to catch method parameter changes. But overall - it helps you catch things quickly.<br /><br />(Tip on reports - if you decide you don't want to upgrade it: On the DP/Controller classes right click - add ins - open in new window - open old layer, you can xpo this and import it back to overlayer upgrade changes you don't want)<br /><br />I also make private projects with for example SYP/ISV intersections for spot checking. Try it on the next big hotfix or partner update you get.Lurkerhttps://www.blogger.com/profile/09075692374705049318noreply@blogger.comtag:blogger.com,1999:blog-3369503819828617336.post-77536135249254356832013-05-22T16:19:36.431+02:002013-05-22T16:19:36.431+02:00Hehe... I was actually planning on testing this ou...Hehe... I was actually planning on testing this out myself. I haven't yet fully tested the use of Baseline. I once tried to fill it with models and I started to get all sorts of errors, so I spent my energy elsewhere. I've been planning to look more closer into it, because the "old" concept is a very strong one when you need to merge code within AX. ;-)tommy.skauehttps://www.blogger.com/profile/13189067870996112658noreply@blogger.comtag:blogger.com,1999:blog-3369503819828617336.post-69333348865793235762013-05-22T16:16:40.501+02:002013-05-22T16:16:40.501+02:00Nevermind I found my problem, Ax didn't see th...Nevermind I found my problem, Ax didn't see the baseline DB because the server config was wrong. We changed the database servers a while back. On the config application you can change what server your database is on. But if you save the config to file you will see that the baseline database has its own server property. And on my config that still pointed to the old server.<br /><br />So much time wasted, when in doubt - look at the config file and don't trust the front end app :/<br /><br />This is why I normally lurk instead of post, give it a bit of time and you find the answer yourself.Lurkerhttps://www.blogger.com/profile/09075692374705049318noreply@blogger.comtag:blogger.com,1999:blog-3369503819828617336.post-76616997300840533702013-05-22T12:36:38.106+02:002013-05-22T12:36:38.106+02:00Tommy have you ever used the baseline db to identi...Tommy have you ever used the baseline db to identify changes a var or isv made to their model? I re-enabled the baseline db as per your instructions. Then I imported an updated model from an isv into the baseline db with powershell. From in Ax I can't actually see any changes. Compare doesnt show an "old isv" option. and the upgrade tools see nothing. I even tried openeing up utilidelementsold - empty. I changed the views in sql for the *old queries to point to my baseline db but still nothing in ax.<br /><br />So in short: is it possible to use the baseline DB to see what changes a var/isv have made to their model between releases?Lurkerhttps://www.blogger.com/profile/09075692374705049318noreply@blogger.com