Web Wiz Support and Community Forums : Planning migration from Snitz Forums https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 21:58:48 +0000 Fri, 09 Nov 2007 13:18:42 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22813 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Planning migration from Snitz Forums : If I sing up for hosting through...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post129172.html#129172 Author: measlick
Subject: 22813
Posted: 09 November 2007 at 1:18pm

If I sing up for hosting through this site, it says they will install WWF for me, but what if I need to still convert from Snitz. Has anything gotten easier or harder?]]> Fri, 09 Nov 2007 13:18:42 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post129172.html#129172 <![CDATA[Planning migration from Snitz Forums : I am looking for someone to convert...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post125097.html#125097 Author: alltp
Subject: 22813
Posted: 20 July 2007 at 5:34pm

I am looking for someone to convert my Snitz database (www.tabletpcbuzz.com) to WWF Ver. 8 or 9 as soon as possible.  I have everything setup on a test server and am using SQL and Snitz Ver. 3.4.03.
 
This is not something I could do and am happy to compensate the right person for their time, especially if this can occur in a timely manner.
 
Please feel free to contact me.
 
John Hill
john at alltp dot com
]]> Fri, 20 Jul 2007 17:34:48 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post125097.html#125097 <![CDATA[Planning migration from Snitz Forums : I think I will just switch hosts...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123189.html#123189 Author: measlick
Subject: 22813
Posted: 30 May 2007 at 3:54am

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

]]> Wed, 30 May 2007 03:54:17 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123189.html#123189 <![CDATA[Planning migration from Snitz Forums : If you want to do it Access to...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123184.html#123184 Author: MrMellie
Subject: 22813
Posted: 29 May 2007 at 7:56pm

If you want to do it Access to Access, then Mortoli's script would be the best option, then migrate from v7 to v8 and upsize to SQL.]]> Tue, 29 May 2007 19:56:22 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123184.html#123184 <![CDATA[Planning migration from Snitz Forums : Hi measlick,The script would take...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123166.html#123166 Author: User123
Subject: 22813
Posted: 29 May 2007 at 4:07pm

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.
]]> Tue, 29 May 2007 16:07:58 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123166.html#123166 <![CDATA[Planning migration from Snitz Forums : I don&#039;t think I have access...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123164.html#123164 Author: measlick
Subject: 22813
Posted: 29 May 2007 at 2:48pm

I don't think I have access to the SQL server from home. Maybe I was hoping his script could be used for Snitz (access) to WWF (access) :(

]]> Tue, 29 May 2007 14:48:52 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123164.html#123164 <![CDATA[Planning migration from Snitz Forums : I&#039;d be tempted to say, convert...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123157.html#123157 Author: MrMellie
Subject: 22813
Posted: 29 May 2007 at 9:49am

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.]]> Tue, 29 May 2007 09:49:17 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123157.html#123157 <![CDATA[Planning migration from Snitz Forums : I would like to migrate but I...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123156.html#123156 Author: measlick
Subject: 22813
Posted: 29 May 2007 at 4:54am

I would like to migrate but I am having trouble doing so.
 
First I am running Snitz with Access
Second I am running this on GoDaddy and can't figure out how to migrate the access DB to my 1 MySQL DB available.
 
Is there an easy way to do this Snitz (Access) -> WWF (Access) -> WWF (SQL) ??
 
I have done a migration in the past with 7 but that was a looonnggg time ago with a host that allowed me to actually connect to my SQL server. (I used up sizing in Access)...
 
Any suggestions are greatly appreciated!
]]> Tue, 29 May 2007 04:54:34 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post123156.html#123156 <![CDATA[Planning migration from Snitz Forums : Thanks MrMellie, it was quite..uh...fun...]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post121244.html#121244 Author: User123
Subject: 22813
Posted: 14 March 2007 at 8:19am

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

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 Shocked  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]]> Wed, 14 Mar 2007 08:19:38 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post121244.html#121244 <![CDATA[Planning migration from Snitz Forums : Nice bit of T-SQL there. ]]> https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post121234.html#121234 Author: MrMellie
Subject: 22813
Posted: 13 March 2007 at 7:00pm

Nice bit of T-SQL there. Smile]]> Tue, 13 Mar 2007 19:00:31 +0000 https://forums.webwiz.net/planning-migration-from-snitz-forums_topic22813_post121234.html#121234