>I've been working on a Twitter account management program / feed reader. I have it to the point that I want to start offering it up for some testing. And I'm trying to work out the best strategy for deploying the database.
>
>Originally I had thought of downgrading the database to CE, but I tried that this weekend and found out that CE doesn't' seem to support Identity increment. CE also lacks some other features I wanted to be able to use latter, and since it can rapidly grow into a rather massive database, I decided to keep it as some form of SQL express database for now.
>
>The current database is in SQL Express 2005 and I'm using Entity Framework for access to it. I use 2005 instead of 2008 for my coding because I can seamlessly transfer my data between the Express version I use for development and my company server which is the Standard 2005 version.
>
>So here are my questions...
>
>Has anyone had any experience supporting both the 2005 and 2008 versions of SQL Server entity framework? (Since the database was designed for 2005 it seems like it should be do able.)
>
>I can handle the install of SQL Express with no problems (already tested) but what is the best way to install AND maintain the database? (There seems to be a number of ways to go on this.)
Check if this MSDN thread
MSDN thread can be of some help.
If it's not broken, fix it until it is.
My Blog