DBMS Tools
2010-07-09 10:31:50| 分类:
dbms
| 标签:
|举报
|字号大中小 订阅
1.General functionality
Database Browser
Query Result Browser
Database Conversion/Migration/Replication/Backup
Test Data Generator
Benchmark
View Size (Table & Index)
SQL Export(Dump to an ASCII text file /Writing query result to a file ) / Import(Load text file into a database )
Diff (Schema / Data Comparator)/Merge/Sync
Compaction
View Heap/Index/Buffer/Logs
Query history
Ad-hoc Query Execution
Consistency Checks
Query Execution Plan Viewer
2.Third-party Tools
eg. SQL Maestro
1). Graphical User Interface (GUI)
2). Database object management
3). Copy/paste and drag-and-drop for database objects
4). Working with several databases simultaneously
5). SQL code management including visual query builder and script processor
6). BLOB viewer/editor (Hex dump, Text, Image and HTML formats)
7). OLAP and Diagram viewers
8). Export : file formats (Excel, Access, Word, HTML, XML, PDF, ...)
9). Import : several file format (Excel, Access, CSV, etc)
3.DBMS Vendors' Tools
eg. MySQL Workbench - Database Modeling Tool
1). design your database in conceptual, logical and physical levels
2). SQL script generation (export as SQL CREATE script)
3). visual representation of tables, views, stored procedure/functions
4). database reverse-engineering
5). database/model synchronization
评论这张
转发至微博
转发至微博
评论