yes sqlite is also a good option for small and single user project, no installation and easy to deploy, anybody has proper tutorial for sqlite and castle project
On Jul 19, 11:12 am, Juanma <[email protected]> wrote: > I hadn't thought of that, and is a very good point. Currently we have a very > simple migration system that allows us to alter the schema in the most > common ways, and it would be easy to port to SQLCE (because the DDL syntax > is nearly identical to SQL). > > On Mon, Jul 18, 2011 at 10:09 PM, Alex Henderson <[email protected]>wrote: > > > > > > > > > NHibernate makes it easy to smooth out the different data type issues > > between databases. For me the only irksome thing is that once you project > > becomes brownfield the approach to database migrations for Sql Server and > > Sqlite are quite different - with sql server you can add/remove/change > > columns on tables etc. - but Sqlite has a reduced set of available DDL > > options, so generally you need to create a new table in the right shape, > > copy all the data across, delete the old table, rename the new table. > > > Most of the current migration frameworks for .Net don't handle this very > > well because they don't have the concept of a table "model" carried between > > each migration step. > > > On Tue, Jul 19, 2011 at 5:07 AM, Juanma <[email protected]> wrote: > > >> Hmmm, actually I suppose the real problem would be more different > >> datatypes than the schema itself. > > >> On Mon, Jul 18, 2011 at 7:01 PM, Patrick Steele <[email protected] > >> > wrote: > > >>> I have not done a comparison of the schema options. For the project I > >>> used, migration was not an option. > > >>> However, if you're using ActiveRecord on a new database, there's the > >>> GenerateSchema method to create your schema. You should be able to > >>> use that with both SQLite and SQL Server. > > >>> --- > >>> Patrick Steele > >>>http://weblogs.asp.net/psteele > > >>> On Mon, Jul 18, 2011 at 12:51 PM, Juanma <[email protected]> wrote: > >>> > 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. > > >>> -- > >>> 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.
