This article provides a quick overview of how to move the Kiln Database. This function is used often while 'Moving Kiln to Another Server' or in combination the articles related to moving the database.
To move the Kiln database, move the database to your new database server.
kilnConnectionString in Kiln’s
Web.config file to read the correct connection string for the new database.
In IIS7, you can even edit this value directly from the IIS configuration editor by going to the
connectionStrings section of the Kiln application.