There are some limitations to SQL Server Express: http://www.microsoft.com/sql/downloads/trial-software.mspx Download SQL Server 2005 Express Edition Complete a SQL Server Express download, free. There are no time limits and the software is freely redistributable (with registration). With a database size limit of 4 gigabytes (GB) and support for 1 CPU and up to 1 GB of RAM, the SQL Server 2005 Express download provides software that is suitable for application embedding or lightweight application development. I have never used the CE version and I do not know what the limitations are. They are not made clear from the download page: http://www.microsoft.com/downloads/details.aspx?familyid=B9B12312-FE57-4 817-A4BC-69992802732D&displaylang=en This document: http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed7 4b404e542/sqlservercompactdatasheet_final.doc mentions a maximum database size of 4 GB (like the Express version), but the other limits are not clear. > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Stephen Ince > Sent: Monday, August 27, 2007 1:30 PM > To: Dave Page > Cc: Tony Caduto; Greg Smith; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: PostgreSQL vs Firebird feature comparison finished > > Dave, > Thx I will take a look. I was trying to port a postgres schema to a > database that had embedded capability. I could not find any non-commerical > databases that supported triggers, sequences, udf function, and stored > procedure. I as I remembered firebird has pretty weak UDF function > capability(only C/C++) and the name size limitation was a killer. > > Steve > > > > > > >> ------- Original Message ------- > >> From: "Stephen Ince" <since@xxxxxxxxxxxxxx> > >> To: "Tony Caduto" <tony_caduto@xxxxxxxxxxxxxxxxxxxx>, "Greg Smith" > >> <gsmith@xxxxxxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx > >> Sent: 27/08/07, 17:02:21 > >> Subject: Re: PostgreSQL vs Firebird feature comparison > finished > >> > >> Postgres can't be embedded or serverless. Firebird has the embedded > >> feature. > >> Most of the databases have this capability (hsqldb, derby,oracle,mysql, > >> firebird, and db2). Derby and hsqldb are the only free embedded > databases > >> for commercial use. > >> > > > > SQL Server CE is also free for commercial use iirc. > > > > Regards, Dave > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: Don't 'kill -9' the postmaster > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
