最近要做个桌面程序,部署到客户端那里,而客户离我又比较远.并且对电脑毫无概念.所以得才有客户端桌面数据库的问题.其实这个问题,大家也讨论了很多.大体有这么几种方案.
ACCESS:微软的方便,但是安全性不高
SQLITE: 不错的方案,可惜不支持存储过程,我原来在SQL SERVER 2K已经做的差不多,如果没有存储过程,我的改动太大了.
MSDE:不错,但也要安装
MYSQL: 相对麻烦
所以还是考虑了firebird,各种条件都比较符合,现在有了.net 2.0了.而且与vs2005集成了.
http://www.firebirdtutorial.net/fbconnection-component.html
另外找到了,一些关于firebird的工具.
1) IB Expert
IBExpert enables yout to work in different databases at the same time. Some features are: Editor with Hyperlinks for all Databaseobjects: Domains, Tables, Views, Stored Procedures, Triggers, Generators, Exceptions and UDFs; Export to Excel, RTF (Word), HTML, CSV, SYLK, DIF, TXT, LaTeX, XML; Stored Procedure and Trigger Debugger; Visual Query Builder, Testdatagenerator; and much more!
2) Database Workbench
Database Workbench is a developer tool that supports the InterBase and Firebird database engines. It provides you with powerful visual object editors, syntax highlighting, test data generator, stored procedure debugger, datapump utility, a powerful schema explorer and dependencies viewer, object and naming templates and much more! Everything you will need as a professional database developer.
3) IBDataWorks
IBDataWorks provides a powerful development environment allowing DBA and developers to fully define every aspect of their InterBase database including the following features: reverse engineer from SQL scripts or a live database, visually model and layout fully-attributed diagrams, ...
4) IBOAdmin
Delphi package with Components to perform administration tasks on sql server InterBase or Firebird. Comes will full source.
5) Marathon
GUI for InterBase databases. Marathon is now Open Source, the project is always in search of new supporters and helpers in different positions. So if you want to help you can look through our task, bug and feature tracker to get an idea what needs to be done.
6) SQLHammer
SQLHammer is a FREE high-performance tool for rapid database development and administration (RDDA) which includes common integrated development environment (IDE), registered custom components based on Borland Package Library (BPL) mechanism and Open Tools API (OTA) written on Delphi language.