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.
