Home > LightSwitch > LightSwitch: Change Default Database Instance

LightSwitch: Change Default Database Instance


I posted How to Change Development Database in LightSwitch which shows how to change the database at the project level. But if you are really bored repeating the process every single time you create a new project and you want to change the default instance of you database, you can follow these steps:

  • Close Visual Studio (IMPORTANT!)
  • Open the Windows Registry i.e. Regedit
  • I am using Visual Studio Ultimate: Go to HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\DataProject
  • Change the value for the DefaultSSEName key with the database instance you want to use. For instance I replace SQLExpress with SQLExpress2k8R2
  • Close Regedit
  • Open Visual Studio
  • Create new Lightswitch project
  • Unload project then right click and select edit project
  • Check SqlExpressInstanceName
Advertisements
Categories: LightSwitch Tags:
  1. No comments yet.
  1. December 22, 2011 at 4:05 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: