Skip site navigation (1) Skip section navigation (2)

Software Catalogue - Administration/development tools

65 product(s) were found in this category.

Product 0ra2PG
Description

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automaticaly and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database.

Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate some Oracle data into a PostgreSQL database. It is really easy to used and doesn't need any Oracle database knowledge than providing the parameters needed to connect to the Oracle database.

Licence Open source
Pricing info Free
Publisher Dalibo
Product Admin4
Description

Admin4 is a tool for server maintenance via several plugin modules, running on Windows, Mac OSX, Linux and many more platforms. Currently, plugins for BIND DNS, LDAP and PostgreSQL are included. It is designed as a framework, using Python for fast development of plugins and custom modifications.

Licence Open source
Publisher Admin4 Project
Product Barman
Description

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python.

It allows an organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.

Barman most wanted features include backup catalogs, retention policies, remote recovery, archiving and compression of WAL files and backups.

Barman is open source, and its code is distributed under GNU General Public License 3 terms.

For more information and downloads:

Licence Open source
Pricing info Free
Publisher 2ndQuadrant Italia
Product Citrus Replay Professional
Description

Citrus Replay can help you understand your data faster, and in more depth.

Perform rapid data exploration. Quickly check codes, data patterns, verify keys and find duplicates. Easily compare data, codes and aggregates across data sources.

Create visual rules with automatic exception handling to validate or verify your data and find exceptions quickly.

Create a library of data checks for specific applications, functional areas, or projects. Easily reuse these rules across different databases.

Find exceptions by charting any result set, drill-down into the underlying data and export suspect rows straight into Excel.

Communicate and share understanding with Live Analysis which can be securely emailed to the original source, re-executed and verified.

Built-in Password management and Data Encryption ensures your data is secure.

With an intuitive, consistent user-experience across all databases, no server-side impact, no configuration and no training requirement, you're getting results from day one.

28 Day free trial download

Licence Commercial
Pricing info £199
Publisher Citrus Technology Ltd
Product CopyCat Developer
Description

CopyCat Developer is a set of Delphi / C++Builder components providing customizable replication for PostgreSQL, Firebird, Interbase, Microsoft SQL Server, MySQL, NexusDB, SQLite and Oracle, including heterogeneous replication between different database types.

Licence Commercial
Pricing info 499 Euro
Publisher Microtec CopyCat
Product Database Designer for PostgreSQL
Description

Database structure modeling, generation and modification focused on PostgreSQL. Database Designer for PostgreSQL is an easy CASE tool with intuitive graphical interface allowing you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.

Licence Commercial
Pricing info Starts at $124.95
Publisher microOLAP
Product Database .NET
Description

Database .NET is an innovative, powerful and intuitive multiple database management tool, you can Browse objects, Design tables, Edit rows, Export data and run Queries with a consistent interface.

Features:

  • Browse Objects
  • Table Editor
  • Index Editor
  • Data Editor
  • SQL Editor
    • Multiple Query Tabs
    • Multiple Results
    • Find In Grid
  • Data Visualization
  • Database Diagram
  • Generate scripts: DDL, INSERT
  • Code Manager
  • Connection Profile
  • Connection Manager
  • Export to CSV/XML/TXT/XLS/XLSX/SQL/HTM/JSON
  • Print SQL statements and query results
  • Unicode and MultiLingual Support
  • … and much more.

Supports:

  • PostgreSQL 8.x/9.x
  • SQL Server 2000/2005/2008/2008R2/2012
  • SQL Server CE 3.1/3.5/4.0 (*.sdf;*.*)
  • SQL Server Express and LocalDB
  • SQL Azure
  • SQLite (*.db;*.db3;*.sqlite;*.*)
  • MySQL
  • Firebird Super/Classic/Embedded Server (*.gdb;*.fdb;*.*)
  • Oracle
  • IBM DB2
  • IBM Informix
  • Sybase ASE
  • MS Access 97-2003 (*.mdb;*.mde;*.*)
  • MS Access 2007-2013 (*.accdb;*.accde;*.*)
  • MS Excel 97-2003 (*.xls;*.*)
  • MS Excel 2007-2013 (*.xlsx;*.xlsm;*.xlsb;*.*)
  • dBase IV (*.dbf)
  • FoxPro (*.dbc)
  • Data Sources (OLE DB) (*.udl;*.*)
  • ODBC DSN (Data Source Name) (*.dsn;*.*)
  • OData (Open Data Protocol)

Free, Portable, All-In-One, Easy to Use and Multlanguage.

Supported Platforms: Windows XP/2003/Vista/2008/7/8/2012 (x86/x64)

