将数据从 MS SQL 迁移到 PostgreSQL? [英] migrate data from MS SQL to PostgreSQL?

问题描述

我环顾四周，似乎找不到任何可以回答这个特定问题的东西.

I've looked around and can't seem to find anything that answers this specific question.

将数据从 MS SQL Server 2005 数据库移动到 Postgres 安装 (8.x) 的最简单方法是什么?

What is the simplest way to move data from an MS SQL Server 2005 DB to a Postgres install (8.x)?

我研究了几个实用程序，如完全转换企业"等，但它们都因某种原因而失败，从导致其爆炸的奇怪错误到插入空值而不是实际数据(wth?).

I've looked into several utilities like "Full Convert Enterprise", etc, and they all fail for one reason or another, ranging from strange errors that make it blow up to inserting nulls rather than actual data (wth?).

我正在查看一个包含所有表的数据库，除了单个视图，没有存储过程、函数等.

I'm looking at a DB with all table except for a single view, no stored procs, functions, etc.

此时我要编写一个小实用程序来为我做这件事，我简直不敢相信这是必要的.肯定有 something 可以做到这一点吗?我什至不太担心成本，虽然最好是免费的:)

At this point I'm about to write a small utility to do it for me, I just can't believe that's necessary. Surely there's something somewhere that can do this? I'm not even too worried about cost, although free is preferable :)

推荐答案

看看软件目录.在 管理/开发工具 我看到 DBConvert for MS SQL &PostgreSQL.可能还列出了其他类似的工具.

Take a look at the Software Catalogue. Under Administration/development tools I see DBConvert for MS SQL & PostgreSQL. Probably there are other similar tools listed.

这篇关于将数据从 MS SQL 迁移到 PostgreSQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！