Skip to content
Sitecore Data Transfer tool helps quickly migrate dozens of Sitecore content items. This tool uses SQL BULK INSERT.
C# TSQL
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Doc/Assets
ScDataTransfer
Sources
.gitignore
LICENSE
README.md

README.md

Sitecore.Data.Transfer

Sitecore Data Transfer tool helps quickly migrate dozens of Sitecore content items. This tool uses SQL BULK INSERT.

Full Description you can find here

Configuration

In the SerializingOptions.json file:

alt text

  • Specify the ConnectionString for the Master database of your Sitecore instance from which you would like to make content export
  • Specify Sitecore content RootItemId under which your target content lives

Others parameters main remain as is

How To Run

  • Download or clone this repository
  • Configure SerializingOptions.json
  • Open the solution, make a build and run ScDataTransfer.UI project (this is a console application). You will see a simple screen:

alt text

  • Press 2 for running
  • After, you will see quite the same picture:

alt text

  • When is completed, navigate to App_data folder and observe that the following files (the names of these go from the SerializingOptions.json):

alt text

To complete the whole content data transferring, we need to perform some more steps:

  • Make sure to export the Root Sitecore Item (configured in the SerializingOptions.json) from the old Sitecore instance to a new one

  • Use SQL Management Studio to execute BULK INSERT SCRIPT located here

  • Log into your target Sitecore Admin Panel — Control Panel — Rebuild link databases:

alt text

  • Certainly, you can publish migrated content if needed

How Much Time It Takes

In my case 43 000 items - two minutes for both Serialization and BULK INSERT processes.

You can’t perform that action at this time.