Thursday, March 4, 2010

SQL Server 2008 Master Data Services

Last week I installed SQL Server 2008 Enterprise R2 MDS customer, product, and chart of accounts sample domain models on a virtual x64 Windows Server 2008 sandbox. The same virtual houses Report Server for 2008 with Report Builder 3.0 and SQL Server 2005 with Report Services as well. Install was completed in minutes with no issues. Coincidentally, Report Builder 3.0 has had a make-over and seems more modular and flexible at first pass. Will be looking into report model migration since we are currently using Report Builder 2.0 at this client.

MDS did not strike me as the most intuitive tool to work with, and I did not find as much breadth as I would like. Jury is still out though, since this is the first release since the purchase of this product by Microsoft and I only had a limited amount of time to devote to this initial evaluation task. If anyone out there has success stories to share on MDS shoot me a note/link.

Time for zzzz's.