| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> liang zhong yu SQL Server shu ju ku jiao huan shu ju de fang fa
 

liang zhong yu SQL Server shu ju ku jiao huan shu ju de fang fa

2008-07-10 05:54:13 编辑來源:互联网 评论
 
本文为【两种与SQL Server数据库交换数据的方法】的拼音翻译版
  yin yan
  Microsoft SQL Server 2005 Mobile Edition 3.0 (SQL Server Mobile) zhi chi liang zhong yu SQL Server shu ju ku jiao huan shu ju de fang fa :
  ◆ he bing fu zhi , ti gong yi zhong qiang da qie gong neng qi quan de jie jue fang an , gai jie jue fang an yuan xu yi dong ying yong cheng xu dui fu zhi de shu ju zi xing geng gai , ran hou zai jiang zhe xie geng gai yu Microsoft SQL Server shu ju ku jin xing he bing , bing zai bi yao shi jie jue chong tu 。
  ◆ yuan cheng shu ju fang wen (RDA), shi yi dong ying yong cheng xu neng gou fang bian di jiang yuan cheng Microsoft SQL Server shu ju ku biao zhong de shu ju du qu ( la ) dao ben di SQL Server Mobile shu ju ku biao zhong , huo zhe jiang ben di SQL Server Mobile shu ju ku biao zhong de shu ju fa song ( tui ) dao yuan cheng Microsoft SQL Server shu ju ku biao zhong 。RDA huan ke yong yu zai yun xing SQL Server de fu wu qi shang fa chu SQL ming ling 。
  jiang SQL Server Mobile lian jie dao SQL Server
  shi yong RDA huo fu zhi gong neng shi ,SQL Server Mobile jiang tong guo Microsoft Internet Information Services (IIS) fu wu qi lian jie dao SQL Server。 you yu yu SQL Server de lian jie you IIS chu li , yin ci nin de she bei zhi xu neng gou shi yong HTTP huo HTTPS xie yi lian jie dao IIS Web fu wu qi ji ke 。 zhe yang yi lai , nin jiu ke yi tong guo zhi chi HTTP de ren he lei xing de wang luo lian jie zhi xing RDA he fu zhi cao zuo le , bao kuo : ju yu wang (LAN)、 guang yu wang (WAN) he Microsoft ActiveSync® lian jie 。
  RDA he fu zhi gong neng dou fei chang shi he wu xian chuan shu 。 ta men cai yong ya suo lai jian xiao chuan shu shu ju de da xiao , bing cai yong jia mi zai chuan shu qi jian bao hu min gan de yong hu shu ju 。
  zai lian jie dao SQL Server shi ,RDA he fu zhi gong neng dou zhi chi ji cheng Windows shen fen yan zheng he SQL Server shen fen yan zheng 。
  he bing fu zhi jian jie
  SQL Server Mobile fu zhi ji yu Microsoft SQL Server he bing fu zhi 。 ke yi shi yong Microsoft SQL Server 2000 shu ju ku huo Microsoft SQL Server 2005 shu ju ku lai shi xian he bing fu zhi 。
  he bing fu zhi fei chang shi he yi dong ying yong cheng xu , yin wei ta yuan xu fen bie zai bian xie shi she bei he fu wu qi shang zi xing geng xin shu ju 。 zhi hou ke yi dui gai she bei he fu wu qi shang de shu ju jin xing tong bu , yi jiang ke hu duan de geng gai fa song dao fu wu qi , huo cong fu wu qi jie shou xin de geng gai 。
  jin guan yu RDA xiang bi , he bing fu zhi xu yao zai fu wu qi shang jin xing geng duo de pei zhi he wei hu , dan shi shi yong he bing fu zhi que you xu duo you dian , bao kuo :
  ◆ fu zhi ti gong le nei zhi he zi ding yi de chong tu jie jue gong neng 。
  ◆ tong guo fu zhi ke yi tong shi dui duo ge biao zhong de shu ju jin xing tong bu 。
  ◆ fu zhi ti gong le feng fu de shu ju fu zhi xuan xiang , bao kuo :
  · xuan ze wen zhang lei xing bing jin xing shai xuan yi ti gao xing neng
  · biao shi fan wei guan li
  ◆Microsoft SQL Server bao kuo da liang gong ju , ke yong yu :
  · chuang jian he tong bu SQL Server Mobile ding yue
  · jian shi ding yue zhe de mei ci fa bu huo dong
  you guan he bing fu zhi gong neng gong zuo yuan li de yi ban xin xi , qing shen yue SQL Server Books Online zhong de “How Merge Replication Works”。 you guan SQL Server Mobile ding yue zhe de xiang guan fu zhi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “How Replication Works” he “Replication Architecture”。
  yuan cheng shu ju fang wen (RDA) jian jie
  yuan cheng shu ju fang wen (RDA) shi yi dong ying yong cheng xu neng gou fang wen yuan cheng SQL Server shu ju ku biao zhong de shu ju , bing jiang zhe xie shu ju cun chu zai ben di SQL Server Mobile shu ju ku biao zhong 。 sui hou , gai ying yong cheng xu jiu ke yi du qu he geng xin ben di SQL Server Mobile shu ju ku biao 。SQL Server Mobile ke yi xuan ze gen zong dui ben di biao suo zuo de suo you geng gai 。 zhi hou , ying yong cheng xu ke yi jiang ben di biao zhong geng gai guo de ji lu geng xin hui SQL Server biao 。
  zai SQL Server Mobile zhong , jiang shu ju cong SQL Server biao chuan bo zhi ben di SQL Server Mobile biao de guo cheng cheng wei “ la ” shu ju 。 jiang ben di SQL Server Mobile biao zhong suo zuo de geng gai chuan bo hui SQL Server biao de guo cheng cheng wei “ tui ” shu ju 。
  zai bu xu yao shi yong SQL Server Mobile he bing fu zhi de quan bu gong neng ( bao kuo chong tu jie jue ) shi , shi he shi yong RDA。
  jue ding zai SQL Mobile ying yong cheng xu zhong shi yong yuan cheng shu ju fang wen (RDA) gong neng huan shi fu zhi gong neng , qu jue yu yi dong ying yong cheng xu de yong tu 、 gong neng 、 gui mo he yao qiu 。 mei zhong lian jie shu ju jie jue fang an dou you ge zi de you que dian 。 zhe xie you que dian jiang zai sui hou ge jie zhong jia yi tao lun 。
  gong neng dui bi
  ben jie jian yao jie shao dui fu zhi yu yuan cheng shu ju fang wen (RDA) zhi jian de ke dui bi gong neng zhi chi de cha yi 。 ben jie de zhu yao mu de bing bu shi jie shao fu zhi huo RDA de mei xiang ke yong gong neng , er zhi shi ti gong ke dui bi de na xie gong neng de dui bi 。 li ru , you xu duo fu zhi gong neng mei you xiang ying de RDA gong neng , yin ci zhe xie jiu bu shi ben wen suo tan tao de nei rong 。
  fu wu qi qin hai
  SQL Server Mobile de da liang he bing fu zhi gong neng lai zi yu SQL Server de he bing fu zhi gong neng 。SQL Server Mobile tong guo ding yue SQL Server fa bu chan pin lai li yong zhe xie gong neng 。 tong guo zai fu wu qi shang chuang jian fa bu , ke yi jiang da liang de xi tong biao tian jia dao ji jiang fa bu de shu ju ku zhong , bing jiang “ wei yi biao shi fu ” xi tong lie tian jia dao ji jiang fa bu de mei ge yong hu biao zhong 。 zhe xie xi tong dui xiang jiang bei tian jia dao fu wu qi shu ju ku zhong , yong yu dui fu zhi jin xing guan li 。RDA bu xu yao dui fu wu qi shang de shu ju ku jin xing ren he geng gai 。 you yu RDA dui fu wu qi shang de jia gou mei you qin hai xing , yin ci RDA de gong neng you yi ding xian zhi , bu xiang fu zhi na yang gong neng qi bei , dan shi gai gong neng ke yong yu zai SQL Server yu SQL Server Mobile zhi jian chuan shu shu ju , er wu xu ren he fu wu qi duan pei zhi gong zuo 。 zai you xie qing kuang xia , nin ke neng wu quan bian geng hou duan xi tong zhong de jia gou 。 ru guo shi zhe zhong qing kuang ,RDA shi qian zai de lian jie xuan ze , ke yong yu zai SQL Server yu SQL Server Mobile zhi jian chuan shu shu ju geng gai 。 ru guo xu yao qiang da de fu zhi gong neng er qie wu fa bian geng hou duan shu ju ku jia gou , ze ke yi kao lv de ling yi ge xuan ze shi shi yong zhong jian ceng SQL Server zuo wei fu zhi fu wu qi , ran hou shi yong qi ta wu qin hai ji shu [ ru shu ju zhuan huan fu wu (DTS) he Web fu wu ] jiang shu ju chuan shu dao hou duan xi tong 。
  jian er yan zhi , fu zhi gong neng xu yao dui fu wu qi shu ju ku de jia gou jin xing yi xie xi wei de geng gai , dan tong guo zhe xie geng gai ke huo de yi zu fei chang qiang da de gong neng , er RDA bu xu yao dui fu wu qi shu ju ku jin xing ren he geng gai , dan ta bu shi gong neng qi bei de lian jie jie jue fang an 。
  shu ju he jia gou ding yi
  ru shang wen suo shu , nin xu yao tong guo zai fu wu qi shang chuang jian fa bu lai jin xing fu zhi zhun bei 。 yao fu zhi dao ding yue zhe de shu ju he jia gou jiang zai fu wu qi shang chuang jian fa bu shi zhi ding 。 shou ci chuang jian ding yue shi , jiang zai ke hu duan zi dong ding yi jia gou 。 fa bu ding yi le yao fu zhi dao ding yue zhe de biao ( wen zhang ), bao kuo xing shai xuan ( shi yong WHERE zi ju xian zhi shu ju liu ) he lie shai xuan ( xian zhi biao zhong yao fu zhi de lie )。 fa bu ke yi bao han yi ge huo duo ge biao 。 zai SQL Server Mobile shu ju ku zhong , zheng ge fa bu ding yi ( bao kuo zheng zai fu zhi de biao de shu ju he jia gou ) shi shi yong yi zhong tong bu fang fa chuang jian de 。
  shi yong RDA shi , ke hu duan kong zhi cong fu wu qi zhong chuan shu na xie shu ju , bao kuo shu ju ding yi ( bao kuo xing shai xuan ) he jia gou ding yi ( bao kuo lie shai xuan )。RDA zai mei ge RDA la jin cheng zhong zhi neng dui yi ge biao jin xing tong bu , zhe yu fu zhi you suo bu tong , hou zhe ke yi zai yi ci tong bu cao zuo zhong chu li duo ge biao 。
  jian er yan zhi , zui chu zai SQL Server Mobile shu ju ku zhong chuang jian de shu ju he jia gou zai fu wu qi shang shi shi yong fu zhi gong neng jin xing ding yi de , er zai ke hu duan shang shi shi yong RDA jin xing ding yi de 。 fu zhi fa bu ke yi bao han duo ge biao , er RDA mei ci xia zai (RDA la jin cheng ) zhi neng chu li yi ge biao 。
  jia gou geng gai
  shi yong fu zhi gong neng shi , zai zui chu chuang jian ding yue hou ke yi jiang jia gou geng gai ( ru tian jia huo shan chu lie , tian jia huo shan chu yue shu , yi ji geng gai lie ding yi ) fu zhi dao ding yue zhe 。 dang xu yao jiang gua qi de jia gou geng gai fu zhi dao ding yue zhe shi , jiang shou xian fu zhi jia gou geng gai , ran hou zai fa bu zhe yu ding yue zhe zhi jian jiao huan suo dao zhi de zeng liang geng gai 。 fu wu qi jia gou geng gai ( li ru , tian jia lie huo shan chu ying yong cheng xu zhong wei zai shi yong de lie ) bu yi ding hui yao qiu dui ying yong cheng xu jin xing geng gai he chong xin bian yi 。 yuan xu dui ding yue shu ju ku de jia gou jin xing xi wei de geng gai 。 you guan xiang xi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “Replication Limitations”。
  shi yong RDA shi , bu zhi chi zai fu wu qi shang jin xing jia gou geng gai 。 ru guo jin xing le jia gou geng gai , cong ke hu duan dao fu wu qi de tui cao zuo ke neng hui shi bai 。 ru guo geng gai le fu wu qi jia gou , ze ke hu duan bi xu xian shan chu biao , ran hou zai ci cong fu wu qi la chu suo you shu ju 。 geng gai fu wu qi jia gou ke neng hui yao qiu dui ying yong cheng xu jin xing geng gai bing chong xin bian yi 。 yuan xu dui ke hu duan de jia gou jin xing xi wei de geng gai 。 you guan xiang xi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “Remote Data Access (RDA) Limitations”。
  jian er yan zhi , shi yong fu zhi gong neng shi , zhi chi fu wu qi jia gou geng gai , er qie fu wu qi jia gou geng gai bu hui dao zhi ding yue zhe shang de shu ju diu shi 。 dan shi , shi yong RDA shi , bu zhi chi fu wu qi jia gou geng gai , er qie fu wu qi jia gou geng gai ke neng hui dao zhi ke hu duan de shu ju diu shi 。 fu zhi he RDA gong neng yun yuan xu dui SQL Server Mobile lian jie biao jin xing xi wei de jia gou geng gai 。
  biao shi lie
  zai xu duo ying yong cheng xu zhong , nin ke neng xu yao shi yong di zeng de bian hao lai guan li zai ke hu duan shu ju ku zhong cha ru de ji lu 。 li ru , ru guo yong hu zheng zai biao zhong shu ru xin ding dan , ze nin ke neng xu yao wei mei ge ding dan fen pei zi dong di zeng de bian hao 。 shi yong zhe lei xi tong shi , bi xu que bao zhe xie bian hao zai ke hu duan zhi jian bu hui yin qi chong tu 。 dui yu fa bu he ding yue , fu zhi gong neng zhi chi integer he bigint lie de zi dong biao shi fan wei guan li 。 shi yong zi dong biao shi fan wei guan li , ke yi que bao wu lun you duo shao ke hu duan , dou bu hui fa sheng xing chong tu 。 you guan shi yong ci fu zhi gong neng de xiang xi xin xi , qing shen yue SQL Server Books Online zhong de “Replicating Identity Columns”。
  shi yong RDA shi , bu zhi chi biao shi lie de zi dong guan li 。 yao shi yong ci shu ju lei xing shu xing , bi xu zai zheng ge xi tong zhong shou dong guan li zhi 。
  yue shu he suo yin
  you yu fu zhi gong neng zhi chi zai fa bu ding yi zhong shi yong duo ge biao , yin ci yin yong wan zheng xing yue shu he suo yin hui zi dong cong fu wu qi fu zhi dao ding yue shu ju ku 。
  er you yu RDA mei ci zhi neng la yi ge biao , yin ci bu hui chuan shu yin yong wan zheng xing yue shu , dan shi ke yi chuan shu suo yin 。 qi ta jia gou ding yi bi xu zai ke hu duan jin xing ding yi 。
  jiao huan gen zong shu ju geng gai
  shi yong fu zhi gong neng shi , jiang fen bie zai fa bu shu ju ku he SQL Mobile shu ju ku zhong chuang jian xi tong dui xiang , qian zhe shi zai chuang jian fa bu shi jian li , er hou zhe ze shi zai chuang jian ding yue shi jian li de 。 zhe xie dui xiang yuan xu zai SQL Server yu SQL Server Mobile zhi jian shi yong fei chang qiang da de shu ju jiao huan mo xing 。 fu zhi gong neng ke yong yu gen zong fa bu he ding yue shu ju ku zhong de geng gai 。 fa bu zhe yu ding yue zhe zhi jian de shu ju liu kong zhi you liang zhong gen zong ji bie :
  ◆ biao de xing ji bie gen zong hui dao zhi zai tong bu qi jian chuan shu zheng ge xing 。 zhe zhong gen zong ji bie dui yi lai yu lian jie su du de shu ju chuan shu er yan ke neng dai jia jiao gao , dan xu yao zai fa bu zhe he ding yue zhe shang cun chu de gen zong xin xi jiao shao 。
  ◆ lie ji bie gen zong bu jin gen zong xing zhong de geng gai , er qie huan gen zong lie ji bie shang de geng gai , yin ci ke yi zhi jiang geng gai de lie shu ju cong ding yue zhe chuan shu dao fa bu zhe , cong er jian shao le chuan shu de shu ju liang 。 fa bu zhe shi zhong hui jiang zheng ge geng gai de xing fa song dao yu ding zhe , yuan yin shi ta bu neng que ding gai xing zai ding yue zhe zhong shi fou shi ji cun zai 。
  you guan gen zong ji bie de xiang xi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “Using Row-Level and Column-Level Tracking” he SQL Server Books Online zhong de “Row-Level Tracking and Column-Level Tracking”。
  RDA shi yong SQL Server Mobile shu ju ku zhong de xi tong dui xiang lai gen zong dui shu ju suo zuo de geng gai 。 huo de ci xin xi hou ,RDA jin jiang zhe xie geng gai ( te bie shi geng gai de xing ) cong SQL Server Mobile tui dao SQL Server。 dan ru guo SQL Server Mobile yao cong SQL Server jian suo shu ju geng gai , ze xu yao wan quan shua xin ke hu duan shu ju 。
  jian er yan zhi , fu zhi gong neng zhi chi zeng liang geng gai de shuang xiang shu ju jiao huan , yin wei shu ju geng gai shi zai fa bu zhe he ding yue zhe zhong tong shi jin xing gen zong de 。 er RDA jin zhi chi cong SQL Server Mobile dao SQL Server de zeng liang geng gai shu ju jiao huan , bing qie xu yao dui shu ju jin xing wan quan shua xin cai neng jiang SQL Server zhong de geng gai geng xin dao SQL Server Mobile, yin wei shu ju geng gai jin zai SQL Mobile shu ju ku zhong jin xing gen zong 。
  ke yi chuan bo de biao lei xing
  jiang biao tian jia dao fu zhi fa bu zhong shi , ke yi she zhi biao de shu xing lai kong zhi shu ju liu 。 chu le kong zhi fa bu zhe yu ding yue zhe zhi jian de shu ju liu yi wai , zhe xie biao shu xing huan ke yong yu zeng qiang tong bu de xing neng 。 you guan xiang xi xin xi , qing shen yue SQL Server Books Online zhong de “Parameterized Row Filters” he “Optimizing Merge Replication Synchronization Performance with Download-Only Articles”。
  RDA bu zhi chi ren he yong yu kong zhi shu ju liu huo zeng qiang xing neng de biao shu xing 。 la dao ke hu duan de shu ju jin you gai ke hu duan shang de ying yong cheng xu dai ma kong zhi 。
  chong tu
  shi yong fu zhi zuo wei lian jie jie jue fang an shi , qian zai de chong tu bao kuo you bu tong yong hu geng gai de shu ju yi ji you yu cuo wu er wu fa ying yong de xing 。 fu zhi wan quan zhi chi fu wu qi shang de chong tu jie jue he guan li , bao kuo nei zhi he zi ding yi de chong tu jie jue cheng xu 。 you guan xiang xi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “Replication Conflict Detection and Resolution” he SQL Server Books Online zhong de “Merge Replication Conflict Detection and Resolution”。
  shi yong RDA shi , chong tu jin bao kuo you yu cuo wu er wu fa ying yong de xing 。RDA bu hui jian ce shi fou you bu tong de yong hu dui shu ju jin xing le geng gai 。 yin ci ,RDA zai jiang shu ju tui ru fu wu qi shi shi zhong cai yong “ zui hou yi ge xie ru zhe huo sheng ” de fang shi 。 bu hui dui chong tu jin xing guan li , dan shi ke yi zai ke hu duan de cuo wu biao zhong bao gao chong tu 。 you yu mei you qu jie jue chong tu , yin ci ye jiu bu zhi chi ren he chong tu jie jue cheng xu 。
  gong ju (UI)
  SQL Server Management Studio bao han da liang yong yu chuang jian he guan li ding yue de gong ju ji , bao kuo yong yu guan li duo ge ding yue ji jian ce xing neng he tong bu ci shu de jian shi gong ju 。
  RDA zhi neng tong guo bian xie dai ma lai shi yong ;SQL Server he SQL Server Mobile zhong dou mei you ke yong yu tui / la geng gai huo jian shi ke hu duan de gong ju 。
  jie lun
  zai ben wen zhong , nin yi jing le jie le he bing fu zhi yu RDA zhi jian zhu yao gong neng de guan jian cha bie 。 le jie zhe xie xin xi hou , nin jiu ke yi gen ju SQL Server Mobile ying yong cheng xu de xu yao cheng gong di xuan ze xiang ying de lian jie jie jue fang an 。 li ru , ying yong cheng xu ke neng hui cong RDA de jian dan xing huo he bing fu zhi de qiang da gong neng zhong shou yi 。 zai you xie qing kuang xia , ru guo fu wu qi shang de shu ju bu hui fa sheng chong tu , nin ke yi xuan ze zai yi ge jie jue fang an zhong jie he shi yong RDA he he bing fu zhi de gong neng 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