Requires: .NET Framework 4.0 or higher

More Info: http://fishcodelib.com/Database.htm

Licence Freeware
Pricing info 0
Publisher fish's dotNET
Product DataFiller
Description

DataFiller version 1.1.1

DataFiller generates random data from a database schema enriched with simple directives in SQL comments to drive eleven data generators which cover typical data types. Reasonable defaults are provided, especially based on key and type constraints, so that few directives should be necessary. The minimum setup is to specify the relative size of tables with directive mult so that the data generation can be scaled.

See the documentation or download. License is GPLv3.

Run with option --test=comics and look at the output for a didactic example.

Licence Open source
Pricing info I like postcards.
Publisher Fabien Coelho
Product DBConvert for Access & PostgreSQL
Description

Convert databases from MS Access to PostgreSQL and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

The tool provides the most efficient and easiest way of Access queries conversion to PostgreSQL views including the following types: simple queries of SELECT type, queries with MS Access standard functions (not including statistical with NZ prefix), crosstable queries. DBConvert for Access and PostgreSQL can convert SQL queries AUTOMATICALLY. No need to learn the differences in SQL dialects.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DBConvert for MS SQL & PostgreSQL
Description

Convert databases between PostgreSQL, MS SQL and SQL Azure in any direction rapidly and reliably. Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 5-10 minutes to convert approximately 1 Million records.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DBConvert for MySQL & PostgreSQL
Description

Convert databases from MySQL to PostgreSQL and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 3-5 minutes to convert approximately 1 Million records.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DBConvert for PostgreSQL and Oracle
Description

Convert databases from Oracle to PostgreSQL and vice versa rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

It takes about 5-7 minutes to convert approximately 1 Million records in both directions.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode.

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DB Data Difftective
Description

DB Data Difftective is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly. Uses a native connection to PostgreSQL databases.

Licence Commercial
Pricing info $125
Publisher Datanamic
Product dbDeveloper
Description

dbDeveloper is a visual development tool for exploration, creation and modification of multiple databases in a very easy way. It offers a variety of functions from development via tuning up to the deployment and data manipulation.

dbDeveloper supports most popular databases including PostgreSQL server. With the direct database connection and simple compact interface it can speed up your wark and make it more efficient. It is a great tool for every database developer but can also be very useful for administrators and for the end users thanks to its easy-to-use graphical interface.

Licence Commercial
Pricing info 50 Euros
Publisher Prominentus
Product dbForge Data Compare for PostgreSQL
Description

dbForge Data Compare for PostgreSQL is a table data comparison and synchronization tool, which allows you to detect data differences in compared PostgreSQL tables, generate data synchronization script and execute it to eliminate all the differences.

Key Features:

  • Flexible customization of database object mapping. You can either automatically or manually map schemas, tables, views, columns, use custom mapping to map schemas or database objects that can not be mapped automatically.
  • Comfortable view of data differences. Easy and quick data comparison results processing, as they are displayed in a convenient way in the Data Comparison document. Database objects can be filtered by the differences.
  • Full control over data to synchronize. Ability to exclude tables or individual records from synchronization after comparison.
  • Easy to use Data Synchronization wizard. Data Synchronization wizard enables you to customize synchronization settings. You can backup target database before synchronization. Generated synchronization script can be immediately applied to the target database or saved in a file.
  • Warnings of possible data loss and various notifications. Before synchronization you will be warned if errors or data loss may occur because of types incompatibility. Also you will be notified about data overflow, rounding, etc.
  • Large script execution. Execute large scripts without opening script in the SQL editor and loading the whole script in memory. When you try to open a large script, you will be prompted to execute it instead with the help of the Execute Script Wizard.
  • Compare and sync data via command line. Compare and synchronize data via command line. There is no need to open the application and go through the wizard pages any more. -Friendly GUI. Data Compare for PostgreSQL provides a self-intuitive user interface, so you will quickly learn how to use the product to your advantage.
Licence Commercial
Pricing info 99.95
Publisher Devart
Product DBForms from MS Access to PHP + PostgreSQL
Description

DBForms from MS Access to PHP + PostgreSQL allows you to convert MS Access forms to WEB pages and Microsoft Access tables to PostgreSQL database.

Using the modern and the popular web technologies, as AJAX, we fully changed data mapping from Access database to web forms. These up-to-date combinations of technologies are also used by GMail and Yahoo web-based email services. Ajax allows users to receive database information without overloading web pages as before, provide significant time economy and improvement performance.

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DB Schema Difftective
Description

