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.

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

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.