sql2005培训资料09.ppt

1、Module 9:SQL Server 2005 Replication第1页，共19页。OverviewOverview of Replication EnhancementsNew Types of ReplicationConfiguring Replication第2页，共19页。Lesson:Overview of Replication EnhancementsUser Interface EnhancementsReplication ManagementPerformance and ScalabilityReplication MonitorOther Enhancement

2、s第3页，共19页。User Interface 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 tim

3、e第4页，共19页。Replication ManagementInitializing a subscriberBackup and restoreCopying a databaseDynamic snapshotsResuming snapshot transfersReplicating DDL statementsAllowing anonymous subscriptions for all publications第5页，共19页。Performance and ScalabilityPrecomputed partitionsUpdates to unique keysTran

4、sactional parallelism independent agent option used by defaultDownload only articles to reduce change tracking metadataReduced contention on reporting subscribersUse snapshot isolation levelUse snapshots第6页，共19页。Replication MonitorIndependent from SQL Server Management StudioPassive monitoringDefine

5、 acceptable performance figuresMinimize monitoring impactMerge replicationArticle level statisticsUpload and download statisticsTransactional replication real-time monitoring with tracer tokens第7页，共19页。Other EnhancementsMerge replication concurrency enhancements guaranteed delivery of logical record

6、sProgramming changes release of RMOReplication of more types of objects.NET UDTsAssemblies第8页，共19页。Lesson:New Types of ReplicationHeterogeneous ReplicationPeer-to-Peer Transactional ReplicationHTTP Replication第9页，共19页。Heterogeneous ReplicationUse Oracle v8 and later databases as the publisher in a r

7、eplication systemSnapshot replication no impact on Oracle databaseTransactional replication Triggers and tracking tables added to Oracle database Log Reader Agent transfers changes to SQL Server Distributor and Distribution Agent transfers changes to subscribersPotential issues because of:Difference

8、s between SQL Server and Oracle Use of Oracle tools第10页，共19页。Log Reader AgentDistributionAgentNew YorkPeer-to-Peer Transactional ReplicationLog Reader AgentDistributionAgentSydneyLog Reader AgentDistributionAgentLondonLog Reader AgentDistributionAgentNew York第11页，共19页。HTTP ReplicationSubscriberFirew

9、allIISPublisherhttps:/Repl.AdventureWXML over HTTP/HTTPSBinary over TCP/IP第12页，共19页。Lesson:Configuring ReplicationHow to Configure Replication Using SQL Server Management StudioHow to Configure Replication Using RMO第13页，共19页。How to Configure Replication Using SQL Server Management StudioCreating a p

10、ublication New Publication WizardCreating a subscription New Subscription WizardSynchronizing a subscription第14页，共19页。Practice:Creating a Publication Using SQL Server Management StudioIn this practice,you will see how to:Start the New Publication WizardConfigure a publication第15页，共19页。How to Configu

11、re Replication Using RMOImports Microsoft.SqlServer.Management.CommonImports Microsoft.SqlServer.ReplicationDim subCon As ServerConnectionsubCon=New ServerConnection(MySubscriber)subCon.Connect()1342Reference the SMO and RMO librariesMicrosoft.SqlServer.ConnectionInfo Microsoft.SqlServer.Replication

12、 Import the SMO and RMO namespacesConnect to the replications server(s)Perform replication tasksCreate publicationsCreate subscriptions第16页，共19页。Practice:Creating a Subscription Using RMOIn this practice,you will see how to create a subscription using RMO第17页，共19页。Course Evaluation第18页，共19页。演讲完毕，谢谢观看！第19页，共19页。