Actian Zen (原為 Actian PSQL)
Actian Zen 是一個高性能、穩定、可靠、低維護的數據庫管理系統(DBMS)。藉著您最喜愛的虛擬機管理軟體,不論從VMware、微軟或Citrix上,來運行Actian PSQL的資料庫應用程式,現在都是非常非常簡單的事。
Single architecture – from device to gateway, from server to cloud
Multi-model, multi-platform, embedded in most popular languages
No-ETL between clients, servers, and cloud
Modular: 7MB client to 50MB server to full Enterprise under 200MB
AES 256-bit military-grade encryption
Embed in apps, configurable through APIs
Built-in automated defragmentation
Single data file/table size of 64 TB
系統需求
Platform
Windows 64 bit
Supported OS Releases
Windows Server 2022 21H2, 2019, 2016; 11 21H2, 10 21H1, IoT Enterprise; 8.1; Server 2012 R2; Small Business Server 2011, Windows Server Core Standard and Datacenter 2016 and 2019
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 23.0 adds support for new database platforms like Mongo 5, OS support for Mac Ventura and adds SSO authenticationfor Azure and Redshift databases.
Authorizations for databases
We added authorizations for Azure, AWS Redshift and more.
Support Data Sources
Datasets and Dataset Objects are now supported in any region.
Support Mac Ventura
Users can now use Aqua Data Studio with the new version of Mac Ventura.
More DB version support
Connect using the latest Informix driver, MySQL 8.0.28, Microsoft 11.2, and more.
Informix & MongoDB
Users can now use and access Informix 14, Mongo 5 SQL, MongoJS and MongoShell.
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.1
2022, 2019, 2017, 2016, 2014, 2012
2019, 2017, 2015, 2013, 2012, 2010
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
2022
2019
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
DeZign for Databases
是一個直觀的資料庫設計及建模工具,能幫助開發者以及資料庫管理員來建模、創建以及維護資料庫。此軟體使用實體關係圖(ERDs, data models)以圖形方式設計資料庫,並且自動生成最風行的SQL及桌面資料庫。
DeZign for Databases提供了資料庫應用程式開發的可視化建模環境,讓開發過程便得更簡易,此工具減少了故障開發以及提高您的工作效率。你可以進行可視化資料庫結購,來了解你的資料庫,、創建新的資料庫或反向操作現有的資料庫,去修改、分析及優化
新版介紹
Parallel modeling with folder-based projects
In previous versions, the project data was always stored in a single XML file, which is not well suited for version control integrations. In version 14 we introduce folder-based projects. The project data is split over multiple files (one for each object). Its main advantage is that it's adjusted to store project files in Version Control Systems such as Git: the project data is split over multiple files, and merge conflicts are less likely.
When you open a folder-based project, DeZign for Databases will automatically check the files for merge conflicts.
Available in the Professional and Expert edition
Stay organized with the Labeled objects panel
In DeZign for Databases, you can use labels to categorize your database objects such as entities, views, attributes, etc. Labels are like folders, but with a twist—you can apply several labels to an object, then later find the object by clicking any of its labels from the new Labeled objects browser in the left panel.
It is also possible to create sublabels (nested labels). Sublabels or nested labels, allow you to create a sophisticated organizational structure in the vast swamp of objects and diagrams in your project.
Available in all editions
On-diagram editing
As you design a model, the names of entities and attributes may change. In version 14 you can edit objects directly in the diagram window (Instead of opening the Entity dialog each time you want to change a name).
To invoke the inplace on-diagram editor, simply click on the item you want to edit and hold down the left mousebutton for one second. You can also hold down the Alt-key and click on the item you want to edit.
Available in all editions
Easily switch to another project format
Version 14 supports two types of project formats: folder-based project and a single file project. Single file based projects (.dez files) are best suited to single user development with the project file placed on the developers local drive.
Many projects will start out as single user project and later be migrated into a folder-based project for larger team access (with Git).
You can easily switch from one format to another in the Save as dialog.
Available in the Professional and Expert edition
Label objects in the Object browser
You can now label objects via the object's context menu in the Object browser. You can also drag objects from the Object browser to the and drop the object o...
dBASE
dBASE 創建了現代數據驅動的應用程式,超越了常見的Windows控件,支持多種平台,包括平板電腦,智能手機和高級Web應用程式。添加本機JSON處理顯著增強了創建使用jQuery和多個Javascript庫的現代Web應用程式的能力。結合新的原生組件; RichEdit,RichText和DateTimePicker,dBASE 引入了新功能,為處理數據輸出和應用程式以及報告生成提供了更強大的支持。全新的dBASE 為開發人員提供新工具以完成工作並正確完成工作,無論它是平板電腦上的Windows應用程序還是作為Web應用程式運行。
With dBASE PLUS you can:
• Work in SQL Server data and save it as Informix
• Work in DB2 and save it as dBASE PLUS
• Tie your legacy systems to your Web Site
• Import data from other applications
• Run reports against almost any database
• Automatically generate applications that work with multiple sources simultaneously.
更新介紹
NEW and Updated IDE Support – dBase has optimized almost every aspect of the IDE. This includes new support for Motifs and new support for custom fonts and sizes. These get used by the optimized menus, tabs, status bar, and Inspectors, a make it so much easier to read. It also includes optimized menus on all aspects of the dBASE® 2019 product.
New and Updated Compiler functionality – This is hidden from most developers, but when you need it, it needs to be there. Optimizing the compiler to work faster and support larger code files is very important. Plus, the optimization has increased the speed of the compiler on large source files.
New and Updated Editor Features – The first feature is the NEW Surround functionality. It truly changes the way you develop software. We now have full Bookmark support built-in and we have streamlined the access by totally revamping the context menu in the editor. We have increased the capability of the Find In Files function. We then added new functionality with optimized menus.
NEW and Updated Components – dBASE® 2019 is excited to release the new ArrayRowSet non-visual component. This was one of the most requested features of all time, with the ability to use Arrays as data sources. In addition, we also added additional features to other components as well.
New and Updated ADO support – dBASE® 2019 brings additional optimizations with ADO. We have fixed a number of outstanding issues and as the compiler, many of the updates are in the underlying code.
Quality! – dBASE® 2019 is built on the quality of the prior release, which means the quality is even better than before and we have fixed many additional issues since that last release!