Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Migrating Snitz to Web Wiz using MSSQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Migrating Snitz to Web Wiz using MSSQL
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
dooza View Drop Down
Newbie
Newbie


Joined: 09 October 2005
Location: United Kingdom
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dooza Quote  Post ReplyReply Direct Link To This Post Topic: Migrating Snitz to Web Wiz using MSSQL
    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
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
dooza View Drop Down
Newbie
Newbie


Joined: 09 October 2005
Location: United Kingdom
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dooza Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
dooza View Drop Down
Newbie
Newbie


Joined: 09 October 2005
Location: United Kingdom
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dooza Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.