




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、Module 9: SQL Server 2005 ReplicationOverviewOverview of Replication EnhancementsNew Types of ReplicationConfiguring ReplicationLesson: Overview of Replication EnhancementsUser Interface EnhancementsReplication ManagementPerformance and ScalabilityReplication MonitorOther EnhancementsUser Interface
2、EnhancementsReplication wizards40% fewer pagesImproved default values and auto-detectionLess branchingNew Subscription WizardReplaces the Push Subscription Wizard and Pull Subscription WizardAllows you to define multiple subscriptions with different properties at the same timeReplication ManagementI
3、nitializing a subscriberBackup and restoreCopying a databaseDynamic snapshotsResuming snapshot transfersReplicating DDL statementsAllowing anonymous subscriptions for all publicationsPerformance and ScalabilityPrecomputed partitionsUpdates to unique keysTransactional parallelism independent agent op
4、tion used by defaultDownload only articles to reduce change tracking metadataReduced contention on reporting subscribersUse snapshot isolation levelUse snapshotsReplication MonitorIndependent from SQL Server Management StudioPassive monitoringDefine acceptable performance figuresMinimize monitoring
5、impactMerge replicationArticle level statisticsUpload and download statisticsTransactional replication real-time monitoring with tracer tokensOther EnhancementsMerge replication concurrency enhancements guaranteed delivery of logical recordsProgramming changes release of RMOReplication of more types
6、 of objects.NET UDTsAssembliesLesson: New Types of ReplicationHeterogeneous ReplicationPeer-to-Peer Transactional Replication ReplicationHeterogeneous ReplicationUse Oracle v8 and later databases as the publisher in a replication systemSnapshot replication no impact on Oracle databaseTransactional r
7、eplicationTriggers and tracking tables added to Oracle databaseLog Reader Agent transfers changes to SQL Server Distributor and Distribution Agent transfers changes to subscribersPotential issues because of:Differences between SQL Server and OracleUse of Oracle toolsLog Reader AgentDistributionAgent
8、New YorkPeer-to-Peer Transactional ReplicationLog Reader AgentDistributionAgentSydneyLog Reader AgentDistributionAgentLondonLog Reader AgentDistributionAgentNew York ReplicationSubscriberFirewallIISPublisherhttpsRepl.AdventureWorksXML over /HTTPSBinary over TCP/IPLesson: Configuring ReplicationHow t
9、o Configure Replication Using SQL Server Management StudioHow to Configure Replication Using RMOHow to Configure Replication Using SQL Server Management StudioCreating a publication New Publication WizardCreating a subscription New Subscription WizardSynchronizing a subscriptionPractice: Creating a
10、Publication Using SQL Server Management StudioIn this practice, you will see how to:Start the New Publication WizardConfigure a publicationHow to Configure Replication Using RMOImports Microsoft.SqlServer.ManagementmonImports Microsoft.SqlServer.ReplicationDim subCon As ServerConnectionsubCon = New ServerConnection(MySubscriber)subCon.Connect() 1342Reference the SMO and RMO librariesMicrosoft.SqlServer.ConnectionInfo Microsoft.SqlServer.Replication Import the SMO and RMO namespacesConnect to the replications server(s)Perform replication tas
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2025年办公人员试题答案及解析
- 2025年药店gsp系统培训试题及答案
- 2025年车辆装备保障专业测试题及答案
- 2025年中国古典音乐试题及答案
- 2025年金属学热处理中级工试题及答案
- 机械革命协议书
- 机车比赛协议书
- 村民与村协议书
- 林地征占协议书
- 果树互换协议书
- 中医康复试题及答案
- 2025年个人租赁房屋合同范本
- 2025届贵州省铜仁市高二物理第二学期期末调研试题含解析
- 全国五小行业管理办法
- 糖尿病的诊断指标
- 广州教科版小升初英语复习:五年级上册知识清单+练习(含解析)
- 2025年检验检测机构资质认定评审准则试题及答案
- 2025-2030中国旅拍行业需求量走势与未来经营管理建议报告
- 城管执法实务培训课件
- 氧疗的护理课件
- 医疗投诉质量管理培训
评论
0/150
提交评论