>>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.
Hi Naomi,
Thanks for the reply.
I was reading that thread a few hours ago. It seems to have more to do with installing SQL server than installing the database. Install is easy for an MSI project, you just set it as a prerequisite for the project. Already tested that, it installs it just fine.
I'm more concerned with installing the database. I know there are a number of ways to go about it, I'm thinking a user instance might be best for this application. But I also need to make sure that the database doesn't get overwritten when I upgrade the software and that I can run any needed upgrade scripts.
The 2008 version looks like it might have a smaller install to it, which would be nice. Also, if I'm going to install something, newer software generally makes more sense for me to install than older. But for my purposes I still want to maintain compatibility with 2005.
