Database Publishing Wizard

Download the Current Release (1.1)
Localized versions of 1.1


The Database Publishing Wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server.

The tool supports two modes of deployment:
  1. It generates a single SQL script file which can be used to recreate a database when the only connectivity to a server is through a web-based control panel with a script execution window.
  2. It connects to a web service provided by your hoster and directly creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a command-line interface. In addition, it can integrate directly into Visual Studio 2005 or Visual Web Developer 2005.

Last edited Apr 3, 2007 at 11:31 PM by alexd, version 43

Comments

neerajsoni Apr 17, 2009 at 9:20 AM 
I tried it with Sql Server 2008 (express) but I am getting /BeginPublish related error just after OnPostAuthenticateRequest() call. I am using Studio 2005 website project type to run.

ERROR page on URL http://localhost:1896/DPS11/Publish/Service.asmx/BeginPublish

Server Error in '/DPS11' Application.
--------------------------------------------------------------------------------
Request format is unrecognized for URL unexpectedly ending in '/BeginPublish'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Request format is unrecognized for URL unexpectedly ending in '/BeginPublish'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[InvalidOperationException: Request format is unrecognized for URL unexpectedly ending in '/BeginPublish'.]
System.Web.Services.Protocols.WebServiceHandlerFactory.CoreGetHandler(Type type, HttpContext context, HttpRequest request, HttpResponse response) +405961
System.Web.Services.Protocols.WebServiceHandlerFactory.GetHandler(HttpContext context, String verb, String url, String filePath) +212
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +193
System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +93
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

drewbkilla Sep 24, 2008 at 6:49 PM 
Does this work in the opposite sence of use. For example. I'm hosted with a horrible hosting company that by policy, they cant just detach and copy my SQL SB to my FTP root for downloading, so im totally stuck without getting my db over to my new monster server that we have in house at my job.

Can this software be used to PULL from my host to my new server?? I tried copying my DB to a script file but that does me no good because it wont import into my new server's SQL db, for what reason I have no idea.,

Should importing the .sql file do the trick on my new server?? I just tried pasting it into a new query window on the new server and it didnt give me an error but I still dont see the new db showing up.

Im totally lost here.

philip_wagenaar Aug 8, 2008 at 2:38 PM 
Has anyone tried this yet with SQL 2008?

bikeman Feb 25, 2008 at 9:53 AM 
Have created a simple 1 table db and tried to publish 'script to file'.
I am getting 'an exception occured... cannot resolve collation conflict between 'latin1 etc etc'
As I am publiching to a file and not another database how can this possibly chuck out a collation error?

guy2005 Oct 22, 2007 at 1:50 PM 
Hi,
My requirement is, I want to create a web setup file in VS which should install the source code and the database in the hosting server. Will i be able to use this sql server hosting toolkit for my requirement?

or tell me how i can achieve my requirement?

Thanks in advance.

owensms Oct 17, 2007 at 11:25 AM 
I was unable to install the wizard. I am asked to provide a registration code for Visual Studio. It tells me it in not registered. I have installed and reinstalled VWD twice. It tells me it is properly registered.

Can anyone tell me what I am doing wrong?

I would like to create a SQL file. I want to test database capability on my web site. Does anyone know of another program that can create an SQL file based on my MDF file?

Regards

Mike

vigk2002 Apr 29, 2007 at 6:22 AM 
Im trying to use the wizard.... can anyone walk me through this? Im a newbie!!

vigk2002 Apr 29, 2007 at 6:21 AM 
Im stuck, i dont know what to enter for the web service address..... i've spent 3 days and can't figure it out......I have my server name and d.b name

what do i do???

Karl

rsocol Apr 10, 2007 at 1:45 PM 
The above link works fine now. Razvan

rsocol Apr 6, 2007 at 11:07 AM 
The page http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A says "The download you requested is unavailable." Why ?

Razvan