Skip to content

Instantly share code, notes, and snippets.

@jasondavidcarr
jasondavidcarr / SitefinityStaticContentMigration.sql
Last active August 29, 2015 14:02
Migrate static content (images and documents) from one Sitefinity 4, 5, 6 installation to another http://www.perbyte.com/blog/Migrating-Sitefinity-Static-Content/
INSERT INTO SitefinityNew..sf_chunks (sze, ordinal, file_id, dta, voa_version)
SELECT c.sze, c.ordinal, c.file_id, c.dta, c.voa_version
FROM SitefinityOld..sf_chunks c
WHERE c.file_id IN (SELECT file_id FROM SitefinityOld..sf_media_content)
INSERT INTO SitefinityNew..sf_media_content
(votes_sum, votes_count, visible, views_count, vrsion, url_name_, title_,
status, source_key, publication_date, post_rights, ownr, original_content_id,
last_modified_by, last_modified, content_id, expiration_date, email_author,
draft_culture, description_, default_page_id, date_created, content_state,
@jasondavidcarr
jasondavidcarr / HttpHandlerBase.cs
Last active August 29, 2015 14:02
Base class for custom IHttpHandler implementations that need access to Aptify. http://www.perbyte.com/blog/Creating-a-Generic-IHttpHandler-Class/
using System;
using System.Net;
using System.Web;
using Aptify.Framework.Application;
using Aptify.Framework.DataServices;
using Aptify.Framework.Web.eBusiness;
/// <summary>
/// Base class for custom <see cref="IHttpHandler"/> implementations that need access to Aptify.
/// </summary>