yin yan Microsoft SQL Server 2005 Mobile Edition 3.0 (SQL Server Mobile) zhi chi liang zhong yu SQL Server shu ju ku jiao huan shu ju de fang fa : ◆ he bing fu zhi , ti gong yi zhong qiang da qie gong neng qi quan de jie jue fang an , gai jie jue fang an yuan xu yi dong ying yong cheng xu dui fu zhi de shu ju zi xing geng gai , ran hou zai jiang zhe xie geng gai yu Microsoft SQL Server shu ju ku jin xing he bing , bing zai bi yao shi jie jue chong tu 。 ◆ yuan cheng shu ju fang wen (RDA), shi yi dong ying yong cheng xu neng gou fang bian di jiang yuan cheng Microsoft SQL Server shu ju ku biao zhong de shu ju du qu ( la ) dao ben di SQL Server Mobile shu ju ku biao zhong , huo zhe jiang ben di SQL Server Mobile shu ju ku biao zhong de shu ju fa song ( tui ) dao yuan cheng Microsoft SQL Server shu ju ku biao zhong 。RDA huan ke yong yu zai yun xing SQL Server de fu wu qi shang fa chu SQL ming ling 。 jiang SQL Server Mobile lian jie dao SQL Server shi yong RDA huo fu zhi gong neng shi ,SQL Server Mobile jiang tong guo Microsoft Internet Information Services (IIS) fu wu qi lian jie dao SQL Server。 you yu yu SQL Server de lian jie you IIS chu li , yin ci nin de she bei zhi xu neng gou shi yong HTTP huo HTTPS xie yi lian jie dao IIS Web fu wu qi ji ke 。 zhe yang yi lai , nin jiu ke yi tong guo zhi chi HTTP de ren he lei xing de wang luo lian jie zhi xing RDA he fu zhi cao zuo le , bao kuo : ju yu wang (LAN)、 guang yu wang (WAN) he Microsoft ActiveSync® lian jie 。 RDA he fu zhi gong neng dou fei chang shi he wu xian chuan shu 。 ta men cai yong ya suo lai jian xiao chuan shu shu ju de da xiao , bing cai yong jia mi zai chuan shu qi jian bao hu min gan de yong hu shu ju 。 zai lian jie dao SQL Server shi ,RDA he fu zhi gong neng dou zhi chi ji cheng Windows shen fen yan zheng he SQL Server shen fen yan zheng 。 he bing fu zhi jian jie SQL Server Mobile fu zhi ji yu Microsoft SQL Server he bing fu zhi 。 ke yi shi yong Microsoft SQL Server 2000 shu ju ku huo Microsoft SQL Server 2005 shu ju ku lai shi xian he bing fu zhi 。 he bing fu zhi fei chang shi he yi dong ying yong cheng xu , yin wei ta yuan xu fen bie zai bian xie shi she bei he fu wu qi shang zi xing geng xin shu ju 。 zhi hou ke yi dui gai she bei he fu wu qi shang de shu ju jin xing tong bu , yi jiang ke hu duan de geng gai fa song dao fu wu qi , huo cong fu wu qi jie shou xin de geng gai 。 jin guan yu RDA xiang bi , he bing fu zhi xu yao zai fu wu qi shang jin xing geng duo de pei zhi he wei hu , dan shi shi yong he bing fu zhi que you xu duo you dian , bao kuo : ◆ fu zhi ti gong le nei zhi he zi ding yi de chong tu jie jue gong neng 。 ◆ tong guo fu zhi ke yi tong shi dui duo ge biao zhong de shu ju jin xing tong bu 。 ◆ fu zhi ti gong le feng fu de shu ju fu zhi xuan xiang , bao kuo : · xuan ze wen zhang lei xing bing jin xing shai xuan yi ti gao xing neng · biao shi fan wei guan li ◆Microsoft SQL Server bao kuo da liang gong ju , ke yong yu : · chuang jian he tong bu SQL Server Mobile ding yue · jian shi ding yue zhe de mei ci fa bu huo dong you guan he bing fu zhi gong neng gong zuo yuan li de yi ban xin xi , qing shen yue SQL Server Books Online zhong de “How Merge Replication Works”。 you guan SQL Server Mobile ding yue zhe de xiang guan fu zhi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “How Replication Works” he “Replication Architecture”。 yuan cheng shu ju fang wen (RDA) jian jie yuan cheng shu ju fang wen (RDA) shi yi dong ying yong cheng xu neng gou fang wen yuan cheng SQL Server shu ju ku biao zhong de shu ju , bing jiang zhe xie shu ju cun chu zai ben di SQL Server Mobile shu ju ku biao zhong 。 sui hou , gai ying yong cheng xu jiu ke yi du qu he geng xin ben di SQL Server Mobile shu ju ku biao 。SQL Server Mobile ke yi xuan ze gen zong dui ben di biao suo zuo de suo you geng gai 。 zhi hou , ying yong cheng xu ke yi jiang ben di biao zhong geng gai guo de ji lu geng xin hui SQL Server biao 。 zai SQL Server Mobile zhong , jiang shu ju cong SQL Server biao chuan bo zhi ben di SQL Server Mobile biao de guo cheng cheng wei “ la ” shu ju 。 jiang ben di SQL Server Mobile biao zhong suo zuo de geng gai chuan bo hui SQL Server biao de guo cheng cheng wei “ tui ” shu ju 。 zai bu xu yao shi yong SQL Server Mobile he bing fu zhi de quan bu gong neng ( bao kuo chong tu jie jue ) shi , shi he shi yong RDA。 jue ding zai SQL Mobile ying yong cheng xu zhong shi yong yuan cheng shu ju fang wen (RDA) gong neng huan shi fu zhi gong neng , qu jue yu yi dong ying yong cheng xu de yong tu 、 gong neng 、 gui mo he yao qiu 。 mei zhong lian jie shu ju jie jue fang an dou you ge zi de you que dian 。 zhe xie you que dian jiang zai sui hou ge jie zhong jia yi tao lun 。 gong neng dui bi ben jie jian yao jie shao dui fu zhi yu yuan cheng shu ju fang wen (RDA) zhi jian de ke dui bi gong neng zhi chi de cha yi 。 ben jie de zhu yao mu de bing bu shi jie shao fu zhi huo RDA de mei xiang ke yong gong neng , er zhi shi ti gong ke dui bi de na xie gong neng de dui bi 。 li ru , you xu duo fu zhi gong neng mei you xiang ying de RDA gong neng , yin ci zhe xie jiu bu shi ben wen suo tan tao de nei rong 。 fu wu qi qin hai SQL Server Mobile de da liang he bing fu zhi gong neng lai zi yu SQL Server de he bing fu zhi gong neng 。SQL Server Mobile tong guo ding yue SQL Server fa bu chan pin lai li yong zhe xie gong neng 。 tong guo zai fu wu qi shang chuang jian fa bu , ke yi jiang da liang de xi tong biao tian jia dao ji jiang fa bu de shu ju ku zhong , bing jiang “ wei yi biao shi fu ” xi tong lie tian jia dao ji jiang fa bu de mei ge yong hu biao zhong 。 zhe xie xi tong dui xiang jiang bei tian jia dao fu wu qi shu ju ku zhong , yong yu dui fu zhi jin xing guan li 。RDA bu xu yao dui fu wu qi shang de shu ju ku jin xing ren he geng gai 。 you yu RDA dui fu wu qi shang de jia gou mei you qin hai xing , yin ci RDA de gong neng you yi ding xian zhi , bu xiang fu zhi na yang gong neng qi bei , dan shi gai gong neng ke yong yu zai SQL Server yu SQL Server Mobile zhi jian chuan shu shu ju , er wu xu ren he fu wu qi duan pei zhi gong zuo 。 zai you xie qing kuang xia , nin ke neng wu quan bian geng hou duan xi tong zhong de jia gou 。 ru guo shi zhe zhong qing kuang ,RDA shi qian zai de lian jie xuan ze , ke yong yu zai SQL Server yu SQL Server Mobile zhi jian chuan shu shu ju geng gai 。 ru guo xu yao qiang da de fu zhi gong neng er qie wu fa bian geng hou duan shu ju ku jia gou , ze ke yi kao lv de ling yi ge xuan ze shi shi yong zhong jian ceng SQL Server zuo wei fu zhi fu wu qi , ran hou shi yong qi ta wu qin hai ji shu [ ru shu ju zhuan huan fu wu (DTS) he Web fu wu ] jiang shu ju chuan shu dao hou duan xi tong 。 jian er yan zhi , fu zhi gong neng xu yao dui fu wu qi shu ju ku de jia gou jin xing yi xie xi wei de geng gai , dan tong guo zhe xie geng gai ke huo de yi zu fei chang qiang da de gong neng , er RDA bu xu yao dui fu wu qi shu ju ku jin xing ren he geng gai , dan ta bu shi gong neng qi bei de lian jie jie jue fang an 。 shu ju he jia gou ding yi ru shang wen suo shu , nin xu yao tong guo zai fu wu qi shang chuang jian fa bu lai jin xing fu zhi zhun bei 。 yao fu zhi dao ding yue zhe de shu ju he jia gou jiang zai fu wu qi shang chuang jian fa bu shi zhi ding 。 shou ci chuang jian ding yue shi , jiang zai ke hu duan zi dong ding yi jia gou 。 fa bu ding yi le yao fu zhi dao ding yue zhe de biao ( wen zhang ), bao kuo xing shai xuan ( shi yong WHERE zi ju xian zhi shu ju liu ) he lie shai xuan ( xian zhi biao zhong yao fu zhi de lie )。 fa bu ke yi bao han yi ge huo duo ge biao 。 zai SQL Server Mobile shu ju ku zhong , zheng ge fa bu ding yi ( bao kuo zheng zai fu zhi de biao de shu ju he jia gou ) shi shi yong yi zhong tong bu fang fa chuang jian de 。 shi yong RDA shi , ke hu duan kong zhi cong fu wu qi zhong chuan shu na xie shu ju , bao kuo shu ju ding yi ( bao kuo xing shai xuan ) he jia gou ding yi ( bao kuo lie shai xuan )。RDA zai mei ge RDA la jin cheng zhong zhi neng dui yi ge biao jin xing tong bu , zhe yu fu zhi you suo bu tong , hou zhe ke yi zai yi ci tong bu cao zuo zhong chu li duo ge biao 。 jian er yan zhi , zui chu zai SQL Server Mobile shu ju ku zhong chuang jian de shu ju he jia gou zai fu wu qi shang shi shi yong fu zhi gong neng jin xing ding yi de , er zai ke hu duan shang shi shi yong RDA jin xing ding yi de 。 fu zhi fa bu ke yi bao han duo ge biao , er RDA mei ci xia zai (RDA la jin cheng ) zhi neng chu li yi ge biao 。 jia gou geng gai shi yong fu zhi gong neng shi , zai zui chu chuang jian ding yue hou ke yi jiang jia gou geng gai ( ru tian jia huo shan chu lie , tian jia huo shan chu yue shu , yi ji geng gai lie ding yi ) fu zhi dao ding yue zhe 。 dang xu yao jiang gua qi de jia gou geng gai fu zhi dao ding yue zhe shi , jiang shou xian fu zhi jia gou geng gai , ran hou zai fa bu zhe yu ding yue zhe zhi jian jiao huan suo dao zhi de zeng liang geng gai 。 fu wu qi jia gou geng gai ( li ru , tian jia lie huo shan chu ying yong cheng xu zhong wei zai shi yong de lie ) bu yi ding hui yao qiu dui ying yong cheng xu jin xing geng gai he chong xin bian yi 。 yuan xu dui ding yue shu ju ku de jia gou jin xing xi wei de geng gai 。 you guan xiang xi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “Replication Limitations”。 shi yong RDA shi , bu zhi chi zai fu wu qi shang jin xing jia gou geng gai 。 ru guo jin xing le jia gou geng gai , cong ke hu duan dao fu wu qi de tui cao zuo ke neng hui shi bai 。 ru guo geng gai le fu wu qi jia gou , ze ke hu duan bi xu xian shan chu biao , ran hou zai ci cong fu wu qi la chu suo you shu ju 。 geng gai fu wu qi jia gou ke neng hui yao qiu dui ying yong cheng xu jin xing geng gai bing chong xin bian yi 。 yuan xu dui ke hu duan de jia gou jin xing xi wei de geng gai 。 you guan xiang xi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “Remote Data Access (RDA) Limitations”。 jian er yan zhi , shi yong fu zhi gong neng shi , zhi chi fu wu qi jia gou geng gai , er qie fu wu qi jia gou geng gai bu hui dao zhi ding yue zhe shang de shu ju diu shi 。 dan shi , shi yong RDA shi , bu zhi chi fu wu qi jia gou geng gai , er qie fu wu qi jia gou geng gai ke neng hui dao zhi ke hu duan de shu ju diu shi 。 fu zhi he RDA gong neng yun yuan xu dui SQL Server Mobile lian jie biao jin xing xi wei de jia gou geng gai 。 biao shi lie zai xu duo ying yong cheng xu zhong , nin ke neng xu yao shi yong di zeng de bian hao lai guan li zai ke hu duan shu ju ku zhong cha ru de ji lu 。 li ru , ru guo yong hu zheng zai biao zhong shu ru xin ding dan , ze nin ke neng xu yao wei mei ge ding dan fen pei zi dong di zeng de bian hao 。 shi yong zhe lei xi tong shi , bi xu que bao zhe xie bian hao zai ke hu duan zhi jian bu hui yin qi chong tu 。 dui yu fa bu he ding yue , fu zhi gong neng zhi chi integer he bigint lie de zi dong biao shi fan wei guan li 。 shi yong zi dong biao shi fan wei guan li , ke yi que bao wu lun you duo shao ke hu duan , dou bu hui fa sheng xing chong tu 。 you guan shi yong ci fu zhi gong neng de xiang xi xin xi , qing shen yue SQL Server Books Online zhong de “Replicating Identity Columns”。 shi yong RDA shi , bu zhi chi biao shi lie de zi dong guan li 。 yao shi yong ci shu ju lei xing shu xing , bi xu zai zheng ge xi tong zhong shou dong guan li zhi 。 yue shu he suo yin you yu fu zhi gong neng zhi chi zai fa bu ding yi zhong shi yong duo ge biao , yin ci yin yong wan zheng xing yue shu he suo yin hui zi dong cong fu wu qi fu zhi dao ding yue shu ju ku 。 er you yu RDA mei ci zhi neng la yi ge biao , yin ci bu hui chuan shu yin yong wan zheng xing yue shu , dan shi ke yi chuan shu suo yin 。 qi ta jia gou ding yi bi xu zai ke hu duan jin xing ding yi 。 jiao huan gen zong shu ju geng gai shi yong fu zhi gong neng shi , jiang fen bie zai fa bu shu ju ku he SQL Mobile shu ju ku zhong chuang jian xi tong dui xiang , qian zhe shi zai chuang jian fa bu shi jian li , er hou zhe ze shi zai chuang jian ding yue shi jian li de 。 zhe xie dui xiang yuan xu zai SQL Server yu SQL Server Mobile zhi jian shi yong fei chang qiang da de shu ju jiao huan mo xing 。 fu zhi gong neng ke yong yu gen zong fa bu he ding yue shu ju ku zhong de geng gai 。 fa bu zhe yu ding yue zhe zhi jian de shu ju liu kong zhi you liang zhong gen zong ji bie : ◆ biao de xing ji bie gen zong hui dao zhi zai tong bu qi jian chuan shu zheng ge xing 。 zhe zhong gen zong ji bie dui yi lai yu lian jie su du de shu ju chuan shu er yan ke neng dai jia jiao gao , dan xu yao zai fa bu zhe he ding yue zhe shang cun chu de gen zong xin xi jiao shao 。 ◆ lie ji bie gen zong bu jin gen zong xing zhong de geng gai , er qie huan gen zong lie ji bie shang de geng gai , yin ci ke yi zhi jiang geng gai de lie shu ju cong ding yue zhe chuan shu dao fa bu zhe , cong er jian shao le chuan shu de shu ju liang 。 fa bu zhe shi zhong hui jiang zheng ge geng gai de xing fa song dao yu ding zhe , yuan yin shi ta bu neng que ding gai xing zai ding yue zhe zhong shi fou shi ji cun zai 。 you guan gen zong ji bie de xiang xi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “Using Row-Level and Column-Level Tracking” he SQL Server Books Online zhong de “Row-Level Tracking and Column-Level Tracking”。 RDA shi yong SQL Server Mobile shu ju ku zhong de xi tong dui xiang lai gen zong dui shu ju suo zuo de geng gai 。 huo de ci xin xi hou ,RDA jin jiang zhe xie geng gai ( te bie shi geng gai de xing ) cong SQL Server Mobile tui dao SQL Server。 dan ru guo SQL Server Mobile yao cong SQL Server jian suo shu ju geng gai , ze xu yao wan quan shua xin ke hu duan shu ju 。 jian er yan zhi , fu zhi gong neng zhi chi zeng liang geng gai de shuang xiang shu ju jiao huan , yin wei shu ju geng gai shi zai fa bu zhe he ding yue zhe zhong tong shi jin xing gen zong de 。 er RDA jin zhi chi cong SQL Server Mobile dao SQL Server de zeng liang geng gai shu ju jiao huan , bing qie xu yao dui shu ju jin xing wan quan shua xin cai neng jiang SQL Server zhong de geng gai geng xin dao SQL Server Mobile, yin wei shu ju geng gai jin zai SQL Mobile shu ju ku zhong jin xing gen zong 。 ke yi chuan bo de biao lei xing jiang biao tian jia dao fu zhi fa bu zhong shi , ke yi she zhi biao de shu xing lai kong zhi shu ju liu 。 chu le kong zhi fa bu zhe yu ding yue zhe zhi jian de shu ju liu yi wai , zhe xie biao shu xing huan ke yong yu zeng qiang tong bu de xing neng 。 you guan xiang xi xin xi , qing shen yue SQL Server Books Online zhong de “Parameterized Row Filters” he “Optimizing Merge Replication Synchronization Performance with Download-Only Articles”。 RDA bu zhi chi ren he yong yu kong zhi shu ju liu huo zeng qiang xing neng de biao shu xing 。 la dao ke hu duan de shu ju jin you gai ke hu duan shang de ying yong cheng xu dai ma kong zhi 。 chong tu shi yong fu zhi zuo wei lian jie jie jue fang an shi , qian zai de chong tu bao kuo you bu tong yong hu geng gai de shu ju yi ji you yu cuo wu er wu fa ying yong de xing 。 fu zhi wan quan zhi chi fu wu qi shang de chong tu jie jue he guan li , bao kuo nei zhi he zi ding yi de chong tu jie jue cheng xu 。 you guan xiang xi xin xi , qing shen yue SQL Server Mobile Books Online zhong de “Replication Conflict Detection and Resolution” he SQL Server Books Online zhong de “Merge Replication Conflict Detection and Resolution”。 shi yong RDA shi , chong tu jin bao kuo you yu cuo wu er wu fa ying yong de xing 。RDA bu hui jian ce shi fou you bu tong de yong hu dui shu ju jin xing le geng gai 。 yin ci ,RDA zai jiang shu ju tui ru fu wu qi shi shi zhong cai yong “ zui hou yi ge xie ru zhe huo sheng ” de fang shi 。 bu hui dui chong tu jin xing guan li , dan shi ke yi zai ke hu duan de cuo wu biao zhong bao gao chong tu 。 you yu mei you qu jie jue chong tu , yin ci ye jiu bu zhi chi ren he chong tu jie jue cheng xu 。 gong ju (UI) SQL Server Management Studio bao han da liang yong yu chuang jian he guan li ding yue de gong ju ji , bao kuo yong yu guan li duo ge ding yue ji jian ce xing neng he tong bu ci shu de jian shi gong ju 。 RDA zhi neng tong guo bian xie dai ma lai shi yong ;SQL Server he SQL Server Mobile zhong dou mei you ke yong yu tui / la geng gai huo jian shi ke hu duan de gong ju 。 jie lun zai ben wen zhong , nin yi jing le jie le he bing fu zhi yu RDA zhi jian zhu yao gong neng de guan jian cha bie 。 le jie zhe xie xin xi hou , nin jiu ke yi gen ju SQL Server Mobile ying yong cheng xu de xu yao cheng gong di xuan ze xiang ying de lian jie jie jue fang an 。 li ru , ying yong cheng xu ke neng hui cong RDA de jian dan xing huo he bing fu zhi de qiang da gong neng zhong shou yi 。 zai you xie qing kuang xia , ru guo fu wu qi shang de shu ju bu hui fa sheng chong tu , nin ke yi xuan ze zai yi ge jie jue fang an zhong jie he shi yong RDA he he bing fu zhi de gong neng 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
越来越漂亮的楚楚(7)
越来越漂亮的楚楚(6)
越来越漂亮的楚楚(5)
越来越漂亮的楚楚(4)
共长一色
水中莲
峰林晚照
远离喧嚣——山村小景
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有