sql2005培训资料09.ppt

《sql2005培训资料09.ppt》由会员分享，可在线阅读，更多相关《sql2005培训资料09.ppt（18页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

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 En

2、hancementsReplication 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 ManagementInit

3、ializing 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 optio

4、n 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 imp

5、actMerge 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 of

6、 objects.NET UDTsAssembliesLesson:New Types of ReplicationHeterogeneous ReplicationPeer-to-Peer Transactional ReplicationHTTP 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 YorkHTTP ReplicationSubscriberFirewallIISPublisherhttps:/Repl.AdventureWXML over HTTP/HTTPSBinary over TCP/IPLesson:Configuring Replication

9、How to 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:Creatin

10、g a 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.Management.CommonImports Microsoft.SqlServer.ReplicationDim subCon As ServerConnectionsubCon

11、=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 tasksCreate publicationsCreate subscriptionsPractice:Creating a Subscription Using RMOIn this practice,you will see how to create a subscription using RMOCourse Evaluation