SQL Manager
SQL Manager for PostgreSQL provides a set of easy-to-use visual editors for any database or server objects. You can create complex queries visually or use editor tool with code completion, code folding, formatting and many other useful features. You can adjust editor view to meet your requirements. Query results can be easily exported to any format. Manipulate data with filters, grouping, sorting and sub-levels, view it as JSON, Image or XML and export it into any of popular formats, including XLSX, CSV, TXT, XML, SQL and more. Advanced import from MS Excel, MS Access, DBF, XML, ODF, TXT, CSV, etc. with selecting the method of adding data to the already existing tables, as well as processing or replacing of inserted data. Data export into a variety of popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF and more with flexible setting for the result data view.
Learn more
CompareData
Compare and synchronize sql data visually.
CompareData allows you to visually compare and synchronize data between sql databases.
Compare table, view or query data and see differences highlighted on the screen. Compare table metadata, generate sql sync script, use the command line and internal scheduling to automate comparison and data synchronization.
• Compare data of table, query or group of tables.
• Synchronize table data at row, table or group level.
• Compare table metadata including columns, primary key, indices, foreign keys, triggers, permission and check constraints.
• Compare stored procedures, functions and sequences,
• Cross-dbms support with ODBC.
• Compare resultsets of any size.
• Native 64-bit application.
• Multi-threaded, multi-core support.
• Free for comparing data and metadata.
Learn more
Memento Database
Flexibility and diversity of the features make it possible to create an app that perfectly suits your taste. Dozens of types of fields, including text, number, date/time, checkboxes, currency, image, file, calculation, locations, relations and others. Displaying data in the form of a list, a set of cards, a table, on a map, or in a calendar. Performing Data analysis, including aggregation, charting, sorting, grouping, and filtering entries by any fields. Memento allows the synchronizing of data with the cloud and provides various tools for teamwork. Huge functionality for experienced users and simplicity for the ones who just want to organize the everyday life are connected in a single solution that do work for numerous cases. Memento supports offline work. You can transfer data in the offline mode and synchronize it with the cloud later.Memento's catalog of user templates contains thousands of predefined, ready-to-use libraries to use directly or serve as a starting place.
Learn more
KS DB Merge Tools
KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of particular object type (table definitions, views, etc.), and then down to definition of particular object. Data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column.
Various diff results provide quick filters to show only new/changed/new+changed items (schema objects or table data rows), ability to select required changed items and generate scripts to apply these changes to the other side database. This script can be executed immediately or saved for future use.
Learn more