将数据从 MS SQL 迁移到 PostgreSQL?

migrate data from MS SQL to PostgreSQL?(将数据从 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 数据库移动到 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?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Execute complex raw SQL query in EF6(在EF6中执行复杂的原始SQL查询)
SSIS: Model design issue causing duplications - can two fact tables be connected?(SSIS:模型设计问题导致重复-两个事实表可以连接吗?)
SQL Server Graph Database - shortest path using multiple edge types(SQL Server图形数据库-使用多种边类型的最短路径)
Invalid column name when using EF Core filtered includes(使用EF核心过滤包括时无效的列名)
How should make faster SQL Server filtering procedure with many parameters(如何让多参数的SQL Server过滤程序更快)
How can I generate an entity–relationship (ER) diagram of a database using Microsoft SQL Server Management Studio?(如何使用Microsoft SQL Server Management Studio生成数据库的实体关系(ER)图?)