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.
