by Michael Wolski
25. February 2010 15:14
Visual Studio 2010 includes a nifty new feature where you can publish your database to a Host, directly from within the IDE. You initiate this by right-clicking on your database connection in the Server Explorer, and selecting Publish to Provider. The entire process is guided by a Wizard that is loaded with some nice options for getting your database from one place to another. But the question today is "What do I need to do in order to be my own host so I can publish to my own server?"
Note: You may want to check our our companion article that shows how to Setup a Host server for Web Deployment. The two together make deploying web applications in Visual Studio a snap!
After some digging it became apparent that Visual Studio's database publishing wizard is written to utilize a series of web service calls. These calls define various operations that can be implemented by anyone who can write web services. After some more digging it became apparent that there is already an implementation of these services that anyone can use to provide basic database services to Visual Studio. These services are called the SQL Server Database Hosting Services, and you can download an implementation of them at the following sites:
Read more after the break: More...
by Michael Wolski
20. February 2010 09:58
As most of you know, Visual Studio 2010 has moved into RC territory and sports a nifty GoLive license. This means you can download and use the RC for shipping projects. With this release of Visual Studio, we at DigitForge are looking to fully leverage some of the web and SQL deployment tools built into the VS client. The tools/wizards themselves are pretty straightforward. But in the next upcoming series of blog posts I will describe how to implement the server-side portion of these tools. Basically we will be looking at supporting these tools from a Hosting perspective.
Web Deploy Tool - this is how you support web site publishing.
SQL Publishing Services - this is how you support SQL publishing.
Each upcoming blog post will outline how to find and install these on your server. Come back soon!
Subscribe