sqlhost Wiki & Documentation Rss Feed

New Comment on "Database Publishing Services"

domainscanners — Wed, 18 Nov 2009 21:12:29 GMT

Guys can we have an install guide for SQL Server 2008 please?

New Comment on "Database Publishing Services"

domainscanners — Thu, 12 Nov 2009 23:24:20 GMT

Is this compaitible with SQL Server 2008? If so where can I find install instructions please?

New Comment on "DPW Known Issues"

base — Wed, 07 Oct 2009 11:08:58 GMT

@HarryBob, I noticed the same. Always do a search and replace for 'END;' to 'END'. It is not only on views. Great product by the way, if you read the known issues and act to it, it works very well from 2005 to 2000.

New Comment on "DPW Known Issues"

harrybob — Wed, 07 Oct 2009 03:13:53 GMT

has anyone else noticed that sometimes the script contains a semi colon at the end of a create view statement and sometimes it does not. This causes sql server 2000 to throw an error

New Comment on "UploadAndExecute"

Raghad84 — Mon, 07 Sep 2009 11:10:25 GMT

Hello, I have the same error :Opening url C:\inetpub\wwwroot\newClub.mdf.sql Connecting to SQL Server database... An error occured: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'objects', database 'mssqlsystemresource', schema 'sys'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.runsql_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) can any one help in th solution, Thanks

New Comment on "DPW Known Issues"

vince144 — Mon, 18 May 2009 20:19:37 GMT

open a command prompt from here C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2 as the sqlpubwiz is not in the path.

New Comment on "DPW Known Issues"

elkinsenv — Thu, 07 May 2009 16:43:59 GMT

I can't use the sqlpubwiz script because my computer does not recognize this as an internal command at the c:\ prompt. Does anyone know what I am doing wrong?

New Comment on "UploadAndExecute"

bbrooks — Wed, 29 Apr 2009 19:28:09 GMT

I am getting a frustrating error message i cant fix please help. here it is Opening url C:\inetpub\wwwroot\newClub.mdf.sql Connecting to SQL Server database... An error occured: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'objects', database 'mssqlsystemresource', schema 'sys'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.runsql_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)

New Comment on "Database Publishing Wizard"

neerajsoni — Fri, 17 Apr 2009 08:20:43 GMT

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

New Comment on "Localized versions of 1.1"

boizan — Fri, 23 Jan 2009 04:10:05 GMT

I am using Database Publishing Wizard, but it is not working for me. When I select the initial option "Specify Server Information" I wrote: localhost, and it did not work. I lefte this box empty, it did not work. I wrote down the address of the site I want to publish (http://localhost: 8494/Database), it did not work too. Allways I get the error:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider). What can I do to fix this problem?

UPDATED WIKI: UploadAndExecute

Hvasishth — Thu, 24 May 2007 02:32:34 GMT

Upload T-SQL and execute at your hosting provider using an ASP.NET page

With this approach, you can use the Database Publishing Wizard to generate a T-SQL file from your local database. Then, you can upload the script to your hosting provider, and use the sample ASP.NET page provided to execute this file.

This approach is useful in the following circumstances:

Your hosting provider has not deployed the Database Publishing Services, enabling simple publishing of your SQL Server database
Your hosting provider does not have a T-SQL script execution window or the T-SQL script generated by the Database Publishing Wizard is too large to paste into the T-SQL script execution window

Below are the instructions to use this approach:

Run the Database Publishing Wizard to generate a T-SQL script file for your local database
Using FTP (or another approach if applicable), upload this T-SQL file to your hosting account
Download the sample ASP.NET page by clicking on this link: RunSQL.aspx
Edit the ASPX page and change the values of the variables fileUrl and connectionString as follows:

fileUrl should be the url of the T-SQL file you uploaded. For example if your domain name is www.mydomain.Com, then the url would be http://www.mydomain.com/File.Sql
connectionString should be the connection string of your hosted SQL Server database

Upload the ASPX page to your hosting account
Point your web browser to the ASPX page you uploaded. When this page has completed loading, your database should now be populated in the remote SQL Server database
Important: Delete the T-SQL file and ASPX page in your hosting account. This will prevent others from reading your data or tampering with your database.

UPDATED WIKI: Home

alexd — Tue, 03 Apr 2007 22:48:09 GMT

News Feeds
The goal of the SQL Server Hosting Toolkit is to enable a great experience around SQL Server in shared hosting environments.

The toolkit will eventually consist of a suite of tools and services that hosters can deploy for use by their customers. It will also serve as an incubation vehicle for tools that hosting customers can download and use directly, regardless of whether their hoster has deployed the toolkit. See the Project Roadmap for details on where we're going.

For Hosting Customers

The Database Publishing Wizard makes it easy to upload databases to hosters, or generate T-SQL from the objects and data in your database.

For Hosters

The Database Publishing Services are a set of ASP.NET web services you can easily deploy to make it simple for your customers to deploy SQL Server databases into your environment.

If you're interested in meeting the folks at Microsoft behind this project, check out the Hosting Toolkit Team.

Also, see other SQL Server projects on Codeplex

UPDATED WIKI: Database Publishing Services

alexd — Tue, 03 Apr 2007 22:47:31 GMT

Database Publishing Services

Download the precompiled release (1.1)
Download the shared source release (1.1)

As a hoster, you can use Database Publishing Services to enable your customers to easily deploy their SQL Server databases into your environment with tools such as the Database Publishing Wizard.

UPDATED WIKI: Database Publishing Services

alexd — Tue, 03 Apr 2007 22:44:03 GMT

Database Publishing Services

Download the precompiled release (1.0)
Download the shared source release (1.1)

As a hoster, you can use Database Publishing Services to enable your customers to easily deploy their SQL Server databases into your environment with tools such as the Database Publishing Wizard.

UPDATED WIKI: Localized versions of 1.1

alexd — Tue, 03 Apr 2007 22:32:12 GMT

Localized versions of SQL Server Database Publishing Wizard 1.1

UPDATED WIKI: Localized versions of 1.1

alexd — Tue, 03 Apr 2007 22:31:17 GMT

Localized versions of SQL Server Database Publishing Wizard 1.1

UPDATED WIKI: Database Publishing Wizard

alexd — Tue, 03 Apr 2007 22:31:06 GMT

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:

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.
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.

Full Documentation

UPDATED WIKI: Database Publishing Wizard

alexd — Tue, 03 Apr 2007 22:30:10 GMT

Database Publishing Wizard

Download the Current Release (1.1)
Localized versions of 1.0

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.
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.

Full Documentation

UPDATED WIKI: other SQL Server projects on Codeplex

alexd — Fri, 30 Mar 2007 01:09:33 GMT

Other SQL Server resources on Codeplex

SQL Server samples

UPDATED WIKI: Home

alexd — Fri, 30 Mar 2007 01:07:33 GMT

For Hosting Customers

The Database Publishing Wizard makes it easy to upload databases to hosters.

For Hosters

The Database Publishing Services are a set of ASP.NET web services you can easily deploy to make it simple for your customers to deploy SQL Server databases into your environment.

If you're interested in meeting the folks at Microsoft behind this project, check out the Hosting Toolkit Team.

Also, see other SQL Server projects on Codeplex