The Problem: Every time you attempt to run Microsoft’s excellent Database Publishing Wizard Utility you get the following error after you enter your login information could not load file or assembly microsoft.sqlserver.batchparser
The Cause: This problem can be taken literally – Microsoft.SqlServer.Batchparser is not installed on your computer.
The Solution: Go To this link on the Microsoft site and download the Microsoft SQL Server 2005 Management Objects Collection. Then install the MSI
That’s it!
For those of you who are not familiar with the tool, the Database Publishing Wizard is a free tool Microsoft made which allows you to generate sql scripts of existing databases, which speeds up moving them around on third party hosting better than any other method.
This post originally appeared on the Stronico blog – with the absorption of Stronico into Digital Tool Factory this post has been moved to the Digital Tool Factory blog