Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL Server Compact Edition
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Server Compact Edition
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Webdango View Drop Down
Newbie
Newbie


Joined: 22 September 2013
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Webdango Quote  Post ReplyReply Direct Link To This Post Topic: SQL Server Compact Edition
    Posted: 24 September 2013 at 12:19pm
Will WWF run off SQL Server CE?
 
I'm looking for a solution that offers the self-contaiment of Access for ease of deployment, yet has the robustness to support the forum in a production environment.
 
Thanks-

EDIT:

When doing a new installation, I don't see SQL Server 2012 as one of the options. I assume I should select 2008 as the db when deploying to a 2012 db server?


Edited by Webdango - 24 September 2013 at 10:26pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 25 September 2013 at 1:18pm
Web Wiz Forums has not been tested with SQL Server CE, but there is no reason why it would not.

You would select SQL Server 2005 to 2008 when using SQL Server 2012.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Webdango View Drop Down
Newbie
Newbie


Joined: 22 September 2013
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Webdango Quote  Post ReplyReply Direct Link To This Post Posted: 25 September 2013 at 1:29pm
Thanks for the reply.
 
SQL Server CE doesn't support views or stored procedures.... does that affect WWF?
 
Thanks for the clarification on SQL Server 2012.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 26 September 2013 at 9:04am
There are no views or stored procedures used in Web Wiz Forums, so should be fine running under SQL Server CE.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Webdango View Drop Down
Newbie
Newbie


Joined: 22 September 2013
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Webdango Quote  Post ReplyReply Direct Link To This Post Posted: 26 September 2013 at 11:45am
Thanks for the reply.
 
On a new WebWezForum install, there are the selections for Access, MySQL, SQL Server 2000, and SQL Server 2005/2008.
 
SQL Server CE is file based and is not a server, so there doesn't seem to be an automated way to do a new install, since both the SQL options require server info. The connection string would also have to be manually modified.
 
Just not something I'm ready to put the time into figuring out.
 
Thanks again
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.