SQL Server Deployment Goodies…

I just spent most of the afternoon on a pointless keyboard puncher. I only wanted to move a SQL Server Express database from one place to another which is one of those things that should be straightforward but for one reason or another (which I won’t bore you with) it wasn’t and took me a few hours of messing about to get it to work.

So, it was with a mixture of delight and that feeling you get when you find something in the sales for half the price you paid for it last week that I read Scott Guthrie’s post about deploying Sql Server 2005 databases.

Microsoft are on the way to releasing a Database Publishing Wizard (RC1 is available for download now) which scripts both the schema and data of your SQL Server database.

They also provide an aspx page that you can use to install your db when you don’t have full access to the server.

That would have saved me a fair bit of bother this avo…

Advertisements

3 Responses to “SQL Server Deployment Goodies…”


  1. 1 scottgu January 12, 2007 at 11:49 pm

    Sorry we didn’t have this sooner – but I hope it can help for the future.

    Thanks,

    Scott

  2. 2 Graham Pengelly January 12, 2007 at 11:53 pm

    Don’t worry Scott, I’ll forgive you 😉


  1. 1 SqlServerForum.org » Blog Archive » SQL Server Deployment Goodies… Trackback on February 7, 2007 at 12:34 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





%d bloggers like this: