将数据从MS SQL迁移到PostgreSQL?

本文介绍了将数据从MS SQL迁移到PostgreSQL?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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

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

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

我研究了诸如完全转换企业"之类的几种实用程序，它们都因一种或多种原因而失败，从使它崩溃的奇怪错误到插入空值而不是实际数据(是?).

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?).

我正在查看一个具有所有表的数据库，除了一个视图之外，没有存储的proc，函数等.

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.