816277 - Create database migration of SuMoMo (Thunderbird) KB articles

Status: RESOLVED FIXED

(support.mozilla.org :: Knowledge Base Software, task, P2)

Description

[Roland Tanglao needinfo please :rolandtanglao, :mohnkuchen, :adobo, :sinigang, :roland]

For the sprint currently schedulded for the week of December 10, 2012, dump the SuMoMo articles and migrate to SUMO staging on allizom.org

Comment 1

[David Weir (satdav)]

Don't think this happened yet

Comment 2

[Ricky Rosario [:rrosario, :r1cky]]

We'll have to figure out how we want to migrate this data (a sql script? a south data migration?) first.

Making this 5pts for now. It's probably a shitton of work.

Comment 3

[Will Kahn-Greene [:willkg] ET needinfo? me]

We shouldn't do this with a south migration.

We'd need to do a migration script. The ids for everything and the table structures are all going to be different, so we'll need to write a script to go through all the data from a SuMoMo data dump (in some format), rearrange it into the right form for SUMO and then insert it into the db and connect all the pk and fk correctly.

The db folks might have good ideas on what tools to use to do this.

I concur this is a large project.

Comment 4

[Ricky Rosario [:rrosario, :r1cky]]

Also, I am guessing there is media (gallery images) that go along with the articles. We need to migrate that too along with the files somehow. wheeeeee

Comment 5

[Kadir Topal [:atopal]]

Here's what we had talked about migrating back when: https://wiki.mozilla.org/Support/Kitsune/Thunderbird-integration#SuMoMo_Migration

Probably makes sense to go over it again and break that down into several bugs if necessary.

Comment 6

[Roland Tanglao needinfo please :rolandtanglao, :mohnkuchen, :adobo, :sinigang, :roland]

more details on the design are here:
https://etherpad.mozilla.org/sumomo-to-sumo-migration

Comment 7

[Ricky Rosario [:rrosario, :r1cky]]

assigning to mike!

Comment 8

[Michael Cooper [:mythmon]]

I think we're done here. \o/