Sitecore Data Migration (ETL) -


we process of replacing sitecore 6.6 sitecore 7.2. there thousands of news articles needs migrated new platform.

the problem here have updated data templates news removing lots of fields , introducing few more. re-organized data source that's being used news item e.g. location categories, author drop down list etc.

therefore, need not migrate transform removing unnecessary fields , re-mapping old new fields etc.

could please advise experience on recommending best tool e.g. custom tool, third party tool etc.

would need know more specifics, give complete answer. can give pointers.

for of mention, not needing tool. in bullet form:

  • reorganising data, authors sit etc. assuming you've been using "link" type fields in sitecore, reorganizing data not require act. sitecore have stored references ids, , these presumably not have changed.
  • as field data sources, these need updated manually. have less dozen or (i assume) templates, shouldn't monumental task.
  • removing existing fields. fine, can remove them before or after move - again no tool required. code might need updating though.
  • adding new fields, no action required.

so guess devil lies in details here; nature of migration. if need sort of "re-fielding" of content; i.e. "combine values of fielda , fieldb , store them in new fieldc" - if case, right in asking tool.

the bad news is, know of no such tool. approach this, writing migration script , move data across. 1 easy way achieve this, take (roughly) these steps:

  • set new information architecture in sitecore 7, way want be
  • attach sitecore 6 database database "legacy". we're in grey area here, i'm sure attaching 6x database 7x instance unsupported. being said, not surprised if worked.
  • run migration code, reads "legacy" , stores in new home in "master".

lots of details cannot include in above, because know little implementation. expect write code however.


Comments

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

javascript - Highcharts multi-color line -

javascript - Enter key does not work in search box -