I am using VB 2005. I want to publish a simple test web program. Then I found a good site for using a Database Publishing Wizard. It is http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx. So I followed the example, but the first problem is I can't make a sctript file because the wizard shows select a file to publish and if I select and click next, then is shows the error message as follows. TITLE: Microsoft SQL Server
------------------------------

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Database+Publishing+Wizard&ProdVer=1.1.1.0&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
BUTTONS:

OK
------------------------------
So I cannot continue. I have two questions. Why the wizard does not show to make a script file as a tutorial session mentioned above. and it shows to select a database to deploy. And the other question is why it makes an error.

Please advise me because I already spent a lot of time to host my web. Thanks your help and advise in advance.

Hi,

Are you using SQL Server 2008? If so, Code developed for SQL Server 2005 SMO might not build against SQL Server 2008 without minor modifications.

Backward Compatibility in SMO
http://msdn.microsoft.com/en-us/library/dd206977.aspx

Hi, Mr. Kang

Thank you for your reply. Then I am using Visual Studio 2005 and Sql Express for database. When I select  a data base to publish at the server explorer, then it shows a database name and path that I just chose so if I continue, then it makes an error like that I mentioned above. So I cannot continue to the next step which is to select an output location. Thanks your answer again and thanks in advance.

Having the same problem. I am on sqlserver 2000 and 2005 both of which appear to be supported.