DB Schema Difftective is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences, stored procedures, triggers and constraints between two databases. Generates PostgreSQL compatible alter database scripts.

Licence Commercial
Pricing info $195
Publisher Datanamic
Product DBSync for MS Access & PostgreSQL
Description

Synchronize MS Access and PostgreSQL databases rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed

Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DBSync for MS SQL & PostgreSQL
Description

Synchronize PostgreSQL, MS SQL and SQL Azure databases in any direction rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DBSync for MySQL & PostgreSQL
Description

Synchronize PostgreSQL and MySQL databases rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed.

As well, two PostgreSQL databases can be set up as source and destination.

Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DBSync for Oracle & PostgreSQL
Description

Synchronize date between PostgreSQL and Oracle databases. Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed

Update, Insert and Drop synchronization allow keeping distributed databases in agreement.

Customize your data synchronization process and database migration totally Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode

Licence Commercial
Pricing info $99
Publisher DMSoft Technologies
Product DBTransfer
Description

DBTransfer - versatile and fast database transfer tool

DBTransfer is a multi-platform Java tool that aims to replicate one database (JDBC or MS Access) to another (JDBC), using an one to one conversion..

It currently supports:

  • PostgreSQL (tested)
  • MSSQL (tested)
  • MySQL/MariaDB/Percona (tested)
  • Oracle (tested)
  • DB2 (needs testing)
  • Access (read only, tested).

With DBTransfer, you can:

  • Copy data from one database type to another type. Example: you can migrate your MSSQL to PostgreSQL, without losing the structure, including not only the original schema, the constraints, and of course, the data it self, which is converted to respective data-type.
  • Copy one database schema to another.
  • Move data from one database to another.
  • Compare two databases.
Licence Open source
Publisher Evolute
Product DeZign for Databases
Description

DeZign for Databases is an intuitive database design tool for database developers that can help you model, create and maintain PostgreSQL (and others) databases. It uses entity relationship diagrams to graphically design databases.

Our latest version also adds support for PostgreSQL data model comparisons. In additional to PostgreSQL 7, PostgreSQL 8 (including 8.1) is supported as well.

Licence Commercial
Pricing info Starts at 229 USD
Publisher Datanamic
Product Dreamcoder for PostgreSQL
Description

DreamCoder for PostgreSQL is a powerful Integrated Development Environment (IDE) for PostgreSQL Databases. With the intuitive DreamCoder's GUI increase your code quality and reduce the development process time.

DreamCoder for PostgreSQL you will easily be able to build and execute queries, build and execute scripts, compile PL/pgSQL code, create and modify database objects, import and export data, user session monitor and database monitor among others.

DreamCoder for PostgreSQL offers powerful visual tools for increase your productivity like SQL editor, PL/pgSQL editor, master detail table browser, parameter manager, SQL formatter, query builder, SQL history, session monitor, among others features.

Licence Commercial
Pricing info Starts at $85, discounts available
Publisher Mentat Technologies
Product DSL Platform
Description

Invasive software composition platform for building business applications.

Domain model is declared using DSL based on Domain-Driven Design. Postgres database is maintained from that model:

  • tables, views, types, functions and other database objects are created, modified and recreated
  • advanced migrations are supported: whenever possible data migration will be performed without data loss
  • object oriented features are utilized: nested types as values, tables as entities, views as snowflakes and aggregates
  • listen/notify for cache invalidation
  • a lot of other boilerplate...
Licence Multiple
Publisher N.G.S.
Product EMS Data Comparer for PostgreSQL
Description

EMS Data Comparer for PostgreSQL is a powerful and easy-to-use tool for PostgreSQL data comparison and synchronization. Using this utility you can view all the differences in compared PostgreSQL tables and execute an automatically generated script to eliminate these differences. Flexible customization of the PostgreSQL comparison and synchronization process will enable you to select tables and fields for comparison, perform partial PostgreSQL data synchronization or data comparison for several tables at once and tune many other options to effectively compare PostgreSQL table data.

Data Comparer for PostgreSQL includes a graphical wizard that will guide you through the PostgreSQL data comparison and synchronization process step by step, and a command-line utility for synchronizing PostgreSQL data in one-touch.

Licence Commercial
Pricing info $47.00 (Non-commercial), $95.00 (Business). Maintenance included, discounts available.
Publisher EMS
Product EMS Data Export for PostgreSQL
Description

EMS Data Export for PostgreSQL is a powerful tool to export PostgreSQL database data quickly to any of 19 available formats, including MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF, ODF and others. The program supports Unicode data and has the ability to export PostgreSQL data from several tables, views or queries at the same time. Data Export for PostgreSQL includes a wizard, which allows you to set PostgreSQL export options for each table visually (destination filename, exported fields, data formats, and much more) and a command line utility to export PostgreSQL data from tables and queries in one-touch.

