Documentation for new Gallery

Jan 4, 2012 at 5:05 PM

The documentation for setting up a local Gallery (here: references the new Gallery at github:

However, the github site has instructions for building it, but not for setting it up on a server.

Is the documentation for setting up IIS and SQL Server on the local Gallery page still more or less correct, or does new Gallery have a different install process?

Jan 9, 2012 at 6:10 PM

Bump for great justice.

Jan 9, 2012 at 6:21 PM

There shouldn't be much needed to set up an instance of the github gallery, as it creates and migrates the database automatically. It's supposed to 'just run'.

Jan 9, 2012 at 8:01 PM

Thanks for the followup. As far as "just run", on my machine at least I need to adjust security permissions before the powershell build script would be allowed to execute.

For the rest, you're saying that the build process creates and migrates a database as a side-effect? Does it assume the database is running on the build machine? Is the expect use case that one builds on the machine that IIS is running on? How does one configure a database running on a separate box (for example)? Is it just a matter of cracking open the Solution and updating the connection string?

It's fine if at this point multiple-box deployments aren't supported, but it would help if the assumptions being made in order for things to "just run" were clearly spelled out. The documentation for the previous version of the Gallery was very explicit and helpful, and so I was expecting to find a similar document.

Jan 9, 2012 at 8:36 PM

Disclaimer: I'm not the expert on this topic, and hopefully others who know more can jump in.

The database creation/migration actually happens at runtime (on App Start) and not build time. Yes, I do think that for the most part you just need to update the connection string to point to another SQL server.

Note that is running those bits today, and the DB is in SQL Azure.

Of course, this info should all be on a wiki page on Someone just needs to write it :)

Jan 9, 2012 at 9:52 PM

From my experience (I've built about 15 galleries from source now), you need to build the gallery on a server with the following installed:

  1. IIS 7 or above
  2. Azure SDK
  3. Local SQL Express instance named SQLEXPRESS (required even if you change the connection string in the web.config to point at a remote SQL instance, not sure why yet)

I put together a very basic PS script to wrap some of the build configuration (such as updating the connection string), feel free to use it :  It references as a sub-repository, I can't promise it will work first time for you though.....!

To deploy, it's pretty much a manual task from what I've seen.  Set up website, copy files, backup/restore database, update connection string.  You could always run the build script directly in the environment you want it deployed, but it's unlikely you'd want to install all the dependencies required for the build to run (such as SQL Express).




Jan 9, 2012 at 9:53 PM

In addition, you can only build the gallery on Windows 7 or Windows Server 2008.  Windows XP is not supported due to the Azure SDK dependency.