clothessite.blogg.se - Universal sql editor

#Universal sql editor pro

#Universal sql editor pro

Many database operations can be performed from the command line (mostly in Pro version). There is a tool for working with BLOB fields, such as large text and graphics. Data in tables can be highlighted depending on its content (so called conditional formatting). Show Moreĭatabase Tour data grids give you the ability to view CLOB/MEMO (large text) and graphic data, expand rows, use autoscrolling, sorting, selecting group of records, copying data etc. Performing useful operations with databases, such as searching and replacing text, batch data processing, working with database objects etc. Powerful report builder simplifies creating and editing your database reports.

Generating SQL code for specific tasks.

Possibility to execute multi-statement SQL scripts.

Support for database query parameters and macros.

Navigating through the query history and collecting SQL execution statistics for each database query window.

Multiple SQL query windows with separate transactions.

SQL editors with syntax highlighting, code completion, and Ctrl+clickable objects.

Automating data export jobs using command line and action files.

Ability to save export definitions to files in order to reuse them, which is extremely useful for complex data export tasks.

Convenient interface for mapping tables and fields between data sources and target objects.Copying data from database to database, for example, SQLite to Firebird, PostgreSQL to Oracle, Interbase to SQL Server etc.

Highly customizable export output to Excel, HTML, SQL script, DBF, CSV, and more.Support for all major database types like ODBC, SQL Server, Access, Oracle, PostgreSQL, SQLite, Firebird, Interbase, Excel, Visual FoxPro, dBase, Paradox, CSV, MySQL, DB2, SQL Anywhere etc. Here are some areas where Database Tour has competitive advantages among database tools in the marketplace.