Planning migration from Snitz Forums

Thanks MrMellie, it was quite..uh...fun to write 

WARNING: I was just reviewing the file and noticed that in my post-conversion semi-catatonic state I reverse my search and replaces.  Basically I switched the names of the Snitz and WebWiz database   Anyway I've fixed it so all but the "USE" statement now reference "SNITZ_DB".  I also found and cleaned out a few lingering test statements and uncommented the "set nocount on".

Be sure to click the link above and get the latest version.  If you find any other issues just post and I'll try to help - time permitting.


Edited by User123 - 14 March 2007 at 8:20am

I'd be tempted to say, convert the Snitz table to SQL and then use User123's T-SQL script above to convert into WWF SQL. There were a couple of hiccups I came across but it was much easier than the painful route of going via WWF v7 Access.

Hi measlick,

The script would take a fair amount of modification to work with Access databases.  I've never used the Access version of either forum so it's possible there are other issues due to minor variations in the database structure itself.  Sorry I can't be of more help.

I think I will just switch hosts and update to SQL first, then use the most current script. To bad too, GoDaddy was cheap :)