Migrate static content (images and documents) from one Sitefinity 4, 5, 6 installation to another http://www.perbyte.com/blog/Migrating-Sitefinity-Static-Content/

SitefinityStaticContentMigration.sql

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,
approve_comments, app_name, allow_track_backs, allow_comments, lgcy_tmb_strg,
uploaded, total_size, tmb_vrsn, parent_id, ordinal, number_of_chunks, tmb_regen,
mime_type, item_default_url_, inherits_permissions, folder_id, file_path,
file_id, extension, chunk_size, can_inherit_permissions, blob_storage, author_,
approval_workflow_state_, id, voa_class, voa_version, parts_, width, height,
alternative_text_, width2, height2)
SELECT 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,
approve_comments, app_name, allow_track_backs, allow_comments, lgcy_tmb_strg,
uploaded, total_size, tmb_vrsn, parent_id, ordinal, number_of_chunks, tmb_regen,
mime_type, item_default_url_, inherits_permissions, folder_id, file_path,
file_id, extension, chunk_size, can_inherit_permissions, blob_storage, author_,
approval_workflow_state_, id, voa_class, voa_version, parts_, width, height,
alternative_text_, width2, height2
FROM SitefinityOld..sf_media_content

INSERT INTO SitefinityNew..sf_approval_tracking_record_map (id, voa_version)
SELECT id, voa_version
FROM SitefinityOld..sf_approval_tracking_record_map

INSERT INTO SitefinityNew..sf_media_thumbnails
(width, typ, total_size, content_id, nme, mime_type, id, height, file_id, dta,
uploaded, number_of_chunks, chunk_size, voa_version)
SELECT width, typ, total_size, content_id, nme, mime_type, id, height, file_id,
dta, uploaded, number_of_chunks, chunk_size, voa_version
FROM SitefinityOld..sf_media_thumbnails

INSERT INTO SitefinityNew..sf_url_data
(url, redirect, qery, last_modified, is_default, id, disabled, culture,
app_name, voa_version, voa_class, content_id, id2, item_type)
SELECT url, redirect, qery, last_modified, is_default, id, disabled, culture,
app_name, voa_version, voa_class, content_id, id2, item_type
FROM SitefinityOld..sf_url_data
WHERE app_name = '/Libraries'

INSERT INTO SitefinityNew..sf_libraries
(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,
approve_comments, app_name, allow_track_backs, allow_comments, running_task,
cache_profile, tmb_regen, max_size, max_item_size, item_default_url_,
inherits_permissions, security_provider, client_cache_profile,
can_inherit_permissions, blob_storage, voa_class, resize_on_upload, new_size)
SELECT 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,
approve_comments, app_name, allow_track_backs, allow_comments, running_task,
cache_profile, tmb_regen, max_size, max_item_size, item_default_url_,
inherits_permissions, security_provider, client_cache_profile,
can_inherit_permissions, blob_storage, voa_class, resize_on_upload, new_size
FROM SitefinityOld..sf_libraries
WHERE content_id NOT IN (SELECT content_id FROM SitefinityNew..sf_libraries)

INSERT INTO SitefinityNew..sf_approval_tracking_record
(workflow_item_id, user_id, status, note, last_modified, id, date_created,
culture, application_name, voa_version)
SELECT workflow_item_id, user_id, status, note, last_modified, id, date_created,
culture, application_name, voa_version
FROM SitefinityOld..sf_approval_tracking_record

INSERT INTO SitefinityNew..sf_permissions
(id, set_name, object_id, principal_id, grnt, [deny], app_name, last_modified,
voa_version)
SELECT id, set_name, object_id, principal_id, grnt, [deny], app_name,
last_modified, voa_version
FROM SitefinityOld..sf_permissions
WHERE id IN (SELECT id FROM SitefinityOld..sf_mdia_content_sf_permissions)

INSERT INTO SitefinityNew..sf_mdia_content_sf_permissions (content_id, id)
SELECT content_id, id
FROM SitefinityOld..sf_mdia_content_sf_permissions;

INSERT INTO Sitefinity..sf_permissions_inheritance_map
(sf_prmssons_inheritance_map_id, object_id, child_object_id,
child_object_type_name)
SELECT (SELECT MAX(sf_prmssons_inheritance_map_id)
	FROM Sitefinity..sf_permissions_inheritance_map WITH (HOLDLOCK, UPDLOCK)) +
	ROW_NUMBER() OVER (ORDER BY sf_prmssons_inheritance_map_id),
object_id, child_object_id, child_object_type_name
FROM SitefinityOld..sf_permissions_inheritance_map