OracleÊý¾Ý¿â±¸·ÝÓÐÄÄЩ£¿
OracleÊý¾Ý¿â±¸·ÝÓÐÄÄЩ£¿µ¼Èëµ¼³öµÄ¸ÅÄ
ËÏþµÃ£¬ËµÏÂÀ²
rman,imp,exp ¾³£Óõ½ÕâÖÓ£¬ÆäËûûÔõôÓùý
µ¼Èëµ¼³ö¸ÅÄîÊÇɶ
ÏȰÑÊý¾Ý¿âµ¼³öµ½Ò»¸ödmpÎļþÀï¡£
¿ÉÒÔÓÃÕâ¸ödmpÎļþ°ÑÕâ¸öÊý¾Ý¿âÔÚ»¹Ôµ½Êý¾Ý¿âÀï¡£
½¨ÒéÂ¥Ö÷Âò±¾Êé¿´¿´..
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ConnectÁ¬½ÓûÎÊÌ⣬²éѯÓï¾äÔÚworksheetÀïÄܲé³öÒ»Ìõ£¬µ«ÊÇreturn ocd.ExecuteReader()ȴûÓÐÕâÌõÊý¾Ý£¬Çë½ÌÏÂ
C# code:
string m_ConnectionString = "User ID=DQADMIN;Data Source=MyBASE;Pa ......
MSSQL2000 to Oracle 10g, text×Ö¶ÎÔõô´¦Àí£¿
ÓÃdtsµ¼Èë\µ¼³ö¹¤¾ß£¿
ѧϰ°ï¶¥²ä·Ö
sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀàÐÍÊÇclobÀàÐÍ¡£
ÀûÓÃsqlserverµÄµ¼Èëµ¼³ö¹¦ÄÜ
× ......