本文是小编为大家收集整理的关于在PostgreSQL中是否有类似SSIS的功能？的处理/解决方法，可以参考本文帮助大家快速定位并解决问题，中文翻译不准确的可切换到English标签页查看源文。
问题描述
我们正在使用 ssis(sql Server Intermation Services)在SQL 2008 R2中复制来自30+数据库(在SQL Server 2000上运行)到单个数据库的数据库表每天都有目的. PostgreSQL中是否有类似SSIS的功能?当我们考虑将来将数据库迁移到开源数据库时.谢谢！
推荐答案
您可以使用SQL Server Integration Services为此.只需使用ODBC连接连接到您的PostgreSQL！ 我自己做.
其他推荐答案
PostgreSQL本身没有类似于SSI的ETL模块，但是有一些开源BI堆栈.最受欢迎的开源ETL工具包可能是 pentaho .pentaho.com/" rel =" nofollow"> kettle .建议在 postgres wiki
其他推荐答案
有pg_dump生成一个可以在另一个数据库上重播的SQL脚本.需要一些脚本来收集30个数据库的数据.
要避免混乱，请注意，在Postgres中，"数据库"可以包含多个"架构" - 在SQL Server中，"实例"可以包含多个"数据库".核心概念大致相当.
问题描述
We are using the SSIS (SQL Server Integration Services) in SQL 2008 R2 to copy database tables from 30+ databases (running on SQL Server 2000) to a single database for data analysis purposes on a daily basis. Is there a SSIS-like feature in PostgreSQL? As we are thinking to migrate our database to open source database in the future. Thanks!
推荐答案
You can use SQL Server Integration Services for that. Just connect to your PostgreSQL using a ODBC connection! I do it myself.
其他推荐答案
PostgreSQL itself doesn't have ETL module similar to ssis, however there are some open-source BI stacks. The most popular open-source ETL toolkit is probably Pentaho's tool Kettle. It's recommended on Postgres wiki
其他推荐答案
There is pg_dump which generates an SQL script that can be replayed on another database. Some scripting will be required to gather data from your 30 databases.
To avoid confusion, note that in Postgres, a "database" can contain multiple "schemas" -- in SQL Server, an "instance" can contain multiple "databases". The core concepts are roughly equivalent.
更多相关问答
联系站长