将数据从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 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 :)

推荐答案

看看软件目录.在管理/开发工具下，我看到

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屋！