Licence Commercial
Pricing info $47.00 (Non-commercial), $95.00 (Business). Maintenance included, discounts available
Publisher EMS
Product EMS Data Import for PostgreSQL
Description

EMS Data Import for PostgreSQL is a powerful tool to import data to PostgreSQL tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination PostgreSQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for PostgreSQL includes a wizard, which allows you to set all the PostgreSQL import options for different files visually, and a command-line utility to execute import to PostgreSQL database in one-touch.

Licence Commercial
Pricing info $47.00 (Non-commercial), $95.00 (Business). Maintenance included, discounts available.
Publisher EMS
Product EMS DB Comparer for PostgreSQL
Description

EMS DB Comparer for PostgreSQL is an excellent tool for PostgreSQL database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to synchronize structure of PostgreSQL databases and eliminate all or selected differences. The program has the ability to automate PostgreSQL database schemas comparison and synchronization task using the helpful Console Application.

Having EMS DB Comparer for PostgreSQL you can work with several projects at once, define PostgreSQL comparison parameters, print difference reports, and alter modification scripts. Its user-friendly interface greatly simplifies discovering and eliminating differences in PostgreSQL database structure saving your time and therefore money.

Licence Commercial
Pricing info $47.00 (Non-commercial), $95.00 (Business). Maintenance included, discounts available.
Publisher EMS
Product EMS SQL Management Studio for PostgreSQL
Description

EMS SQL Management Studio for PostgreSQL is a complete solution for PostgreSQL database administration and development. With components that focus on all critical PostgreSQL database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering PostgreSQL databases, managing database schema and objects as well as for PostgreSQL database design, migration, extraction, PostgreSQL query building, data import, export and database comparison. SQL Studio unites these database tools for PostgreSQL in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing PostgreSQL database administrators and PostgreSQL application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for PostgreSQL offers all essential PostgreSQL tools to make you more productive than ever before!

Licence Commercial
Pricing info $257.00 (Non-commercial), $518.00 (Business). Maintenance included, discounts available
Publisher EMS
Product EMS SQL Manager for PostgreSQL
Description

EMS SQL Manager for PostgreSQL is a high performance tool for PostgreSQL database administration and development. It works with any PostgreSQL versions up to the newest one and supports the latest PostgreSQL features including enumerated, text search, XML and UUID data types, PostgreSQL index key sorting order, arrays of composite types, and others. SQL Manager for PostgreSQL offers plenty of powerful database tools such as Visual Database Designer to create PostgreSQL database in few clicks, Visual Query Builder to build complicated PostgreSQL queries, powerful BLOB editor and many more useful features for efficient PostgreSQL administration. SQL Manager for PostgreSQL has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Licence Commercial
Pricing info $135.00 (Non-commercial), $275.00 (Business). Maintenance included, discounts available
Publisher EMS
Product ESF Database Convert
Description

Enables you to transfer data between PostgreSQL and others database/file systems, e.g.: MySQL, Oracle, SQL Server, Microsoft Access/Excel, FireBIrd, SQLite, CSV etc.

With the step-by-step wizard GUI, everyone can easy transfer data from one to the others. Just select a data source and a target output format, ESF Database Convert can transfer table structure, data, indexes, primary keys, foreign keys and so on automation.

Also, this tool provides some advance options to custom converting process, e.g.: rename table/field name, change field data type/default value ...

Licence Commercial
Pricing info $219 for Standard Edition, and $259 for Professional Edition
Publisher EasyFrom Inc
Product ESF Database Migration Toolkit
Description

Enables you to transfer data between PostgreSQL and others database/file systems, e.g.: MySQL, Oracle, SQL Server, Microsoft Access/Excel, FireBIrd, SQLite, CSV etc.

With the step-by-step wizard GUI, everyone can easy transfer data from one to the others. Just select a data source and a target output format, ESF Database Convert can transfer table structure, data, indexes, primary keys, foreign keys and so on automation.

Also, this tool provides some advance options to custom converting process, e.g.: rename table/field name, change field data type/default value ...

Licence Commercial
Pricing info $219 for Standard Edition, and $259 for Professional Edition
Publisher EasyFrom Inc
Product FPPostgreSQL Framework
Description

FPPostgreSQL Framework is a Cocoa framework allowing the user to interact with a PostgreSQL database using mainly Requests or stored procedures. You get in return data as Cocoa standard object such as NSString, NSArray and NSNumber.

