DbMouse PRO 6.0.1

Advertising
Software information
Platform:
Windows 7
Publisher:
JenaSoft
Price:
$59
File size:
6.40 Mb
Date added:
March 24, 2014
Screenshot:
Product page:
Description from the Publisher

DbMouse is database-oriented data management console working with Microsoft SQL Server. It offers modern and effective tools for effective work with database. Although it is very simple to use, even for beginners, it offers powerful features for advanced users.

It supports features to create simple application layer.

Working with data

DbMouse comes with very efficient and powerful data admin tools. With installation of DbMouse, you will get also perfect  database administration tool. With DbMouse master/detail views, you will see bindings and dependencies between database data much better than even before!

Data browser, reference views

  • Easy to use column filters
  • Sorting result sets
  • Master/detail views (detail views for each table are stored in database project)
  • Show/hide table columns
  • Ability to add columns from related tables
  • Lookups (preview of destination foreign key row), selecting rows from validation tables
  • Automatic master/detail views created from foreign keys
  • Column layout - ability to view columns from tables referenced by foreign keys

Database explorer & administration tools

Are you tired with your old database administration tools? Try DbMouse! Displayed database structure is always up-to-date, there is no need to refresh database structure. As ddatabase structure is preloaded, all operations are extremely fast.

Database explorer

  • Browse tables, views, stored procedures, functions and triggers
  • Search quickly across all database objects and table columns
  • Visualise database structure in nice moder-looking shaded diagrams
  • Generate SQL scripts for selected database objects

Database administration

  • Create tables, views, stored procedures, functions and triggers
  • Alter, rename or delete all supported objects
  • Browse or modify table keys, references and indexes

Table designer

  • Columns - inluding computed and sparse columns
  • Easy to create and modify foreign keys + ability to automatically create referenced column
  • Primary key, Foreign key and Index editor
  • Check constraints editor

Query designer

DbMouse query designer is the easiest way how to create SQL queries. It helps you creating complex queries, also you can in comfortably use, even if you don't know SQL syntax.

  • Drag & drop tables and joins
  • Support for SELECT, UPDATE, DELETE, INSERT commands
  • Support for left, right, inner and outer join
  • Quick adding referenced table (using column context menu)
  • Condition builder with handy conditions not directly supported by SQL (column contains text?, column contains one of string?). You can build complex conditions with AND and OR operators in the some as trivial conditions
  • Saving and loading designed scripts, generating SQL from designed query

Database projects

Collect are data related with one database structure together! Database structure is handy collection of all, what you have configured or created for specific database structure.

Content

Databas project contains following information:

  • Connections to databases
  • SQL scripts
  • Database diagram
  • Favorites
  • Workspaces
  • Column layouts
  • Various settings, preferences
  • Data widgets

Data Widgets introduction

Data widgets is new functionality available in PRO edition, released in versions 2.3.4 (BETA) and 2.4.0 (RELEASE). Data widgets are set of widgets (user interface elements displaying data). Each widget is displaying result of query. Query can depend on parameters and on underlying object primary key.

Data jobs - export, import

DbMouse export/import system is strongly based upon DbShell. It means that all exports/imports can be saved to job file, which can be easily modified and, eg. you could join jobs together or split large jobs into more smaller jobs.

Exports

  • Export table data to CSV, HTML, TXT, MS Excel, SQL or local storage
  • Export data from single or multiple tables, from query result, from views
  • Import data using DbShell templates

DbShell templates

  • Customize CSV export
  • Customize HTML export (you could easily defined HTML to be exported)
  • Export data to other database
  • Export all tables
  • Export binary fields
  • Create HTML documentation
Users reviews & testimonials

This software is not reviewed yet.

Advertising
Other downloads from this publisher

Easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Main features: Creating and restoring backups. Transfer data between databases, tables and data files or edit database schema.

Quick and easy database administration, natively supports Oracle,MSSQL,MySQL,SQLite,Postgre SQL,MS Access,EffiProz. Main features: Manage database schema and data. Export and import, scheduling. Query builder. Synchronize databases.

Modern ribbon-based data manipulation tool for Microsoft SQL Server. Quick database browser. Search in database model. Master/detail views. Advanced data filtering. Export, import. Exports can be saved as jobs. DbShell console. Database diagrams.