Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

EMS DB Extract for PostgreSQL stands out as a powerful yet user-friendly solution for generating backups of PostgreSQL databases in the format of SQL scripts. This utility is designed to capture the metadata of all database objects alongside the actual table data, creating a comprehensive snapshot of the database. It ensures that the scripts are generated in the appropriate sequence, taking into account their dependencies. With options for extensive customization, users can choose which objects and tables to include in their dumps and adjust various settings to suit their needs. The tool also features a graphical wizard that provides a step-by-step guide through the extraction process, as well as a command-line interface for quick backups with a single command. Additionally, it offers the capability to extract database objects in dependency order, as well as options for compressing the output script and dividing it into smaller volumes for easier management. This makes EMS DB Extract for PostgreSQL an invaluable asset for anyone looking to secure their database efficiently.

Description

PostGIS serves as an extension for the PostgreSQL object-relational database, enhancing its capabilities with spatial features that enable the execution of geographic queries in SQL. Beyond just fundamental location functionalities, it provides a variety of advanced tools and features that are less common in other spatial databases like Oracle Locator/Spatial and SQL Server. Additionally, with PostgreSQL 14, PostGIS can take advantage of the improved GiST building support API, which significantly boosts performance. When compiled with the latest GEOS 3.10.1, users can benefit from enhancements in the ST_MakeValid function along with various speed optimizations, making it a powerful choice for handling spatial data effectively. This ensures that developers and analysts can work with geospatial data in a more efficient and streamlined manner.

API Access

Has API No 

API Access

Has API No 

Screenshots View All

Screenshots View All

Integrations

PostgreSQL Yes 
Azure Database for PostgreSQL No 
IBM Db2 Yes 
InterBase Yes 
MySQL Yes 
Oracle Database Yes 
SQL Server Yes 

Integrations

PostgreSQL Yes 
Azure Database for PostgreSQL Yes 
IBM Db2 No 
InterBase No 
MySQL No 
Oracle Database No 
SQL Server No 

Pricing Details

No price information available.
Free Trial No 
Free Version No 

Pricing Details

No price information available.
Free Trial No 
Free Version No 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows No 
Mac No 
Linux No 
Chromebook No 

Deployment

Web-Based No 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac Yes 
Linux Yes 
Chromebook No 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours No 
Live Rep (24/7) No 
Online Support Yes 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Vendor Details

Company Name

EMS Software

Founded

1986

Country

United States

Website

www.sqlmanager.net/products/postgresql/extract

Vendor Details

Company Name

PostGIS

Website

postgis.net

Product Features

Database Backup

Automatic Backup No 
Backup Locations No 
Backup Scope Settings No 
Differential Backup No 
Filegroup Backup No 
Full Backup No 
Incremental Backup No 
Manual Backup No 
Multiple Backups No 

Product Features

GIS

3D Imagery No 
Census Data Integration No 
Color Coding No 
Geocoding No 
Image Exporting No 
Image Management No 
Internet Mapping No 
Interoperability No 
Labeling No 
Map Creation No 
Map Sharing No 
Near-Matching No 
Reverse Geocoding No 
Spatial Analysis No 

Alternatives

Alternatives

Agile GIS Reviews

Agile GIS

Agile Applications