It proposes beside of the synchronous a asynchronous mode, using Notifications. This mode use a queue system with dependancies, cancel function and completly threaded.

It requires PostgreSQL 8.3 and Mac OS X 10.5 (Leopard)

Licence Commercial
Pricing info Free
Publisher Flying Pig
Product Interactive SQL for PostgreSQL
Description

Interactive SQL for PostgreSQL is powerful database utility for building, executing and processing queries upon PostgreSQL databases, which allows you to build SQL queries visually even without any knowledge of SQL, execute them and get the result as quickly as possible.

Licence Commercial
Pricing info $39.95
Publisher microOLAP
Product Lightning Admin for PostgreSQL
Description

Lightning Admin for Postgresql is a GUI administration tool for Windows and Linux (using WINE) workstations. It has many advanced features such as:

  1. Advanced function/query/view editors with code completion,function parameter hinting and full SQL syntax highlighting.
  2. Function Version Control.
  3. Grant Manager, uses a grid to rapidly set object permissions.
  4. Threaded query editor that allows long running queries to be canceled.
  5. Compiled with a native windows compiler using a high performance memory manager, no runtimes or VMs needed.
  6. Tabbed MDI user interface.
Licence Commercial
Pricing info Subscription Price varies from 24.99 to 79.99
Publisher AM Software Design
Product LIMBAS
Description

Limbas is a flexible, free web-based database frontend based on PHP. It includes functions like reporting, tabularys and base functions like DMS. There are existing solutions for workflows, CRM, CMS, ticketsystems, webshop, product database, groupware, call center.

Licence Open source
Publisher Limbas
Product Louise
Description

Louise is an importing data utility. Using the foreign key system Louise import data from a CSV file ton several table. It allows the user to perform duplicate search, apply formatters and modify the CSV before an update.

You can as well export the SQL code, save the project or export the content as CSV file.

Louise is based on FPPostgreSQL Framework.

Licence Commercial
Pricing info 69 €
Publisher Flying Pig
Product ManyDesigns Portofino
Description

Create a webapp from an existing database in 30 seconds!

Portofino is a free and open source web framework that helps developers create outstanding enterprise applications by addressing three specific needs: productivity, features and architecture.

Among its features: content management, CRUD, database connectivity, calendars, charts, security and easy customization using Groovy.

A wizard allows the developer to create a web application by connecting to an existing.database quickly and easily

Licence Open source
Pricing info Free
Publisher ManyDesigns S.r.l.
Product MSSQL-to-PostgreSQL
Description

MSSQL-to-PostgreSQL is a program to migrate Microsoft SQL or SQL Azure databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

  • All versions of Microsoft SQL are supported (including SQL Azure)
  • All versions of PostgreSQL are supported
  • Option to merge MS SQL data into an existing PostgreSQL database
  • Option to synchronize PostgreSQL database with MS SQL data
  • Option to filter data using SELECT-queries
  • Converts foreign keys
  • Option to convert individual tables
  • Converts indexes with all necessary attributes
  • Command line support
  • Stores conversion settings into profile
  • Support for multibyte character sets
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • Does not convert views, stored procedures and triggers
  • Demo version converts only 5 records per table

Requirements

  • PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run MSSQL-to-PostgreSQL from)
  • Necessary privileges to write into the destination database
Licence Commercial
Pricing info 49
Publisher Intelligent Converters
Product MySQL-to-PostgreSQL
Description

MySQL-to-PostgreSQL is a program to migrate PostgreSQL databases to MySQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

  • All versions of PostgreSQL are supported
  • All versions of Unix and Windows MySQL are supported
  • Fast conversion engine (about 10,000 records per second of average P-IV system)
  • Option to merge PostgreSQL data into an existing MySQL database
  • Option to convert individual tables
  • Converts indexes with all necessary attributes
  • Command line support
  • Stores conversion settings into profile
  • Support for multibyte character sets
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • Does not convert foreign keys
  • Does not convert views, stored procedures and triggers
  • Demo version converts only 5 records per table

Requirements

  • PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run MySQL-to-PostgreSQL from)
  • Necessary privileges to write into the destination database

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only five records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results: http://www.convert-in.com/sql2pgs.htm

Licence Commercial
Pricing info 49
Publisher Intelligent Converters
Product Navicat PostgreSQL GUI
Description

Navicat™ is a powerful PostgreSQL database administration and development tool that are not only sophisticated enough for professional developers, but also easy to learn for new users. With an user-friendly GUI, Navicat™ lets you quickly and easily create, organize, access and share information in a secure and convenient way.

