Ticket #88 (new defect) — at Version 9

Opened 14 years ago

Last modified 14 years ago

商城数据库从oracle转postgresql

Reported by: huangzhong Owned by:
Priority: major Milestone: 2012年6.0版本
Component: 系统相关 Version: 6.0
Keywords: 数据库迁移;postgresql Cc:
Due Date: 31/05/2012

Description (last modified by huangzhong) (diff)

一、目标
在商城应用架构不变的基础上把数据库从oracle转到pg

二、任务
1.修改应用代码使之能在pg数据库上正常运行(代码中使用到的oracle特有的功能要去掉)
2.商城所依赖的产品库数据的同步
3.产品库所依赖的商城数据的同步
4.存储过程、方法、定时任务等改造

三、计划

四、转pG问题

 http://rdtrac.pc.com.cn/itm/ticket/89

五、oracle语法和pg语法区别
 http://rdtrac.pc.com.cn/itm/attachment/ticket/88/PG%20vs%20ORACLE.doc
修改代码的工作量
trunc 8
rownum 93
Alias 137
(+) 109
sysdate 42
DECODE 61
nvl 65
Connect by 16
总数为531

Change History

comment:1 Changed 14 years ago by huangzhong

  • Version set to 6.0

comment:2 Changed 14 years ago by huangzhong

  • Keywords 数据库迁移;postgresql added; postgresql removed

comment:3 Changed 14 years ago by huangzhong

  • Component changed from 商家后台 to 系统相关

comment:4 Changed 14 years ago by lisiliang

  • Description modified (diff)

comment:5 Changed 14 years ago by lisiliang

  • Description modified (diff)

comment:6 Changed 14 years ago by huangzhong

  • Description modified (diff)

Changed 14 years ago by huangzhong

comment:7 Changed 14 years ago by huangzhong

  • Description modified (diff)

comment:8 Changed 14 years ago by huangzhong

  • Description modified (diff)

comment:9 Changed 14 years ago by huangzhong

  • Description modified (diff)
Note: See TracTickets for help on using tickets.