Re: Please help me to slove Database Publishing Wizard error message.

Thomas Sun – MSFT — Wed, 19 Nov 2008 07:48:05 GMT

Hi,

It seems that it cannot load the assembly of SMO (SQL Server 2005 Management Objects).

If so, you can try to download it from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en (Section: Microsoft SQL Server 2005 Management Objects Collection ).

For more information, you can refer to Database Publishing Wizard documentation (http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=DPW%20Documentation&referringTitle=Database%20Publishing%20Wizard).

I look forward to hearing from you.

Please help me to slove Database Publishing Wizard error message.

vbguy4 — Mon, 17 Nov 2008 07:21:25 GMT

Hi, All

I have a big problem for publishing database to remote site. I know how to process to publish database on remote site. I am using VB 2005. I created databaase through sqlextress server. I want to publish my database created by sqlexpress. Then when I use database publishing wizard, I have an error message like follows. If I solve this problem, I know what to do. Please help me to figure this error. The other solution to think is to use sql server studio express. But when I use sql server studio express, it doesn't show that I created through sqlexpress server. I have a sql server 2005. Please let me know how can I publish my database made by sqlexpress server? If I can solve through sql server studio express, then why it doesn't show my database I made. Please advise me. I spent a month to solve this problem. Thanks your help in advance. The following is the error message from Database Publishing Wizard.

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

Configuration and Deployment

Re: Please help me to slove Database Publishing Wizard error message.

Please help me to slove Database Publishing Wizard error message.