We undertake a lot of ASP.Net development, and all too often one of the most time consuming tasks can be moving the finalised web application to our client’s live server. Fortunately Microsoft is aware of this and has created a SQL Server Database Publishing Wizard, which takes care of moving the database schema and data to a remote environment.
Detailed instructions on how to use this new tool can be found on Scott Guthrie’s blog. His blog is quite fascinating so it might be worth checking it out every now and then.
If you’re the type of person who likes to get their hands dirty straight away the download for the Microsoft SQL Server Database Publishing Wizard 1.0 can be found here.