Database case tools
You can check out GeoKettle for your request - ETL tool. you can find a good documentation here. it is an open source project and has lots of features.
Extract data from:
Spatial database types: PostGIS, Oracle spatial, MySQL, Microsoft SQL Server 2008*, Ingres* and IBM DB2* SOLAP (Spatial OLAP) system: GeoMondrian Geo files (data formats): Shapefile, GML, KML, OGR OGC Web services: Sensor Observation Service (SOS), Catalogue Web Service (CSW)
What is GeoKettle :
GeoKettle is a powerful, metadata-driven Spatial ETL tool dedicated to the integration of different spatial data sources for building and updating geospatial data warehouses. GeoKettle enables the Extraction of data from data sources, the Transformation of data in order to correct errors, make some data cleansing, change the data structure, make them compliant to defined standards, and the Loading of transformed data into a target DataBase Management System (DBMS) in OLTP or OLAP/SOLAP mode, GIS file or Geospatial Web Service.
GeoKettle is a spatially-enabled version of the generic ETL tool Kettle (Pentaho Data Integration). GeoKettle also benefits from Geospatial capabilities from mature, robust and well know Open Source libraries like JTS, GeoTools, deegree, OGR and, via a plugin, Sextante.