Persistent sync - vBulletin 4 to Discourse

AI-generated summary

In a Support topic titled “Persistent sync - vBulletin 4 to Discourse,” spellbee2 seeks advice on whether it’s feasible — or advisable — to run vBulletin 4 and Discourse in parallel during migration, with real-time sync between their databases (MySQL and PostgreSQL). The goal is to ease the transition for users, especially older or resistant members, by allowing them to switch between platforms until fully comfortable. Falco advises against this, recommending a direct switch instead, and links to a meta discussion supporting this view. spellbee2 acknowledges the advice and considers using a small group of beta testers, including some resistant users, to trial the new platform. pfaffman shares experience with both approaches: running parallel systems (with caveats — sync is one-way and can cause confusion) and using a temporary beta site for testing before full migration. He also offers professional migration assistance. HAWK invites spellbee2 to start a discussion in #community for personalized migration strategy help and mentions plans to publish a howto guide soon. The consensus leans toward a phased, controlled migration with testing rather than live dual-platform sync, which is technically complex and potentially confusing for users.

Greetings all!

I recently purchased an already-established vBulletin 4 forum after being part of the forum staff for a few years. But after reading up on some horror stories of vB security vulnerabilities, dealing with the horrible mobile UI, and having an absolute nightmare fixing out-dated plugins that were broken with the previous owners, we (the staff) decided to investigate migrating to other forum software.

I’ve looked at the vB4-to-Discourse import script, and though I haven’t tried it yet, it seems pretty straightforward, and I hope to modify it a bit for my own needs to import some data from our existing vB plugins and remake them in Discourse (although my knowledge in Ruby is admittedly sparse at the moment, though I plan on changing that soon).

Here’s my question though: I was hoping that during the transition, we could have an instance of vB and an instance of Discourse running at the same time, with their databases somehow in sync. That way, users can take some time to adjust to the new UI and controls, but can still feel comfortable going back to the old site if there’s features they haven’t figured out yet (primarily since some of our members are, in their own words, “curmudgeony”, and may not appreciate the change at first). Any changes (posts, likes, profile updates) on one site would be reflected on the other. Then, after some set amount of time, we switch solely to Discourse.

Is something like this theoretically feasible? I know vB runs on MySQL and Discourse on PostgreSQL, but I found a few programs that should allow periodic syncing between the two, provided I know which fields and tables map to each other. Or (and I suppose this is an opinion-based question) is it even worth it - should I just rip the band-aid off instead of hassling with the transition period?

Thanks in advance!

You should.

Ah, sorry I missed that thread in my search. I do like the idea of having just a few “beta-tester” members to run it through it’s paces - that should be enough to hash out any problems, especially if I can include a couple of the “curmudgeons” in that group as well.

Thanks for the help!

What I’ve done is to do an import, invite some folks to check it out, and warn them that the beta site is temporary. They can then make posts as test to see how things work, rather than worry that they’ll be recorded forever.

I’ve also done the two-in-parallel thing. You can re-run the importer and suck in data from the legacy forum to the Discourse forum. It’s a one-way thing, though, and as everyone says, it’s not recommended. Stuff that happens in Discourse stays in Discourse, and things will be confusing when new data gets sucked in from the old forum and responses are from those who didn’t see stuff that happened on the Discourse side.

For this client, it was important to do lots of configuration on the Discourse side before pulling the trigger on the move. Though he’s done some work and a few users have logged in to have a look around, it’s not an active forum.

If you run into trouble with the import or find that it’s more work than you’d anticipated, my services are available. My contact info is on my profile page.

If you want to talk through migration strategy, start a post in Community Building and I can help you out. I’ve been part of many migrations.

I’m planning on writing up a howto post in the coming weeks which might be helpful also. I’ll prioritise that.