Navicat supports multiple PostgreSQL server connections which can be connected locally or remotely. Your remote PostgreSQL server can be running on Linux, Unix, Mac OS X or Windows platform.

Licence Commercial
Pricing info $75 - $139 Depending on version, discount plans available.
Publisher Navicat
Product Oracle-to-PostgreSQL
Description

Oracle-to-PostgreSQL is a program to migrate Oracle databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

  • All versions of Oracle and PostgreSQL are supported
  • Option to merge Oracle data into an existing PostgreSQL database
  • Option to synchronize PostgreSQL database with Oracle data
  • Option to filter data using SELECT-queries
  • Converts foreign keys
  • Option to convert individual tables
  • Converts indexes with all necessary attributes
  • Command line support
  • Stores conversion settings into profile
  • Support for multibyte character sets
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • Does not convert views, stored procedures and triggers
  • Demo version converts only 5 records per table and does not convert foreign keys

Requirements

  • PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run Oracle-to-PostgreSQL from)
  • Necessary privileges to write into the destination database
Licence Commercial
Pricing info 49
Publisher Intelligent Converters
Product pgAdmin
Description

Open Source administration and management tools for the PostgreSQL database. Includes a graphical administration interface, an SQL query tool, a procedural code editor and much more. pgAdmin III is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. Available in more than a dozen languages and for most common operating systems.

Licence Open source
Publisher pgAdmin Development Team
Product pgCompare
Description

pgCompare application has been built basing on our experience gained during business web applications creation. We have identified the need of patching various versions of databases used by different developers by merging the changes that were made by different people at the same time on their development enviroments.

pgCompare tool allows to easily compare 2 databases based on PostgreSQL engine in scope of:

  • differences regarding database structure - including tables, views, stored procedures (functions), and triggers
  • differences in data stored in tables - including comparison based on single- and multicolumn keys The result of application work is a file containing SQL commands that should be executed against source database, so the identified differences will be applied there.

Comparison is executed using simple and intuitive wizard web interface. There is also possibility to save the INI file containing the comparison configuration, that can be used in the future, as well as as a parameter for command-line tool usage. The command-line functionality can be then used for databases comparison performed in the background e.g. during nightly application builds.

Licence Commercial
Pricing info 99,00 EUR
Publisher COBA Solutions Ltd
Product pgEdit
Description

pgEdit is a high performance SQL editor and development environment designed specifically for PostgreSQL relational databases. pgEdit features include SQL syntax coloring, direct source code execution, PHP support, integrated documentation, and extensive customizable editing facilities.

pgEdit uses psql, the interactive terminal application included with every PostgreSQL installation. This makes it easy to develop with pgEdit and then transfer your work to any PostgreSQL installation for maintenance and production tasks.

pgEdit is a native application for both Macintosh and Windows. It does not use Java or require installation of external libraries. You have the option of using the version of psql included with pgEdit or a different version installed anywhere on your hard drive.

Licence Commercial
Pricing info $65
Publisher pgedit.com
Product pgloader
Description

PgLoader is the python ETL tool for PostgreSQL, supporting a lot of (possibly convoluted) input formats, and able to load files in parallel.

Either loading several files at once (each in its own PG connection) or the same file in several connections (two collaborative models implemented).

Licence Open source
Pricing info Freely available, under BSD licence
Publisher Dimitri Fontaine
Product phpPgAdmin
Description

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.

Features

* Administer multiple servers
* Support for PostgreSQL 7.0.x, 7.1.x, 7.2.x, 7.3.x, 7.4.x, 8.0.x, 8.1.x, 8.2.x, 8.3.x
* Manage all aspects of:
      o Users & groups
      o Databases
      o Schemas
      o Tables, indexes, constraints, triggers, rules & privileges
      o Views, sequences & functions
      o Advanced objects
      o Reports
* Easy data manipulation:
      o Browse tables, views & reports
      o Execute arbitrary SQL
      o Select, insert, update and delete
* Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump
* Import SQL scripts, COPY data, XML, CSV and Tabbed
* Supports the Slony master-slave replication engine
* Excellent language support:
      o Available in 27 languages
      o No encoding conflicts. Edit Russian data using a Japanese interface!
* Easy to install and configure
Licence Open source
Publisher phpPgAdmin Project
Product Postgres Enterprise Manager
Description

