Active Query Builder 是可視化SQL數據庫查詢程式。其允許用戶進行複雜的SQL查詢,數據解析,分析SQL查詢結果與將之可視化。Active SQL Query Builder是一個真正雙向的查詢創建器,因此用戶可以將可視化查詢創建與SQL查詢結果的文本編輯相結合。
Active Query Builder is a full-featured component suite for software developers. It includes:
A Visual Query Builder component to design SQL queries via an intuitive visual interface.
An SQL Query Parser to build an SQL query object model of any given SQL query.
An SQL Text Editor with code completion and syntax highlighting.
A highly-customizable SQL Query Text Formatter.
A powerful SQL Query Builder API to modify existing and create new SQL queries by the code.
A set of components to build feature-rich data browsing UI with data filtration, sorting and pagination.
A set of helpers to connect to different databases and execute SQL queries against them.
Aqua Data Studio 產品是一款供資料庫數據軟體開發人員和商業分析師的整合開發環境。其提供四大主要領域功能:
資料庫查詢和管理工具
比較資料庫、源控制與檔案系統的工具
用於Subversion (SVN)和CVS的完整與整合源控制客戶端強大的單機資料庫圖解工具 和資料庫類比軟體。
資料庫 IDE:資料庫查詢與管理工具讓開發員能夠輕鬆地建立、編輯與執行 SQL 指令碼,以及瀏覽和直觀地修改資料庫結構。Aqua Data Studio 以同所有主要關聯資料庫相一致的介面提供了一個整合資料庫環境。這讓資料庫管理員或開發員能夠從單獨一個應用程式上就可以處理眾多任務。
比較工具:Aqua Data Studio 中的比較工具套件讓您能夠輕鬆地檢視 RDBMS 伺服器資料庫和資料庫任務架構的區別。您還能以進一步比較檔案的目錄架構來控制檔案及完整修訂的區別。
查詢工具
SQL 記錄/封存
SQL 偵錯程式
SQL 格式化工具
資料庫架構比較
查詢結果比較
目錄比較
檔案比較
版本控制:整合版本控制為Subversion (SVN)和CVS庫提供了一個完整的用戶端,讓您能夠使用庫瀏覽器(Repository Browser),在一個易於使用的整合開發環境(IDE)中管理所有來源控制庫。
資料庫模擬:實體關聯模擬器 (Entity-Relationship Modeler) 可大幅縮短開發時間,並提高對資料庫架構及關聯的理解。您可以建立、探查、詳述和修改資料庫架構,以建立完全可以編輯且可以生成指令碼的資料庫關聯與物件的圖表。
語言支持:英語、西班牙語、法語、葡萄牙語、葡萄牙語(巴西)、義大利語、德語、荷蘭語、波蘭語、捷克語、丹麥語、挪威語、瑞典語、芬蘭語、俄語、希臘語、印地語、韓語、中文(繁體)、中文(簡體)和日語。
更新介紹
Aqua Data Studio 21.1 adds support for a new database platform: Amazon Athena.
Amazon Athena
In Aqua Data Studio Version 21.1 release, we now support Amazon Athena, a database that doesn't need a server. Now Aqua Data Studio gives you the ease to analyze data in Amazon S3 using standard SQL.
Aqua Data Studio gives you the ease of registering, connecting, querying and analyzing your data to gain valuable insights. Create Amazon Athena Database objects - Schemas, Tables, Views, Functions and much more through Aqua Data Studio's highly streamlined Visual Editing UI. Our Export tool, Query Builder, ER Modeler, Compare Tools, plus many other features are available for Amazon Athena. Our Visual Analytics is a powerful and interactive visualization tool that quickly creates insightful charts of your data via a drag & drop interface.
VoltDB
With the Aqua Data Studio v21.1 release, we now offer DDL support in Query Analyzer for VoltDB 9.3. This gives users the ability to work with VoltDB from the Aqua Data Studio Query Analyzer window.
MongoDB - JSON File
Aqua Data Studio v21.1 has added the ability to Import and Export a JSON file in a MongoDB database. This feature is only available in the Ultimate Edition.
Import and Export of a JSON file in Aqua Data Studiio v21.1 supports four types of JSON:
Line delimited JSON...
Codecharge Studio是在外觀上創造資料庫網頁實用最豐富的解決方案不用編碼. 其實際上支援所有的資料庫,網頁伺服器,以及網頁科技 這是一個給網頁開發的完整解決方案。
不論您是個傳統的開發者,微軟Access程式設計者或是有經驗的網頁設計師,您可以使用 CodeCharge Studio 來迅速地開發任何簡單的資料庫網頁元件以結合電子商務解決方案。
其包含了套件建造者能快速地轉換您的資料庫(MS Access, MS SQL, Orcle, etc.)到網頁 元件. 並且利用登入受到保護的使用者進入資料庫搜尋,名單,觀看以及更新功能。
同時還包含了CodeCharge Studio 在 FrontPage 的附掛功能- 第一個產品完整的支援 FrontPage, 完整的網頁開發環境讓它快速並且容易的來創造使資料庫有效的網站。
版本比較
產品特性
CodeCharge Studio
CodeCharge Studio個人版
頁數
無限制
100
資料庫連線數
無限制
1
支援的技術
All of the following:
ASP (VBScript), .NET (C#), .NET (VB), PHP, ColdFusion, Perl, Java Servlets, JSP
One of the following:
ASP, ColdFusion, Java, Perl, PHP, .NET
儲存程序支援
V
X
Web Reporting
V
X
VSS/CVS Source Control Integration
V
X
系統支援
Technologies supported by CodeCharge Studio
Web technologies: PHP, ASP.NET/C#, ASP.NET/VB, Perl, ColdFusion, Java Servlets, JSP.
Databases: MySQL, MS SQL Server, MS Access, PostgreSQL, and all others that support Web connectivity.
Web Servers: ALL Web servers are supported, including Apache, IIS, etc. on all platforms (Windows, Linux, Mac)
CodeCharge Studio itself runs on Windows XP, 2000, 2003, Vista, 7, 2008
Language, Server and Database Support
Languages: Supports ASP.NET 2.0, 3.5, 4 (C# and VB.NET), ASP/VBScript, JSP, Java Servlets, ColdFusion, PHP 4, PHP 5 and Perl 5.0.
Application servers: Supports industry-standard servers including Apache, Microsoft IIS, Adobe ColdFusion, IBM WebSphere, BEA WebLogic.
Site publisher: publishes the project to the sever with a single click.
Databases: Data Source wizard-speeds connectivity to virtually any database including: Microsoft SQL Server, Oracle, DB2, MySQL, and Microsoft Access. Supports access to multiple databases simultaneously. Visual query builder creates SQL queries without coding.
COZYROC SSIS+
COZYROC SSIS+ is a comprehensive suite of 200+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. Our easy-to-use, coding-free library of tasks, components and reusable scripts can significantly cut your development time and also improve the execution speed of your SSIS packages. COZYROC SSIS+ Components Suite has been successfully used by thousands of businesses, in more than 140 countries around the world.
系統需求
COZYROC SSIS+
Supported versions of SQL Server
Supported versions of Visual Studio
2
2019, 2017, 2016, 2014, 2012
2019, 2017, 2015, 2013, 2012, 2010
1.9
2019, 2017, 2016, 2014, 2012, 2008, 2005
2019, 2017, 2015, 2013, 2012, 2010, 2008, 2005
1.8
2017, 2016, 2014, 2012, 2008, 2005
2017*, 2015, 2013, 2012, 2010, 2008, 2005
1.7
2016, 2014, 2012, 2008, 2005
2015**, 2013, 2012, 2010, 2008, 2005
1.6
2014, 2012, 2008, 2005
2013, 2012, 2010, 2008, 2005
1.5
2008, 2005
2008, 2005
1.4
2008, 2005
2008, 2005
1.3
2008, 2005
2008, 2005
SQL Server
Supported versions of Visual Studio
2019
2019, 2017
2017
2017, 2015
2016
2017, 2015
2014
2017, 2015, 2013, 2012
2012
2017, 2015, 2012, 2010
2008
2008
2005
2005
* SSIS+ 1.8 in Visual Studio 2017 is not supported in SSDT 15.8.1 or later (i.e. SSDT with SQL Server 2019 support)
** SSIS+ 1.7 in Visual Studio 2015 is not supported in SSDT 17.0 or later (i.e. SSDT with SQL Server 2017 support)
Dataedo 快速產生資料庫文件
Dataedo 是一款功能強大的 SQL Server、Oracle 及 MySQL 資料庫自動化文件產生工具。 它使您能夠建立資料庫字典(描述所有資料元素),在您的資料庫中建立實體關係圖或文檔存儲過程和函數。
Dataedo 資料庫文件產生工具是 Windows 應用程式,它連接到現有資料庫並導入模式,然後使用者可以提供描述並將文件匯出為 PDF、HTML 或 Excel 格式檔案。
使用 Dataedot 自動化產製資料庫文件的主要流程如下:
Import schema from database
Describe database elements
Export documentation (to PDF or HTML) (optional:)
Update documentation when database schema changed
Go to 2