IT 專業技術分享

        最近很多客戶都在問SharePlex支援Oracle database 移轉到EDB postgreSQL嗎？所以才整理這篇文章，請參考原廠文件說明，希望能幫到各位。 1. SharePlex 9.2.1 支援移轉的異質資料庫版本 2. SharePlex 9.2.1 支援對異質資料庫的DDL 3.需要安裝ODBC dirver 4.Oracle 移轉到PostgraSQL 的對應資料型態 5.Oracle 移轉到EDB PostgreSQL 的對應資料型態 6. EDB postgreSQL 安裝時須注意事項

Many friends are asking, if you want to migrate from Oracle to other Database, what should I do? In fact, EDB is a good solution, I hope this article helps you understand how to be compatible with Oracle database. 1.   Preinstallation Step 1. Please download and install JDk 1.7.      Step 2. Please download JDBC driver for Oracle. http://www.enterprisedb.com/downloads/third-party-jdbc-drivers      Step 3. Please put ojdbcxx.jar file to $JAVA_HOME\jre\lib\ext. 2.Begin to install EDB postgres Advanced Server      Step 1. Download and Unzip installation file.       https://www.enterprisedb.com/legal/document/terms-and-conditions?destination=node/19                                                 Important Step!!Please choose Compatible wit...