Is the SQLite schema very different from the SQL Server one? In our project, we'd like to keep two versions of the app, a "lite" version with reduced functionality but easier deployment, and a "full" version, more powerful and with concurrent users support. Since we are going to use SQL Server in the full version and we need to provide a migration path from "lite" to "full" version, I'd like to find an embedded database with a schema similar to SQL Server.
I've worked in the past with SQLCE (mainly in WinMo devices), but all articles I've found on the net state that SQLite is the right option over SQLCE. On Mon, Jul 18, 2011 at 6:29 PM, Patrick Steele <[email protected]>wrote: > I'll give a +1 for SQLite. Had a small, single-user project for a > non-profit that we wanted to use ActiveRecord with. SQLite worked > just fine with AR and it exposed just a single file that made backups > easier for the user. I don't recall having any problems and the > project came together quickly. No install was a bonus too. > > --- > Patrick Steele > http://weblogs.asp.net/psteele > > > > On Mon, Jul 18, 2011 at 12:13 PM, Juanma <[email protected]> wrote: > > Regarding firebird... > > > > Is it really a good option for an embedded deployment? > > Is the NH support good enough? > > > > As I said in my previous mail we found a lot of issues with sql express > > installation process, and we are currently looking for an embedded > > alternative. I don't like access, and I was considering SQLite or SqlCE. > > > > > > On Mon, Jul 18, 2011 at 5:13 PM, Ken Egozi <[email protected]> wrote: > >> > >> Access also needs some form of installation on a machine. not all > windows > >> machines can run the Jet 4.0 engine (which is what access use). > >> You should be looking into SQLite in file mode. It has a good support > for > >> NHibernate. It is not however very suitable for high concurrency but I > >> suspect it is not a problem in your scenario. > >> Not that Access is wrong or anything, but it has some quirks, and its > SQL > >> implementation is not per the standard so you might hit a few > hard-to-solve > >> gotchas > >> > >> another option is Firebird which also has an embedded mode, and fairly > >> good .NET drivers. > >> > >> > >> Ken Egozi. > >> http://kenegozi.com/blog > >> http://social.sears.com > >> http://www.musicglue.com > >> http://www.castleproject.org > >> http://www.idcc.co.il - הכנס הקהילתי הראשון למפתחי דוטנט - בואו > בהמוניכם > >> > >> > >> On Mon, Jul 18, 2011 at 6:04 PM, Juanma <[email protected]> wrote: > >>> > >>> The problem with Sql Server is the installation process. We have found > a > >>> lot of issues when trying to install SQL on different environments, > with > >>> many combinations of platforms (WinXP, Vista, 7), architectures (x86, > x64), > >>> installed componentes, etc. > >>> > >>> On Mon, Jul 18, 2011 at 12:09 PM, umefarooq <[email protected]> > wrote: > >>>> > >>>> really great thanks for reply, i know that Sql server is the best > >>>> combination with .net, i will give a try > >>>> > >>>> -- > >>>> You received this message because you are subscribed to the Google > >>>> Groups "Castle Project Users" group. > >>>> To post to this group, send email to > >>>> [email protected]. > >>>> To unsubscribe from this group, send email to > >>>> [email protected]. > >>>> For more options, visit this group at > >>>> http://groups.google.com/group/castle-project-users?hl=en. > >>>> > >>> > >>> -- > >>> You received this message because you are subscribed to the Google > Groups > >>> "Castle Project Users" group. > >>> To post to this group, send email to > >>> [email protected]. > >>> To unsubscribe from this group, send email to > >>> [email protected]. > >>> For more options, visit this group at > >>> http://groups.google.com/group/castle-project-users?hl=en. > >> > >> -- > >> You received this message because you are subscribed to the Google > Groups > >> "Castle Project Users" group. > >> To post to this group, send email to > >> [email protected]. > >> To unsubscribe from this group, send email to > >> [email protected]. > >> For more options, visit this group at > >> http://groups.google.com/group/castle-project-users?hl=en. > > > > -- > > You received this message because you are subscribed to the Google Groups > > "Castle Project Users" group. > > To post to this group, send email to > [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > > http://groups.google.com/group/castle-project-users?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "Castle Project Users" group. > To post to this group, send email to [email protected] > . > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/castle-project-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
