February 2009 - Posts

Webcast on BizTalk Server and Team Foundation Server
26 February 09 09:25 PM | Johan Hedberg

I haven't blogged about it, though Mikael has mentioned it, but in conjunction with the BizTalk User Group Sweden meeting I released a webcast about how to use BizTalk Server 2009 Beta 1 together with Team Foundation Server 2008 to automate build and deployment of your BizTalk Server based solutions, it's on channel9, check it out. The slides from the usergroup meeting, dealing with the samt topic as well as the news around BizTalk Server 2009 Beta are here. Also Mikael has an article, detailing the solution, and making available the downloadable code.

Cleanup BizTalk Servers MgmtDb
24 February 09 09:27 PM | Johan Hedberg | 2 comment(s)

I've previously blogged about cleaning (emptying) the MsgBox database, something that can be useful in some scenarios, like development and test. While looking for something else the other day I found information about an equally useful procedure, again mainly in an development environment. Speaking for myself I can say that there has been a number of time where I have just wanted to start from a clean slate with my development BizTalk Server installation. Just remove all ports and other deployed artifacts and start from a clean slate. Do NOT run this in production, and be careful that this is REALLY what you want even when running it in another environment.

According to the documentation:
In the BizTalk Management (BizTalkMgmtDb) database, there's a stored procedure named dbo.adm_cleanupmgmtdb. If you do run this stored procedure, all the entries in the database will be deleted.

It was documented in this article, which wasn't really on topic with the other content of the page: http://msdn.microsoft.com/en-us/library/aa561960.aspx

Nostalgic off-topic link: For some reason I always come to think about the starting sequence for "Anslagstavlan" when talking about clean slates. This link is completely irrelevant to BizTalk, it's swedish television from the 80's.

Filed under: ,

This Blog



    Twitter Updates

      Follow me on twitter


      Feedburner Subscribers

      Locations of visitors to this page


      All material is provided AS IS voiding any thinkable or unthinkable effect it might have for any use whatsoever. There... is that clear enough ;)