ãã1ã两å°ä¸åæå¡å¨ï¼
ãã2ãä»oracle10gå®æ¶åæ¥ï¼æ¯å¤©åæ¨2:00ï¼å°sqlserver2005ï¼
ãã3ãå¤äºå®å
¨æ§èèï¼å®¢ææ¹ä¸æä¾sqlserver2005çè´¦æ·å¯ç ï¼åªéæ们æä¾æ°æ®éï¼
ãã4ãåæ¹ç¨åºè¯è¨é½ä¸ºjavaï¼
ããå¨è¿äºåæä¸ææåºäºå å¥æ¹æ¡ï¼ä»
ä¾åèï¼
ããaï¼å¦æoracleè½å¨å®¢æ·æå¡å¨ä¸è®¿é®ï¼ç±oracleæ¹æä¾æ¥å£ç»å®¢æ·æå¡å¨å®ç°ï¼è¿åç»å®¢æ·æå¡å¨æéåæ¥æ°æ®ï¼å¹¶ç±å®¢æ·æå¡å¨æä½æ°æ®åå¨å°sqlserver2005ä¸ï¼æ¥å£ä»£ç æè¿°ï¼è¿ç¨å»ºç«jdbcè¿æ¥oracleï¼ä¸´æ¶å¸æ·ï¼ï¼æ¥è¯¢oracleæ¹æä¾çè§å¾ï¼å¹¶è®¿é®å®¢æ·æéæ°æ®éï¼ææjarå
ï¼ç±å®¢æ·æ¹è°ç¨æ¥å£å®ç°æ¹æ³è·å¾æ°æ®ã
ããbï¼å¦æoracleæ¹ä¸è½è¢«å®¢æ·æå¡å¨è®¿é®ï¼åå°éåæ¥æ°æ®ç½®å
¥xmlä¸ï¼å¹¶ç±å®¢ææå¡å¨æ¹è®¿é®å
¶xmlï¼http or socketï¼ï¼å¹¶æoracleæ¹æä¾è§£ææºå¶ï¼è¿åæ°æ®éã
ããcï¼éè¿å¼æºæ°æ®åºåæ¥è½¯ä»¶å®ç°ä¸åï¼googleç»æï¼symmetricdsãopendbdiffï¼é对sqlserverï¼ï¼
ããåé¢ä¸ç§æ¹æ¡åå¯å®ç°ä»oracleåæ¥å°sqlserver2005ï¼ä¸è¿å¦ææ°æ®éè¾å¤§æ¶å¯è½å¯¼è´ä¸éæ°æ®ä¸¢å¤±æè
åæ¥é度è¾æ
¢çæ
åµï¼äºæ¯å¶å®å¦ä¸æ¹æ¡ï¼
ãã建ç«åæ¥è¡¨ï¼å°å®¢æ·æ¹æéæ°æ®è¡¨ä¸å段æ¾å
¥å°åæ¥è¡¨ä¸ï¼å¦ï¼
ããç¨æ·è¡¨ï¼widï¼useridï¼password
ããç¨æ·åæ¥è¡¨ï¼widï¼useridï¼passwordï¼noï¼operationtypeï¼operationdate
ããå¯ä»¥çå°åæ¥è¡¨ä¸å¤äºä¸ä¸ªå段ï¼noï¼operationtypeï¼operationdate
ããno为åºå·ï¼ç±oracleåºåçæï¼operationtype为æä½ç±»åï¼0为æ°å¢ï¼1为修æ¹ï¼2为å é¤ï¼operationdate为æä½æ¥æï¼åå½åå®æ´æ¶é´ï¼å¹´ææ¥åç§ï¼
ãã建ç«ç¨æ·è¡¨è§¦åå¨ï¼å¦æç¨æ·è¡¨ææä½åå°å®¢æ·æ¹æéç¨æ·è¡¨å段æ¾å
¥åæ¥è¡¨ä¸ï¼å¦ææ°å¢å°operationtypeçå¼æå
¥0ï¼ä»¥æ¤ç±»æ¨
ããå¨å®¢ææå¡å¨æ¹ï¼oracleæ¹æä¾æ¥å£æ¥è¯¢åæ¥è¡¨å¾å°ç»æéï¼å¹¶å客æåè®®å¦ä½æä½è¿äºæ°æ®
ããè¿æ ·å°±å¯ä»¥å®ç°åªäºæ°æ®ä¿®æ¹è¿å°±åæ¥åªäºæ°æ®ï¼åå
äºåæ¹æå¡å¨çåå
温馨提示:答案为网友推荐,仅供参考