https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 15 Apr 2026 22:52:51 +0000 Thu, 13 Oct 2005 09:05:18 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=16897 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92129.html#92129 Author: dooza
Subject: 16897
Posted: 13 October 2005 at 9:05am

Excellent, sounds like it will do the job nicely. I was worried aboutthe Access conversion when it said to do a repair to reset the ids, asyou cant do this to SQL.

I will let you know how I get on.

Steve
]]> Thu, 13 Oct 2005 09:05:18 +0000 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92129.html#92129 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92128.html#92128 Author: dj air
Subject: 16897
Posted: 13 October 2005 at 8:59am

ok all you need to do with that script is

• change the connection string to your existing MS SQL database for snitz
• change any true's/false to 1/0

and run the script, it will/should then be ok.
]]> Thu, 13 Oct 2005 08:59:46 +0000 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92128.html#92128 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92122.html#92122 Author: dooza
Subject: 16897
Posted: 13 October 2005 at 8:10am

Hi DJ Air,
I dont have an Access database, I have a MSSQL database. It currentlyhas my Snitz forum tables in it. Its this MSSQL database that I want tomigrate to Web Wiz Forum again using MSSQL, not Access.

Cheers for looking.

Steve
]]> Thu, 13 Oct 2005 08:10:19 +0000 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92122.html#92122 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92120.html#92120 Author: dj air
Subject: 16897
Posted: 13 October 2005 at 8:05am

i had created a MS SQL migratiuon script from Access to SQL i believe it was

search for motoli and the Migration thread saying lets get it done, iand him released a MOD /.script in this forum that will move all themover alnd still allow the passwords to work encrypted.


]]> Thu, 13 Oct 2005 08:05:25 +0000 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92120.html#92120 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92110.html#92110 Author: dooza
Subject: 16897
Posted: 13 October 2005 at 6:32am

Hi there,
I have seen the posts about how to migrate from Snitz if you are usingan Access database, but I cant find any information about using anMSSQL database.

Should I just follow the Access instructions?

Steve
]]> Thu, 13 Oct 2005 06:32:56 +0000 https://forums.webwiz.net/migrating-snitz-to-web-wiz-using-mssql_topic16897_post92110.html#92110