Web Wiz Support and Community Forums : SQL Server migration of WebWiz forums https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 23:14:40 +0000 Tue, 03 Aug 2004 03:54:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11390 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server migration of WebWiz forums : That all depends on how much spae...]]> https://forums.webwiz.net/sql-server-migration-of-webwiz-forums_topic11390_post63001.html#63001 Author: WebWiz-Bruce
Subject: 11390
Posted: 03 August 2004 at 3:54am

That all depends on how much spae time I get to work on the forum.There certainly won't be any for beta versions which will be releasedfor testing purposes ONLY.]]> Tue, 03 Aug 2004 03:54:49 +0000 https://forums.webwiz.net/sql-server-migration-of-webwiz-forums_topic11390_post63001.html#63001 <![CDATA[SQL Server migration of WebWiz forums : Cool, you set my mind at ease...]]> https://forums.webwiz.net/sql-server-migration-of-webwiz-forums_topic11390_post62985.html#62985 Author: voip-dude
Subject: 11390
Posted: 02 August 2004 at 5:08pm

Cool, you set my mind at ease then that the forums database has full integrity.
 
So when 8.0 comes out are you going to provide an upgrade wizard for existing 7.x installations to create appropriate database changes?
]]> Mon, 02 Aug 2004 17:08:40 +0000 https://forums.webwiz.net/sql-server-migration-of-webwiz-forums_topic11390_post62985.html#62985 <![CDATA[SQL Server migration of WebWiz forums : There are no database changes...]]> https://forums.webwiz.net/sql-server-migration-of-webwiz-forums_topic11390_post62953.html#62953 Author: WebWiz-Bruce
Subject: 11390
Posted: 02 August 2004 at 2:05pm

There are no database changes between the versions you are using.

Database changes (apart from stored procedures, sometimes) do nothappen between minor versions. The next change to the database will bewith version 8.0
]]> Mon, 02 Aug 2004 14:05:34 +0000 https://forums.webwiz.net/sql-server-migration-of-webwiz-forums_topic11390_post62953.html#62953 <![CDATA[SQL Server migration of WebWiz forums : I did a double-upgrade by moving...]]> https://forums.webwiz.net/sql-server-migration-of-webwiz-forums_topic11390_post62926.html#62926 Author: voip-dude
Subject: 11390
Posted: 02 August 2004 at 10:14am

I did a double-upgrade by moving from 7.7 to 7.9 and moved from Win2K to Win2k3. 
 
Also, because I couldn't figure out how to easily import the SQL 2000 tables and stored procedures from 7.7 to 7.9 I just stopped the SQL service on both machines, then copied Forums_Data.MDF and Forums_Data.LDF from the c:\Program Files\Microsoft SQL Server\MSSQL\Data folder and restarted the service.
 
Now I am hoping that the database structure hasn't changed from 7.7 to 7.9.  The forums appear to be working OK, but I know there must be a better way of migrating. 
 
Also, for all I know, I'm missing a new field in 7.9 since I didn't use the msSQL_server_setup.asp file to create/setup the 7.9 database.
 
Let me know if
a) I need to recreate my database to support new 7.9 fields
b) How I should migrate from one SQL Server to another in the future.
 
Thanks!
]]> Mon, 02 Aug 2004 10:14:13 +0000 https://forums.webwiz.net/sql-server-migration-of-webwiz-forums_topic11390_post62926.html#62926