Web Wiz Forums - SQL Server Compact Edition

Print Page | Close Window

SQL Server Compact Edition

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=30844
Printed Date: 30 March 2026 at 1:50pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server Compact Edition

Posted By: Webdango
Subject: SQL Server Compact Edition
Date 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?

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

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

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Webdango
Date 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