SQL Server Express Development Databases

Coming into a large corporation where it’s not possible to develop against the databases, perhaps because they’re under the control of another department, it can be useful to load a copy into SQL Server Express (it comes with Visual Studio 2005).

You’ll require all the .mdf files which will require stopping the database. Then you can attach to those from SQL Server Express. From there you can do a backup as a baseline.

Advertisements

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