Postgres Enterprise Manager was designed for DBAs and large database installations. Its distributed architecture manages all your PostgreSQL instances on your in-house hardware, on-premise VMs, or in 3rd party cloud environments. Monitoring agents send host and Postgres data to a centralized enterprise management server that is accessible from multiple GUI Client consoles. Performance monitoring dashboards provide user customized metrics for your Server, Database, Memory, I/O, Storage, Object Activity, Operating System, and System Waits each with its own graphs, data, and accompanying alerts to exception conditions. The Capacity Manager answer questions like: How much storage will my database need six months from now?, How fast is my database growing?, What objects are responsible for the growth in my database?, Will my server be able to support another database instance?, Is the performance of my database getting better, staying the same, or getting worse? The SQL Profiler can trace and identify poorly-running SQL code in large and complex systems. You can then sort and filter the resulting statement statistics to quickly find your longest running SQL code and then optimize that code for better performance. You can even send the trace results to the Index Advisor and get index recommendations for any underlying tables to improve SQL response times. Finally, Enterprise Manager offers Postgres Expert, your DBA-in-a-box, to help enforce best practices for your database server configuration parameters, schemas, and security according to best practice guidelines written by the Postgres database specialists at EnterpriseDB.

Licence Commercial
Pricing info Call: +1 781-357-3390 or 1-877-377-4352 (US Only)
Publisher EnterpriseDB Corporation
Product PostgreSQL Database Modeler
Description

PostgreSQL Database Modeler, or simply, pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements. The pgModeler translates the models created by the user to SQL code and apply them onto database server (version 9.x).

Licence Open source
Pricing info 0
Publisher pgModeler
Product PostgreSQL Data Wizard
Description

PostgreSQL Data Wizard is a powerful Windows GUI utility for managing your PostgreSQL data.

PostgreSQL Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. PostgreSQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your PostgreSQL database, export data from PostgreSQL tables and queries to most popular formats, and import data into the tables.

Licence Commercial
Pricing info $59 for a non-commercial license, $99 for a business license.
Publisher SQL Maestro Group
Product PostgreSQL Maestro
Description

PostgreSQL Maestro is a high-quality Windows GUI admin tool for PostgreSQL server management, control and development.

PostgreSQL Maestro allows you to create, edit, copy, extract and drop all the database objects such as schemas, tables, views, functions, domains, rules, sequences, languages, operators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage PostgreSQL roles, users, groups and their privileges, and use a lot of other tools designed for the easiest and most efficient work with PostgreSQL Server.

Licence Commercial
Pricing info $89 for a non-commercial license, $179 for a business license.
Publisher SQL Maestro Group
Product PostgreSQL Studio
Description

PostgreSQL Studio is a web-based, open-source administration tool for PostgreSQL. It includes a AJAX enabled interface, a SQL query tool with syntax highlighting, object creation wizards and more.

Licence Open source
Pricing info Free
Publisher OpenSCG, Inc.
Product PostgreSQL-to-MySQL
Description

PostgreSQL-to-MySQL is a program to migrate PostgreSQL databases to MySQL server. Depending on your privileges on the target MySQL server you can export PostgreSQL data into new database or overwrite the contents of an existing MySQL database. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

  • All versions of PostgreSQL are supported
  • All versions of Unix and Windows MySQL are supported
  • Fast conversion engine (about 10,000 records per second of average P-IV system)
  • Option to merge PostgreSQL data into an existing MySQL database
  • Option to export PostgreSQL data into MySQL dump file
  • Option to convert individual tables
  • Converts indexes with all necessary attributes
  • Command line support
  • Stores conversion settings into profile
  • Support for multibyte character sets
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • Does not convert foreign keys
  • Does not convert views, stored procedures and triggers
  • Demo version converts only 5 records per table

Requirements

  • PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run PostgreSQL-to-MySQL from)
  • Necessary privileges to write into the destination database

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only five records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results: http://www.convert-in.com/pgs2sql.htm

Licence Commercial
Pricing info 49
Publisher Intelligent Converters
Product PyGreSQL
Description

PyGreSQL is an open-source Python module that interfaces to a PostgreSQL database. It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.

Licence Open source
Publisher PyGreSQL Project
Product Ráiteas Enterprise Server
Description

Ráiteas is a platform for doing analytics on the operational aspects of managing a data warehouses. One of our first applications is akin to google analytics but for data warehouse teams.

PostgreSQL support

  • Import the standard PostgreSQL log file. http://raiteas.com/guide/using-postgresql/

Features

  • Save time and money by shortening the length of each development iteration.
  • Reverse engineer data lineage and model which automatically becomes part of your documentation.
  • Improve communication between development team members by visualising and share complicated data.
  • Enable project managers, technical leads and architects to reason about technical elements central to developing data warehouses.
Licence Multiple
Publisher Ráiteas Ltd
Product RHQ
Description

