Database .NET - A Multiple Database Manager多重資料庫系統管理

簡易問答集Frequently Asked Questions(FAQ) Q: What is Database .NET 作用為何? A: Database .NET is a simple and intuitive database management tool for multi-database. Making Local and Remote Database Administration Easier. 是一個直覺式多重資料庫管理工具, 能讓您以更簡單的方式同時管理不同的資料庫系統, 無須另外安裝 整個資料庫系統, 即可直接本地或遠端進行資料庫的連線存取, 方便資料庫調試, 修改, 查詢, 列印, 輸出, 備份...等多方面處理 支持包含Supports: v2/v3 MS Access 97-2003 (*.mdb;*.*) v2/v3 MS Access 2007-2010 (*.accdb)  v2/v3 MS Excel 97-2003 (*.xls) v2/v3 MS Excel 2007-2010 (*.xlsx)  v3 MySQL 5.0/5.1/5.4 or later  MySQL 5.0.91 (2010/05/05) / MySQL 5.1.50 (2010/08/03) / MySQL 5.5.4 (2010/04/09) / MySQL 5.6.0 (2010/08/18) MySql.Data.dll 6.3.4 (2010/08/31) / Connector/ODBC 5.1.7 (2010/08/24) v2 MySQL 4.1/5.0/5.1/5.4  MySQL 4.1.25 (2008/12/01)  MySql.Data.dll 6.2.4 (2010/08/26) v2/v3 Firebird SuperServer/Embedded (*.gdb;*.fdb)  Firebird 1.5.6 (2009/10/08) / Firebird 2.0.6 (2010/06/22) / Firebird 2.1.3 (2009/09/09) v2/v3 SQL Server 2008/2008R2  SQL Server 2008 R2 Express with Management Tools / SQL Server 2008 R2 Books Online SQL Server 2008 R2 Feature Pack / SQL Server 2008 SP1 SQL Server Migration Assistant: Access v4.2 / Oracle v4.2 / Sybase v4.2 / MySQL v1.0 v2/v3 SQL Server 2000/2005  SQL Server 2005 SP3 / SQL Server 2005 SP3 Express Edition with Advanced Services v2/v3 SQL Azure  v3 SQL Server CE 4.0 CTP (*.sdf)  SQL Server Compact 4.0 CTP(4.0.8402.1)(2010/06/24): Windows Desktop v2 SQL Server CE 3.5sp2 (*.sdf)  SQL Server Compact 3.5 SP2(3.5.8080.0)(2010/04/12): Windows Desktop / Server Tools v2/v3 SQLite (*.db;*.db3;*.sqlite)  System.Data.SQLite.DLL 1.0.66.0(SQLite 3.6.23.1) (2010/04/18) v2/v3 PostgreSQL  PostgreSQL 8.4.4 (2010/05/17) / Npgsql.dll 2.0.10(2010/08/01) v2/v3 Oracle 10g or higher  Oracle Ask Tom / Oracle Database Instant Client v2/v3 dBASE IV (*.dbf) v2/v3 Data Sources(OleDB)  Microsoft OLE DB Provider for Visual FoxPro 9.0 v2/v3 ODBC DSN(Data Source Name)  Q: Database .NET requirements需求為何? (v3)Microsoft .NET Framework 3.5 or higher確認已安裝或內建 .NET 3.5 (v2)Microsoft .NET Framework 2.0 or higher, if running on Windows 2K/XP/2003確認已安裝或內建 .NET 2.0 即可(自 Vista 起與之後的作業系統均已內建無需安裝) Q: 如何反安裝How to uninstall Database .NET? (File) 無需反安裝, 只須刪除該檔案You don’t have to uninstall it, just delete the file. (Default folder) (Win 2000/XP/2003) x:\Documents and Settings\<UserName>\Application Data\Database (Vista or later) x:\Users\<UserName>\AppData\Roaming\Database (Registry) [-HKEY_CURRENT_USER\Software\VB and VBA Program Settings\fishDatabase] Q: Connecting To A Database Using Windows Authentication With Different Credentials Using Database .NET Local: runas /user:DOMAIN\USERNAME "x:\Database3.exe" Remote: runas /netonly /user:DOMAIN\USERNAME "x:\Database3.exe" Q: 如何在只有 .NET 4.0 環境下使用How it works in .NET 4.0 only? A: Create Database.exe.config file that includes the following code segment and put it in the same directory as the Database.exe file... <?xml version="1.0" encoding="utf-8" ?> <configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v2.0.50727"/> <supportedRuntime version="v3.5.30729"/> <supportedRuntime version="v4.0"/> </startup> </configuration>  軟體特色Features 整合支持多種資料庫平台, 單一檔案方便攜帶與使用All-In-One, Multlanguage and Standalone 語法高亮顯示Syntax Highlighting 資料表編輯Table Editor: SQL Azure/SQL Server 2005/2008 資料庫自動化處理 (無須透過SQL命令或外部執行)Automatically (w/o SQL command): 密碼保護Protect Database: Access 97-2003/Access 2007-2010/SQL Server CE/SQLite 自動新建Create Database: (Portable) Access 2000/Access 2007-2010/Firebird/SQL Server CE/SQLite, (Server) MySQL/SQL Server/Oracle/PostgreSQL 自動壓縮Shrink Database: Access 97-2003/Access 2007-2010/Firebird/MySQL(MyISAM)/SQL Server/SQL Server CE/SQLite/PostgreSQL 備份還原Backup/Restore Database: MySQL/SQL Server/PostgreSQL Generate Scripts: Data Definition Language (DDL), INSERT statement scripts 資料庫服務管理Service Manager: Firebird/MySQL/PostgreSQL/SQL Server (需管理員權限(當UAC開啟時)Requires Administrator privileges(if UAC is enabled)) 多頁籤查詢Multiple Query Tabs, 多頁籤結果顯示Multiple Results 程式碼範例管理Code Examples: 搜尋(支持一般匹配搜尋與規則運算式搜尋方式)Search with RegEx, (焦點+快捷建Focused+Shortcut key: Enter, 焦點+快捷建Focused+Shortcut key: F5) 拖放資料庫加載DragDrop Database: *.mdb/.accdb/.xls/.xlsx/.gdb/.fdb/.sdf/.db/.db3/.sqlite 結果輸出Export to CSV/XML/TXT/XLS/SQL 多國語言顯示Multiple Language 結果顯示列印Print query results 自訂[其他連接參數]設定Additional connection string parameters  介面語言翻譯Translations 感謝所有捐助者Thanks all contributors Thai language (by Thammapat.c)(Ver 3.3) Vietnamese language (by Tran Huu Qui)(Ver 3.0) German language (by Waler, Stefan)(Ver 2.9) Spanish language (by German Valencia)(Ver 2.9) Portugues language (by Claudio Henrique Medina Blaia)(Ver 2.9) Romanian language (by g a)(Ver 2.8) Polish language (by Jarosław Głowacki ) (Ver 2.7) Italian language (by Stefano Gallina) (Ver 2.6) 分享您的體驗Share your experience