The Admin Guide has a section called 'Migrate Gallery Server Pro to a new location' that tells you what you need to do. I just reviewed it and noticed the wording could be a little clearer, so I updated it. Since it may be a while before I post the updated version of the guide, here is the revised text:
Migrate Gallery Server Pro to a new locationFollow these directions for transferring an existing installation of Gallery Server Pro to another web application. The new web application may be on the same server or a new server.
1. Copy the web application files to the destination.
2. Use Internet Information Services (IIS) Manager to configure the new directory as a web application, ensure it is running under ASP.NET 4.0 or higher, and – for IIS 5/6 – has default.aspx specified as the default document.
Note: If you encounter an error about permissions, use Windows Explorer to give the user account IIS is running under modify permission to the web directory (ex: C:\inetpub\wwwroot\galleryserverpro). Refer to the section Configuring NTFS Permissions In Microsoft Windows for more information.
3. If necessary, move your media files to the new location.
4. If you are using SQL CE, then you already copied the gallery data, since it is in the file App_Data\Galleryserverpro_Data.sdf. Skip the next step.
5. If you are using SQL Server and you need to migrate the data to another instance of SQL Server, you have a few options:
• Use the tool built in to SQL Server for detaching / backing up and re-attaching / restoring the Gallery Server Pro database. Refer to your SQL Server documentation for more information.
• Use the tool built in to SQL Server to backup and restore the database. Refer to your SQL Server documentation for more information.
• Use the backup function in Gallery Server Pro to back up the data to an XML file, then use the restore function at the destination gallery. Refer to the relevant section in this guide for creating a backup file and restoring it.
6. If necessary, update the SQL Server connection string in web.config.
7. Use your web browser to navigate to your new gallery. If the media files are stored in a new location, you may need to update Gallery Server Pro so that it knows where your files are. This is on the Media Objects - General page in the Site administration console.
Roger Martin
Creator and Lead Developer of Gallery Server Pro