High performance native support for major Database Servers including Microsoft, Sybase ASE, Oracle, IBM DB2 zOS/iSeries/LUW, Informix, PostgreSQL, Teradata, MySQL 支持多数据库,Mysql与Sqlite等是通过ODBC来连接的,如果电脑没有安装Mysql是无法连接的
电脑一直安装的是wampmanager.exe所以无法使用。需要下载Mysql的ODBC驱动并安装见:http://www.docin.com/p-352527140.html
Browse and Explore Servers 同SSMS一样有多少连接
Fast, intelligent, extensive and highly customizable Intellisense 智能感知功能,并可以自定义
Advanced Script Editor with Syntax highlighting, Auto Complete, Speed Typing, Script Variables, Drag/Drop, Column (Block) Mode 语法高亮,关键字自动大小字
Automatically highlight matching parenthesis for BEGIN/END, IF/END IF, CASE/END, ... SQL blocks 自动匹配
Full Unicode support 完整的Unicode支持
x86 and x64 Versions x86 and x64 版本支持
Visual Schema and Data Diff, File Diff, Quick Diff 数据差异对比,也可以比较文件
SQL Object Scripting 生成对象脚本
SQL Formatter and Beautifier Sql格式化,这个没找到
Generate SELECT, INSERT, UPDATE, DELETE, CREATE, WHERE IN data modification statements directly from Result Grid 生成Select,Insert,Update,Delte,Create等语句
SQL Templates with support for formal parameters Sql模板
Parameterized Queries and substitution variables 参数化
Import / Export to CSV, XML, Excel 数据或结果导出
Schema Object browser 表,视图,存储过程等一目了然
SQL statement execution history 查询过的历史记录
Favorite objects. Find object 搜索功能
Search in Database and in Result Grid 在结果中进行搜索,
Directly edit table data in Result Grid 结果中直接编辑
Group, total, sort, filter, format, retrieve parent and child data rows, export and transpose data in Result Grid 在结果中排序,复制到Txt,HTML等
Execute procedures and functions with automatic argument specification 参数化执行存储过程
Graphic Query Execution Plan and Query Statistics 查询计划,仅专业版,个人版本没有
Administrative Views 管理工具
Portable mode
Localized in 10 languages
Simple deployment and removal. No dll's or other dependencies. Just one executable (2.0 meg.)