åéµåäºä¸æ°æ®åºè¿ç§»ï¼ä»Sql Server2005è¿ç§»å°Oracle
10gï¼è¿é说ä¸ä¸è¿ç§»çæ¹æ³ã
Sql
ServeråOracleåºå«æ¯è¾å¤§ï¼å
æ¬è¯æ³ï¼å段类åï¼æ°æ®åºæºå¶ï¼é
置管çæ¹æ³ççï¼åºå«æ¯å
¨æ¹ä½çï¼åè¿ç§»éè¦æ³¨æå¾å¤é®é¢ï¼å¨è¿ç§»è¿ç¨ä¸ä¹ä¼éå°é®é¢ï¼éè¦ç»ç»å¤çä¹ãè¿é说ä¸ä¸æ°æ®åºç»æçè¿ç§»ï¼åè¿ç§»è¿ç¨ä¸æ³¨æçä¸äºé®é¢ãï¼å½ç¶å
·ä½çæ°æ®åºè¿ç§»è¿ç¨ä¸å¯è½é®é¢æ¯ä¸ä¸æ ·çï¼å
·ä½é®é¢å
·ä½åæäºï¼
è¿ç§»çæ¹æ³æ¯ä»Sql Serverå·²ææ°æ®åºä¸çæåºOracleç建åºèæ¬ï¼ç¶åå¨Oracleæ°æ®åºä¸æ§è¡ãç¨å°ççæå·¥å
·æ¯Power
Designerã
1ãæå¼PDï¼Power
Designerç®ç§°ï¼ä»¥ä¸å使ç¨PDï¼ï¼æ°å»ºä¸ä¸ªPDMï¼ç©çæ°æ®æ¨¡åï¼ï¼DBMSéæ©Microsoft SQL
Server2005,Model nameèµ·åå«åmssdbã
2ãéè¿éåå·¥ç¨å°ç°æSql
Serveræ°æ®åºçæPDM
ï¼1ï¼éæ©Database->Reverse
Engineer Databaseï¼é
ç½®æ°æ®æºï¼éæ©è¦è¿ç§»çæ°æ®åºï¼è¾å
¥ç¨æ·åãå¯ç ã
ï¼2ï¼éæ©æ°æ®åºï¼éæ©ç¨æ·dboä¸çææ表ãè§å¾ãåå¨è¿ç¨ãæ¹æ³ã触åå¨ãåºåçï¼ç±äºSql Serverä¸oracleï¼æ°æ®åºæ¦å¿µä¸çåºå«ï¼è¿éä¸ééæ©ç¨æ·ãè§è²ï¼ã
ç¹å»OKï¼çæPDMãå·²ç»å»ºç«è¿PDMçæ
åµï¼è¿ä¸æ¥å¯ä»¥çç¥ã
3ãçæOracleç©çæ°æ®æ¨¡å
éæ©Tools->Generate Physical Data Model
ï¼1ï¼DBMSéæ©Oracle
10gï¼è¾å
¥å称ï¼oradbã
ï¼2ï¼å¨Configure Model
Optionsé
ç½®ä¸ï¼ Model SettingsçTable&Viewçé¢ä¸ï¼å¾éIgnore
identifying ownerãOracleä¸ç¨æ·çæ¦å¿µä¸Sql Serverä¸åï¼è¿é忽ç¥ownerã
ï¼3ï¼Selectionæ ç¾ï¼éæ©éè¦çæçææ表ãè§å¾ãå¤é®ãåå¨è¿ç¨ãæ¹æ³ã触åå¨ãåºåçã
ç¹å»ç¡®å®ï¼å³çæäºoracle çPDMã
注æï¼å¨çæPDMçè¿ç¨ä¸å¯è½ä¸ä¼ä¸å¸é£é¡ºï¼æå¯è½ä¼æ¥éï¼æ¯å¦æ示对象é¿åº¦è¶
éï¼ï¼è¿ä¼å¯¼è´çæ失败ãè¿æ¶éè¦æ ¹æ®å
·ä½é误æ示åç¸åºä¿®æ¹ï¼å¯è½éè¦å¤æ¬¡è°æ´ï¼æ²¡æåæ³ï¼è°è®©ä¸¤è
å·®å«è¿ä¹å¤§çå¢ï¼ã
4ãçæOracleèæ¬
ä¸Sql
Serverä¸åçæ¯ï¼å¨Oracleé表åãå段åå
¨é¨ä¸ºå¤§åï¼è¥è¦åç¬å¤ç为å°åï¼éå ä¸åå¼å·ãèPDçæçèæ¬é»è®¤æ¯æåå¼å·çï¼è¿ééè¦ä¿®æ¹é»è®¤é
ç½®ï¼å»æåå¼å·ã
ç¶åéæ©oradbï¼ç¶åéæ©Database->Generate
Databaseï¼è¿å
¥æ°æ®åºçæçé¢
å¨Formatæ ç¾ä¸ï¼å»æå¾éOwner prefixï¼å®å°çæ建表è¯å¥åâdbo.âæ带æ¥ç麻ç¦ï¼
å¨Selectionæ ç¾ä¸ï¼éæ©è¦çæèæ¬çå对象ï¼
å¨Previewæ ç¾ä¸ï¼å¯ä»¥é¢è§é¢çæçèæ¬ï¼è¡¨è¾å¤æ¶ï¼åæ¢ä¼æ¯è¾æ
¢ï¼ã
ç¹å»ç¡®å®ï¼å³å¾å°çæçèæ¬ã
5ãæ£æ¥ä¸è°æ´
èæ¬æ¯PDèªå¨çæçï¼å 为表æ¯è¾å¤ï¼å¨oracleä¸ç´æ¥å»æ§è¡é¾å
ä¼æé误ãæ以å¨æ§è¡ä¹åéè¦æ£æ¥ä¸èæ¬çæ£ç¡®æ§ãè¿éæå ç¹éè¦æ³¨æçå°æ¹ã
ï¼1ï¼Oracleè¦æ±è¡¨åãå段åçé¿åº¦æå¤æ¯30ä½ï¼èSql Server没æè¿ä¸ªéå¶ï¼æ以å¯è½ä¼æå¨Sql
Serverå建æ£å¸¸ç表èå¨Oracleä¸ä¼å建失败ã
ï¼2ï¼æ£æ¥ä¸ä¸ä¸»é®ãå¤é®çå称ï¼å®ä»¬æå¯è½æ¯éæºçæçå称ãå¯æ ¹æ®ç¸åºè§èè¿è¡ä¿®æ¹ã
ï¼3ï¼æ£æ¥å段åæ¯å¦ç¨å°äºOracleçå
³é®åãæ¯å¦Sql
Serverå½åâå¤æ³¨âå段å¯è½ä¼ç¨âcommentâãæ é¢ç¨âtitleâï¼ä½commentãtitleå¨Oracleä¸æ¯å
³é®åï¼ä¸å¯ä»¥å为å段å称ã
ï¼4ï¼åå¨è¿ç¨ãæ¹æ³æ¯å¦ç¬¦åOracleè¯æ³ã
ï¼5ï¼Sql
Serveræèªå¢å段ï¼èOracle没æãè¦å®ç°æ¤åè½ï¼éè¦ç¸åºå建åºåã触åå¨ã
ï¼6ï¼Sql
Serverä¸å段类å为textçæ
åµï¼å¦ææ¯åäºè¿å¶æ°æ®éè¦å¨Oracleä¸éç¨Blobå段类åã
ï¼7ï¼Sql
Serveræå¤é®çæ
åµï¼ä¸»è¡¨è®°å½å é¤ï¼ä»è¡¨è®°å½ä¹ä¼è·çå é¤ï¼èOracleé»è®¤æ
åµæ¯å½ä»è¡¨æè®°å½æ¶ï¼æ对åºç主表记å½ä¸å
许å é¤ãæ以è¿ç§æ
åµä¸å¤é®éè¦æ·»å å¤é®çº§èå é¤ã
ï¼8ï¼çæç表ãè§å¾ç个æ°æ¯å¦æ£ç¡®ï¼ç¼ºå¤±çæ
åµå¯åç¬çæèæ¬ã
ç³»ç»ä¸ä¸æ ·ï¼åºç°é®é¢çç¹å¯è½ä¹ä¸ä¸æ ·ï¼å
·ä½é®é¢å
·ä½åæã
6ã建åº
å¨Oracleæ°æ®åºæå¡ï¼å½ç¶è¦å
å®è£
好Oracleæå¡ç«¯ã并建ç«æ°æ®åºï¼orclå®ä¾ä¸ï¼ä½¿ç¨ç¨æ·sysç»é并å建ç¨æ·orauserï¼å¹¶å°resourceãconnectè§è²èµç»orauserï¼è¿éï¼orauser使ç¨é»è®¤è¡¨ç©ºé´ãé»è®¤ä¸´æ¶è¡¨ç©ºé´ï¼ã
ç¨åå建çç¨æ·orauserç»éorclæ°æ®åºæå¡ï¼æ§è¡åé¢å·²ç»çæçèæ¬ï¼è¥å¹²åéåèæ¬æ§è¡å®æ¯ï¼è§å¯ä¸ä¸æ§è¡è¿ç¨ä¸ææ é误产çï¼ä¹å¯ä»¥è®°å½æ§è¡çæ¥å¿ä»¥ä¾¿æ¥åæ¥çï¼æ£æ¥ç表ãè§å¾ç个æ°ä¸Sql
Serveræ°æ®åºä¸æ¯å¦ä¸è´ãå¦æé½æ£ç¡®ï¼é£ä¹ï¼æ°æ®åºç»æä»Sql
Serverå°Oracleçè¿ç§»å°æ¤ç»æãå½ç¶ï¼è¿ç§»çæ¯å¦æ£ç¡®è¿éè¦å¨ä¹åç使ç¨ä¸æ£æ¥ï¼åç°é误åæ¶ä¿®æ¹å³å¯ã
温馨提示:答案为网友推荐,仅供参考