Web Wiz Forums - Migrating Snitz to Web Wiz using MSSQL

Print Page | Close Window

Migrating Snitz to Web Wiz using MSSQL

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16897
Printed Date: 15 April 2026 at 7:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Migrating Snitz to Web Wiz using MSSQL

Posted By: dooza
Subject: Migrating Snitz to Web Wiz using MSSQL
Date Posted: 13 October 2005 at 6:32am

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

Should I just follow the Access instructions?

Steve

Replies:

Posted By: dj air
Date 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, i and him released a MOD /.script in this forum that will move all them over alnd still allow the passwords to work encrypted.

Posted By: dooza
Date Posted: 13 October 2005 at 8:10am

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

Cheers for looking.

Steve

Posted By: dj air
Date 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.

Posted By: dooza
Date Posted: 13 October 2005 at 9:05am

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

I will let you know how I get on.

Steve