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.
