Releases: victor-wiki/DatabaseManager
Releases · victor-wiki/DatabaseManager
Add database diagram, code generator, index fragmentation analysis and get partition table informations
Add database diagram, code generator, index fragmentation analysis and get partition table informations
Latest
new features:
- database diagram;
- use "MiniProfiler" to trace sql performance;
- code generator: generate model class by table or view;
- generate "Insert", "Update" and "Delete" procedure script for table;
- index fragmentation analysis;
- optimize database;
- get partition table informations;
- use "CodeMirror" to highlight sql on web page.
Add data comparison and enhance data import and export
- add data comparison;
- enhance data import and export;
- issue fix for schema comparison;
- add: remember form layout and recent opened sql file;
- use pagination for query result.
Fix some bugs
- quick search: It didn't convert data type to char type when quick search mode is exactly match;
- data editor: data type convert and handle null value.
Add import and export data, and custom config data type mappings
- add
(1) import and export data;
(2) custom config data type mappings and edit data type info before converting;
(3) statistic: table column content max length;
(4) diagnosis: primary key column is nullable;
(5) quick search. - enhance
(1) sql query editor intellisense;
(2) data editor.
3.accumulated bugs fix.
Accumulated bugs fix and a few changes about UI
- fix bugs:
- execute query without limiting return rows
- sqlite: handle index without name
- sql parser: not parse "DISTINCT"
- UI changes
- use fontawesome
- query result grid: find text
Fix some bugs
- Sqlite shouldn't have comment for coulumn;
- Use default name for primary key, foreign key, index and check constraint if it has no name;
- If the delimeter(');') in a table value, the insert sql can't split it correctly;
- Script isn't split correctly by delimiter if the delimiter is in a string value.
v2.2.3
- use "SqlCodeEditor" replace "RichTextBox" for syntax highlighting;
- new feature: edit data;
- main page layout: use dock panel;
- some issue fix.
Fix some bugs and optimize
- oracle: use official bulkcopy
- handle identity column insert
Fix some bugs and optimize
- fix some bugs for sqlite
- clear data: use new strategy
Fix some bugs
- Sqlite autoincrement column
- Database version check: if no connection, use default version
- Computed column: exclude computed column when sync data