Snitz forum database access to vbulletin

[Snakefrancesco]

Hello I would like to know how to import a Snitz Forum (Access database) in vbulletin. Thanks

[borbole]

Originally Posted by Snakefrancesco

Hello I would like to know how to import a Snitz Forum (Access database) in vbulletin. Thanks

You should use Impex to import to vbulletin. You can download it at your member''s area. Make sure to read the read me file inside the impex package before starting with the import.

[Videx]

It wasn't easy but a lot of us figured it out eventually. I believe borbole is incorrect that Impex will import an Access db. At least when I did mine a couple years back it wouldn't, and thus the hardest part of the whole mess was converting the Access db to MySQL (or something else Impex would take).

[borbole]

Originally Posted by Videx

It wasn't easy but a lot of us figured it out eventually. I believe borbole is incorrect that Impex will import an Access db. At least when I did mine a couple years back it wouldn't, and thus the hardest part of the whole mess was converting the Access db to MySQL (or something else Impex would take).

I thought that he meant he Access db as in if the source forum could have access to the db of vb and not as in Access db. Sorry for my bad and thank you for the correction

[janaf]

I converted my Snitz about half a year ago.

Importing the Access file to mySQL was a breze with the mySQL import application.

Then the actual conversion worked well. There where a few issues; Internal links made in postings where broken. I did not find anything in Impex to fix this. My board did not import in a way where post IDs retained the same ID number so it was not so trivial to do a search / replace operation on the links. Maybe it would work if the source dB was sorted in numerical order before the import and also I guess the source needs to be totally free from deleted posts.

Impex did not import the image gallery add-on.

I had to import to dB 3.X and then update to 4.0 There was no direct Snitz-vB4 at that time.

Apart from this the import worked well and Impex may have developed since then.

[Videx]

There's an Access-mysql import application now? That would have saved me a ton of work. Where is that - in the Impex package I guess?

[janaf]

Originally Posted by Videx

There's an Access-mysql import application now? That would have saved me a ton of work. Where is that - in the Impex package I guess?

It's called Migration Toolkit and available from the mySQL site. Very simple to use and worked very well for me.

1. Import dB from Access or other dB to mySQL with Migration Toolkit
2. Convert with Impex to vB

If you are on a Win machine, MS also has a (free) import / convert tool that is good. It's somewhere among the SQL server tools. It imports and exports between lots of dBs. You can actually import from Access and export to mySQL in one step. Can't remember the name right now.

[Videx]

Oh. Yes, I used some third party conversion tool but I don't remember now which one it was. I never did get it to preserve passwords, but other than that it was mostly my total ignorance of mysql that took me so long - I had to learn what the heck a db was and how to care for it. While simultaneously learning Impex and vb3, with a live switchover all in a single morning.