RHQ is an open source systems management solution that runs on PostgreSQL and which also features a plugin to manage and monitor PostgreSQL databases.

RHQ is written in Java and provides a central management UI plus a very flexible and extensible plugin architecture. This allows to easily extend RHQ to your specific needs.

RHQ is currently available in source form only.

Licence Open source
Publisher RHQ Team
Product SQL Data Sets
Description

SQL Data Sets allows you to generate and save data sets retrieved from PostgreSQL, Oracle, SQL Server and ODBC-supported database engine. Saved data sets are compressed and can optionally be encrypted. Shared data sets can be opened by other users using the free SQL Data Sets Viewer. Saved data sets can also be queried further without the need to connect to any database engine, can be exported to HTML, Excel, XML and plain text files. The SQL Data Sets Viewer can also display images stored in binary fields, and identify PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and unprotected Microsoft Office files.

Licence Commercial
Pricing info USD 24.95 for single user, USD 74.95 for company license
Publisher Yohz Software
Product SQL Image Viewer
Description

SQL Image Viewer allows you to retrieve, view, convert and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF. It also allows you to export binary data, and recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and has experimental support for DOC, PPT and XLS file types.

A command line version is also included to allow you to set up unattended scheduled exports of binary data.

Licence Commercial
Pricing info USD 24.95 for single user, USD 79.95 for company license
Publisher Yohz Software
Product SQLTool Pro
Description

Connect and manage MySQL, SQL Server, PostgreSQL, Sybase, and Oracle databases from your Android device.

SQLTool does NOT work with Oracle 11g. It will work with Oracle 10g and below.

Oracle, MySQL, Sybase, PostgreSQL, and SQL Server databases can be managed using the query editor or through a limited amount of built in shortcuts.

Features include:

  • Export table row data to a CSV file
  • Customize-able SQL queries using the query editor
  • Full table listings of each database
  • Quickly empty or drop tables from the SQL Server, MySQL, PostgreSQL, Sybase, or Oracle databases
  • Blazing fast select, insert, and update database queries
  • Different user interfaces for tablets and phones
Licence Commercial
Pricing info 1.99
Publisher SQLTool
Product TeamPostgreSQL
Description

Web interface for PostgreSQL.

Access your databases across the intranet/internet through a completely dynamic powerful Javascript/AJAX based web interface.

Some feature highlights:

  • Powerful data navigation, one-click search, relationship navigation, filtering and more
  • Database management, including database objects and tablespace management
  • Graphical pgdump interface for import/export of individual database objects or entire databases
  • Tabbed SQL editor with SQL auto-completion
  • Favorites function for easy storing and sharing of SQL snippets and scripts
  • Upload and download files directly to/from binary fields

Plus many more.

Licence Freeware
Publisher Webworks
Product Toad Data Modeler
Description

Toad Data Modeler enables developers, DBAs, and designers to create, maintain and document quality database designs and structures across various database platforms, including PostgreSQL 8.1, 8.2 and 8.3. Key features include entity relationship diagrams, reverse engineering, generation of SQL/DDL code, generation of HTML/RTF/PDF reports etc.

Licence Commercial
Pricing info 479 USD
Publisher Quest Software, Inc.
Product Vertabelo
Description

Vertabelo is a visual database design tool available through a web browser. It supports the physical data modeling. Vertabelo offers SQL generation, team work support, public link to model, model versioning, and import/export in XML format.

It is available for free for both free and commercial small scale projects.

Licence Multiple
Pricing info 0-$399 per year
Publisher e-point
Product VMware vFabric Data Director
Description

Improve agility and drastically reduce database TCO through database-aware virtualization and self-service lifecycle management with vFabric Data Director. Securely automate routine tasks, including database provisioning, high availability, backup, and cloning. Data Director is a unified platform for heterogeneous databases, currently supporting Oracle 10gR2, 11gR2, and VMware vFabric Postgres 9.0, 9.1.Enjoy the agility of public cloud database services with enterprise-grade security, flexibility, control and compliance.

Licence Commercial
Publisher VMware Inc
Product WaveMaker
Description

WaveMaker is a fast, easy way to build standards-based web apps for PostgreSQL. WaveMaker's visual, WYSIWYG development studio enables visual development of web applications. In fact, the WaveMaker IDE was built using WaveMaker, so we eat our own dogfood. Available under an Apache license - join our 15,000 strong developer community at dev.wavemaker.com

Licence Open source
Pricing info Free open source software
Publisher WaveMaker Software, Inc.

Note: The PostgreSQL Global Development Group do not endorse or recommend any products listed, and cannot vouch for the quality or reliability of any of them.


Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group