|Subject||Re: [firebird-support] Beginer questions: Front-end, ANSI compliance, advanced features|
> I am new to FireBird and want to use it as a back-end to my .NETThis might be a good reading:
> applications. I have few queries regarding this:
> (1) Is FireBird 100% ANSI-SQL compliant?
> (2) Does it support advanced database features like replication,Yes. Via third-party tools. I would recommend IBPhoenix' IBReplicator
> multi-version concurrency control (MVCC),Yes.
Not for load-balancing. For fail-over, you might build up something with
replication and an appropriate middleware.
> (3) Which is the best GUI front-end for working with FireBird?That's a religion. I would recommend Database Workbench, but I'm biased.
;-) There is also IBExpert. Flamerobin is cross-platform and free and
"comes" from the project, but hasn't the full-fledged feature set than
> (4) Can it be easily connected to .NET (1.1/2.0) and what performanceCheck out the newsgroup Alan has mentioned.
> level is achieved with .NET applications?
> (5) Does it have an automated backup feature?Firebird 2 has two approaches for backups. gbak and new in V2, nbackup.
Both can operate on a live database, so online backups are possible.
Anything else, like time-scheduled backups and such are gimmicks and ca
be achieved via time-scheduling facilities of the OS or there are GUI
driven backup tools as well.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and