ʹÓÃoracle sql developerÒÆÖ²sql sever 2005µÄÎÊÌâ
rt£¬ÎÒÒѽ«Ô´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿âµÄÁ¬½Ó¶¼Ìí¼ÓºÃÁË£¬½ÓÏÂÀ´capture microsoft sql severȴûÓз´Ó¦£¬ÇëÎʸßÊÖÓпÉÄÜÊÇÄÄÀï²»¶Ô£¿
ÓÃquick migrationʱ£¬Ò»Â·Ë³Àû£¬µ½ÁË×îºóÖ´Ðв»³öÀ´¡£
ÄãÓÃplsql/devÁ´½ÓSqlServer£¿ ÕâÑùÄÜÁ¬£¿
ÎÒÒª°Ñsql sever 2008µÄÊý¾Ý¿âÒÆÖ²³Éoracle 10gµÄ£¬Ö÷ÒªÊDZíÊý¾ÝºÍÀïÃæµÄ´æ´¢¹ý³Ì¡£µ¼±í»¹ºÃ˵£¬Ö÷Òª´æ´¢¹ý³Ì²»ÉÙ£¬ÊÖ¶¯ÒÆÖ²Í¦Âé·³µÄ£¬ÏÂÁËoracle sql developer£¬ÍøÉÏÓÐÀÏÍâ˵sql sever 2008»¹²»Ö§³Ö£¬ÓÚÊǽµÖÁ2005¼Ü¹¹ÁË£¬µ«ÊÇÈÔȻû¸ã¶¨£¬Ò»ÇÐת»»Ìõ¼þ¶¼Ñé¹ýÁË£¬¾ÍÊÇ×îºó³ö²»À´¶«Î÷¡£
oracleÁ¬½Ó·½ÃæÃ»ÓÐÎÊÌ⣬sql severµÄÁ¬½ÓÒ²³É¹¦ÁË£¬µ«ÊǺÃÏñcapture ËÀ»î²»Ðа¡
ÕâÖÖÒÆÖ²ÊÇÐèÒªÒ»¶Îʱ¼äµÄ£¬ÎÒ×ö¹ýdb2µ½oracleµÄÒÆÖ²£¬ÓÈÆäÊÇ´æ´¢¹ý³Ì£¬ÐèÒªÒ»¸öÒ»¸öµÄÈ¥¸Ä£¬Óù¤¾ßÖ±½ÓÉú³É£¬ÊDz»Ðеġ£
×îºó»¹ÊÇÊÖ¶¯ÕÛÌÚÍêÁË£¬ÀÛÁ˵㣬²»¹ýÒ²ÊǶÍÁ¶£¬Ð»Ð»smh821025ÒÔ¼°huangdh12
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......