| Author |
 Topic Search  Topic Options
|
highinfidelity 
Newbie
Joined: 22 April 2005
Location: Italy
Status: Offline
Points: 20
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 06 March 2007 at 10:50am |
Hello and thanks to all for the interesting posts.
I already had in mind to try the conversion process on a "duplicate" board and check it with help of moderators, than only AFTER having worked it out, to lock the board, convert it and upload it to the new forum.
Back to general question, the main problem lately with Access was compacting and optimizing the database. As the provider offered no active service to perform this task, we had to download the DB, run the Microsoft utility and then upload the DB back. As the DB increases, this is lately getting extremely hard to do in an undeveloped country like Italy, where major areas of the country are still served only with 56K dial up connections. I would like then to understand if this operation can be skipped (being unnecessary) with SQL databases, or if there is some active utility to perform the task in remote mode here. Thank you.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 March 2007 at 11:08am |
|
The Access version of Web Wiz Forums has an Compact and Repair Database tool which you can use from the online admin control panel.
mySQL and SQL Server don't need to be compact and repaired so you don't have this function available.
mySQL and SQL Server are database servers and are real databases, Access on the other hand isn't a real database and is simply a flat desktop file, which is why it needs to be compact and repaired.
As a flat file Access isn't really up to the task of handling all the reads and writes required by a forum, so unless you only have a handful of users you should always avoid using Access as the backend for any forum system.
With mySQL and SQL Server you don't have a single physical flat file like with Access, instead you connect to the database server, which is often remotely hosted, and manage your database using client tools, such as Microsofts SQL Server Management Studio.
|
|
|
|
MortiOli
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 March 2007 at 12:25pm |
If I remember rightly, as part of the conversion the database needs to be compacted / repaired to 'reload' the autonumber sequence.
Now I'm sure Snitz is able to compact / repair through the Admin panel, and as Borg said, so can WWF. However, I'm not sure if you'd be able to access the DB by either forum midway through the conversion.
It might be worthwhile finding a script on the net to compact / repair the DB whilst it's on your hosts server, to save you downloading it.
Sorry if I misread your post, and the above doesn't apply.
|
|
highinfidelity
Newbie
Joined: 22 April 2005
Location: Italy
Status: Offline
Points: 20
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 March 2007 at 1:27pm |
Hello again MortiOli. These kind of active operations are locked by my current host, as well as many others. Keep in mind that the company even keeps a list of "forbidden" .asp applications, granting to theirselves the right to shut down your webspace if you upload one of those. The reason is that these applications are supposed to cause server's failures and reboot for all hosted accounts in sharing. Not even to mention, WebWiz Forum is in this "black list" of forbidden applications.
As this situation is getting more and more intolerable, I'm looking around to find a new host at decent prices, and this host - which supports a dedicated Forum software - seems quite ideal.
@ Borg: fellow dj air wrote back saying that he would eventually perform the conversion at an uffordable price in case I fail, but that he usually suggest converting to MSSQL instead of mySQL, expecially if the board is going to get busy. As I don't know the difference, is MSSQL supported as well? Which of the two would you suggest?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 March 2007 at 2:56pm |
|
Our hosting service offers the mySQL server version of Web Wiz Forums which works fine. The differences between mySQL and SQL Server wouldn't make much difference when using a forum application.
|
|
|
|
User123
Newbie
Joined: 11 March 2007
Status: Offline
Points: 38
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 March 2007 at 5:19am |
I migrated our Snitz 3.x forum (installed in 2002) to Web Wiz 8.05 this last Friday night. We have over 63,000 posts in 5,000+ topics. Total conversion time, start to finish, was about 16 hours: 15 hours of developing the conversion script and about an hour for the final complete conversion to take place. There have been
several hours of minor adjustments afterwards and I'm slowly modifying
the new forums to match some of the previous features we had. You can see the finished product at http://www.qoda.net/forum. As a token of my appreciation for Web Wiz having a no cost option for a very nice piece of software I wanted to give back to the community (and no sense in this hard work being wasted). Here is my script which anyone migrating from Snitz to Web Wiz is free to use: http://www.qoda.net/forum/database/snitz_convert.txtI think you'll find it quite comprehensive as it migrates user accounts, forums, topics, threads, polls, and even converts most Snitz message formatting to raw HTML required by Web Wiz. There are still a few items I wasn't able to account for (the most notable was inline URLs which did not have the tags around them). Hope it help. As stated in the script header this is provided "as-is" - no warranties or guarantees. You may have mods, different versions, or other factors which cause the script to fail. Good luck! ----------------------------------------- EZ-Frag[QODA] http://www.qoda.net
|
|
MortiOli
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 March 2007 at 12:46pm |
Thanks for sharing your script with us! I have an old Snitz forum that I keep meaning to convert, so will give it a go at the weekend.
Thanks again!
|
|
MrMellie
Senior Member
Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 March 2007 at 7:00pm |
Nice bit of T-SQL there. 
|
|
