SQL Server ÒÆÖ²µ½Oralce ÏîĿʵս
ÏîÄ¿±³¾°
ÒÆÖ²Ò»¸öÏÖÓÐϵͳµ½Oracle¡£Ôϵͳ»ùÓÚ.Net Framework 1.1, SQL Server 2000Êý¾Ý¿â£¬Êý¾Ý²Ù×÷»ù±¾È«²¿Ê¹ÓÃStore Procedure£¬×ÜÊýÓâǧ£¬Òò´Ë×ÜÌåÉæ¼°µÄPL SQL ¿ª·¢Á¿±È½Ï´ó¡£
ÓÅÏȼ¶¸ß£¬¿ª·¢Ê±³Ì¶Ì£¬²ÎÓëÈËÔ±¶à£¬ÊÇÕâ¸öÏîÄ¿µÄÏÔÖøÌص㡣±¾ÈË×÷ΪÏîÄ¿¸ºÔðÈË£¬Ö÷Òª°´ÕÕÏÂÁв½Öè½øÐУ¬×îÖÕÔ²Âú´ï³ÉÄ¿±ê¡£
µÚÒ»²½ ÆÀ¹À
1. È·ÈÏÐèÒªÒÆÖ²µÄ¹¦ÄÜÁбí
2. ÆÀ¹ÀÖ÷Òª¹¤×÷Á¿
¹¤×÷ÖصãÔÚÓÚÒÆÖ²SQL Server SPµ½ Oracle Package£¬Ô¤¹ÀÒÆÖ²Ò»¸öSPËùÐèƽ¾ùʱ¼äµÈ
µÚ¶þ²½ Ç°ÆÚ×¼±¸
1. È·¶¨Ä¿±êOracleÊý¾Ý¿âµÄ°æ±¾(Oracle10.1.0.5.0)ºÍ±àÂë(ACTUTF8)
Êý¾Ý¿âµÄ±àÂëÈ·¶¨·Ç³£ÖØÒª£¬ÓÉÓÚÔϵͳ֧³Ö¶àÓïÑÔ´æ´¢£¬ËùÒÔOracleÎÒÃÇÑ¡ÔñÁËACTUTF8¡£ÕâÖÖ±àÂë¶ÔÓ¦µÄSQL Server ÖУ¬1¸ö×Ö·ûÕ¼3¸ö×Ö½Ú¡£
2. Oracle Êý¾Ý¿âÉè¼Æ(×ÉѯOracle DBA)
3. ÆÀ¹À¼¼ÊõÄѵ㣬ÕÒ½â¾ö·½°¸
1) IdentityÀ¸Î»ÊµÏÖ
ʹÓÃTrigger
2) ÁÙʱ±íʵÏÖ
ʹÓÃOracleµÄÁÙʱ±í(8iºóÒÑÌṩ)
3) .Net OracleÇý¶¯³ÌÐò
²ÉÓÃODP.NET
4. È·¶¨SQL Server -> Oracle ±í / À¸Î»Ó³Éä¹Øϵ£¬ÐγÉSQL Server/Oracle ±í¶ÔÕÕÎĵµ
1) Ò»°ãÔÔò£¬Ô¶ÔÏóµÄÃû³Æ²»×ö¸Ä±ä£»
2) À¸Î»ÀàÐÍ£¬×Ö·ûÀàÐÍ -> VARCHAR2, Êý×ÖÀàÐÍ -> NUMBER(m, n)£»
3) À¸Î»³¤¶È£¬×î´ó³¤¶È *3£¬ ±£´æ¹Ì¶¨³¤¶ÈIDµÄÀ¸Î»³¤¶È²»×ö±ä¸ü£»
4) ÔÚOracle Öн¨Á¢¶ÔÓ¦±í£¬Í¨¹ýSQL Server DTSµ¼Èë»ù´¡Êý¾Ý
5. SPʹÓÃPackage×éÖ¯£¬²¢ÖØÐÂÃüÃû£¬ÐγÉSQL Server/Oracle SP¶ÔÕÕÎĵµ¡£
ÒòΪOracle ¶ÔÏóÃû³Æ³¤¶È²»Äܳ¬¹ý30£¬SQL Server µÄSP³¤¶ÈÆձ鳬¹ý30£¬Òò´ËÐèÒªÖØÐÂÃüÃû²¢·Ö×é¡£
6. &nb
Ïà¹ØÎĵµ£º
MS Sql Server ÌṩÁ˺ܶàÊý¾Ý¿âÐÞ¸´µÄÃüÁµ±Êý¾Ý¿âÖÊÒÉ»òÊÇÓеÄÎÞ·¨Íê³É¶Áȡʱ¿ÉÒÔ³¢ÊÔÕâЩÐÞ¸´ÃüÁî¡£
¡¡¡¡1. DBCC CHECKDB
¡¡¡¡ÖØÆô·þÎñÆ÷ºó£¬ÔÚûÓнøÐÐÈκβÙ×÷µÄÇé¿öÏ£¬ÔÚSQL²éѯ·ÖÎöÆ÷ÖÐÖ´ÐÐÒÔÏÂSQL½øÐÐÊý¾Ý¿âµÄÐÞ¸´£¬ÐÞ¸´Êý¾Ý¿â´æÔÚµÄÒ»ÖÂÐÔ´íÎóÓë·ÖÅä´íÎó¡£
use master
declare @databasename varch ......
3¡£±íÄÚÈÝÈçÏÂ
-----------------------------
ID LogTime
1 2008/10/10 10:00:00
1 2008/10/10 10:03:00
1 2008/10/10 10:09:00
2 ¡ ......
<?php
require_once '../../smartyConfig/smartyConfig.class.php';
require_once '../../game/include/function.php';
require_once '../../game/include/config.php';
require_once '../../game/server/server.class.php';
require_once '../../game/include/db.class.php'; ......
×÷Õß Haidong Ji ·Òë GoodKid
ÔÚÎҵĹØÓÚOracleºÍSQL Server »¥ÓÃÐÔµÄϵÁÐÎÄÕ part 1 ºÍ part 2 µ±ÖУ¬ÎÒÌÖÂÛÁËOracleºÍSQL Server µÄһЩ²»Í¬µãµÄ»°ÌâÒÔ¼°OracleÇý¶¯µÄ¿ÉÑ¡ÐÔ¡£ÔÚ±¾Ö÷ÌâÖУ¬ÎÒ½«ÌÖÂÛÒ»¸öÀ´×ÔOracle 10gµÄй¤¾ß£¬Oracle¼´Ê±¿Í»§¶Ë¡£
¶ÔÓÚOracle 10gÒÔÇ°µÄ°æ±¾£¬Èç¹ûÏ뽨Á¢ºÍOracleµÄÁ¬½Ó£¬ ......
ansi_warningºÍansi_nulls Á½¸öÑ¡Ïî±ØÐë´ò¿ª£¬ºÃÏñ¶ÔϵͳҲûɶӰÏì¡£
Â¥Ö÷ÔÙ¼ì²éÒ»ÏÂÁ½¸öµØ·½£¬¾²âÊÔ£¬ÔÚҪʹÓ÷ֲ¼Ê½ÊÂÎñʱ£¬ÕâÊDZØÐëÒªÉèÖõġ£
1¡¢Á´½Ó·þÎñÆ÷ºÍÃû³Æ½âÎöÎÊÌâ
-- ´´½¨Á´½Ó·þÎñÆ÷
EXEC sp_addlinkedserver 'srv_lnk', 'ms', 'SQLOLEDB', '192.168.1. ......