Great SQL Server Express tool

I was trying to build a site for someone over the weekend and I ran into a dilemma.  The site I was using built itself against a .mdf file (SQL Server Express Database file), which cannot be published to remote hosting sites as per its own restrictions.  So, I wanted to go ahead and migrate the whole database to a full fledged copy of 2005 Sql Server.  Unfortunately Visual Studio 2005 doesn’t come with this as a standard feature, BUT you can get it from MS for free and install it as an add-on.

The database publishing wizard basically lets you do a dump of the database into a .SQL file, which then can be run against other database to import the data and structure.  This just saved me hours of re-work, so if you ever need to export data from a .mdf file… I highly recommend this tool.

There is a tutorial here:

Post a comment or leave a trackback: Trackback URL.

Leave a Reply

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

You are commenting using your 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: