将OpenEdge升级到PostgreSQL数据库 [英] Progress OpenEdge to PostgreSQL database
问题描述
我在将Progress OpenEdge数据库转换为PostgreSQL时遇到问题.我已经从此处下载了ODBC，并且当我在计算机中建立ODBC连接(32位)时，连接已建立.接下来，我从此处下载了 Ispirer SQLWays Wizard 2015 .有一些限制，最多100张表，数据2GB等)，并尝试进行转换.一切似乎都很好，源数据库和目标数据库已连接，我仅选择1个表(仅用于测试)，但是当我开始转换时，出现一些奇怪的错误:
I have problem with converting Progress OpenEdge database to PostgreSQL. I have downloaded ODBC from here and when i make ODBC connection (32 bit) in my computer, the connection is established. Next, I downloaded Ispirer SQLWays Wizard 2015 from here (with some limitations, 100 tables max, 2gb od data etc), and tried to make conversion. All seem fine, source and destination databases are connected, I select only 1 table (just for test), but when I start conversion i get some weird error:
[DataDirect] [ODBC Progress OpenEdge Wire Protocol驱动程序] [OPENEDGE]访问被拒绝(授权失败)(7512)
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Access denied (Authorization failed) (7512)
我有点研究了这个错误，发现解决方案应该是:
I kinda looked into this error and saw that solution should be:
- 打开SQL资源管理器并以'sysprogress'身份连接(无密码)
- 授予所需用户DBA特权:
任何帮助该怎么做?还是有其他工具/方式如何将Progress OpenEdge转换为PostgreSQL?
Any help how to do that? Or is there any other tool/way how to convert from Progress OpenEdge to PostgreSQL?
推荐答案
要运行sql Explorer，首先打开"proenv"窗口(您可以在进度"程序组"中找到此窗口). Proenv是一个命令行窗口，具有为您准备的所有必需的Progress环境.打开后，您可以使用sqlexp连接到任何启用了远程连接的正在运行的数据库.类似于以下命令:
To run sql explorer first open a "proenv" window (you can find this in the Progress "program group"). Proenv is a command line window that has all of the necessary Progress environment prepared for you. Once that is open you can use sqlexp to connect to any running database that has remote connections enabled. A command similar to:
proenv> sqlexp -user userName -password passWord -db dbName -S servicePort -infile myScript.sql -outfile myScript.log
如果省略"-infile myScript.sql -outfile myScript.log"，则将其放入SQL命令解释器中.
If you omit "-infile myScript.sql -outfile myScript.log" you will be dropped into a SQL command interpreter.
"myScript.sql"(或键入的任何命令)的具体内容取决于您要完成的工作.但是，记住投入工作"非常重要；如果您不这样做，那么退出时将不保存任何操作.
The specific content of "myScript.sql" (or any commands that you type) depend on what you are trying to accomplish. However -- it is very important to remember to "commit work;" If you do not do so then nothing you do will be saved when you exit.
Progress kbase这篇文章有非常详细的说明，包括如何创建用户和授予DBA特权:
This Progress kbase article has very detailed explanation including how to create users and grant DBA privileges:
https://knowledgebase.progress.com/articles/Article/20143/p
这篇关于将OpenEdge升级到PostgreSQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
