SQL Server Hosting Toolkit
Microsoft Download Center published Microsoft SQL Server Database Publishing Wizard 1.1 (for hosting costumers) and Microsoft SQL Server Database Publishing Services 1.0 (for hosters).
This toolkit was posted by the SQL Server team on SQL Server Hosting Toolkit project page, it will make it much easier to deploy your SQL solutions remotely to a hosted environment. The toolkit allows you to work with SQL Express, SQL Server 2000, and SQL Server 2005 databases locally, and then easily transfer your schema and data and install them into a shared hosting remote SQL Server account.
One of my favorite feature is the integration into Visual Studio 2005 and Visual Web Developer Express 2005. So you can now right-click on a database in the VS Server Explorer and select "Publish to provider"! ;)
On using the Database Publishing Wizard, there are great posts by Scott Guthrie (General Manager within the Microsoft Developer Division):
- Tip/Trick: How to upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database
- Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)
For more information of the SQL Server Hosting Toolkit, visit the SQL Server Hosting Toolkit project page.
CU tosc
Print article | This entry was posted by tosc on 2007-01-22 at 13:29:44 . Follow any responses to this post through RSS 2.0. |
Tag cloud
administration backup «best practices» books bug ctp «cumulative update» datetime demo dmv ebook humor index indexoptimize integrity kbfix links maintenance «ms sql server 2008» pass performance php reviews «ross mistry» rtm serverproperty «service pack» «service pack 2» «service pack 3» «service packs» sharepoint sp_msforeachdb «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» «sql server builds» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack «stacia misner» t-sql «technical note» tempdb tools version whitepapers