Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a requirement that a database must support sequences. I know oracle and PostgreSQL support it. Are there any other free database software that support database sequences? it would be great if it had a .NET driver too

share|improve this question

closed as off-topic by Phil, bluefeet, Aaron Bertrand Jan 26 at 14:48

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Phil, bluefeet, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

Why specifically sequences, what are you to use the for? Are you looking for a single integer column which auto-increments? Every database then supports that feature – ssmusoke Jul 16 '12 at 6:12
@ssmusoke: An auto_increment is something different than a sequence – a_horse_with_no_name Jul 16 '12 at 16:18

4 Answers 4

up vote 4 down vote accepted

If with "free" you mean "open source", then Firebird comes to mind (but I personally would prefer PostgreSQL over it - the much better documentation alone is a reason).

Ingres also supports sequences, but I don't know if there is a .Net driver for it.

There are other open source ones like Apache Derby, HSQLDB and H2 Database but as they are Java only, I'm pretty sure they do not have a .Net driver

If with "free" you mean "free of charge", then Oracle Express, DB2 Express-C and SQL Server 2012 Express are an option as well (as all three of them support sequences)

share|improve this answer
Actually it would be DB2 Express-C (Express actually has a license cost). But DB2 does support sequences. We use sequences with DB2 Express-C where I work. – Chris Aldrich Jul 17 '12 at 12:40
@ChrisAldrich: thanks. I didn't know that there was a difference between Express and Express-C. – a_horse_with_no_name Jul 17 '12 at 12:54
This compares Express vs Express-C as an fyi. – Chris Aldrich Jul 18 '12 at 12:52
@ChrisAldrich: thanks, very helpful. – a_horse_with_no_name Jul 18 '12 at 13:06

Why don't you just use PostgreSQL then? It's great.

share|improve this answer

Oracle Express Edition is free, supports sequences, and can integrate with .NET. See the question What features of Oracle make it an attractive choice for small projects?

share|improve this answer

SQL Server 2012 introduces sequences. You can download SQL Server 2012 Express for free, and the .NET integration should go without saying.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.