Isto é uma comparação básica e interessante da versão Firebird Embedded 1.5 e Microsoft SQl Server 2005 Express. De notar que se está a comparar a versão embedded do Firebird que não corre como um serviço, mas é completamente embedded na aplicação
embedded-firebird-and-microsoft-sql.html
To summarize: Embedded Firebird is a clear win when you need a fully embedded database that users are not aware of. The clear advantages of Embedded Firebird are:
- Licensing. You can’t beat Firebird’s open-source license that allows use in commercial applications without any viral effect (i.e. no need to open your proprietary code). Any kind of a “free redistribution” license is just too far from that.
- XCOPY Data Deployment. A Firebird database is a single file. Just copy it somewhere on disk and open it. Compress it and send it by e-mail. Use your own file extension and associate it with your application.
- XCOPY Runtime Deployment. Not only the data but the runtime (which is a single DLL and optional supporting files) can be just copied to your application’s directory.
- Runtime size. Compare the SQL Express 36 MB download with the 2 MB Firebird runtime.
- No performance limitations. With Firebird you can have a database of any size and open multiple connections without any penalty.
- Real embedding. Users and administrators don’t need to be aware that your application is using Embedded Firebird because it is only accessible from your application.
The Advanced Data Generator is a powerful tool that cannot be missed in any database developers toolbox, the Advanced Data Generator allows you to easily generate real-life like data into your database or SQL scripts for testing purposes. With user-defined presets, complex value support and the included data-libraries, you will have a huge database up and ready for testing in no-time.
