sql2005培训资料09.ppt

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 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 ManagementInitializing 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 option 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 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 of 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 replicationTriggers 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 AgentDistributionAgentNew YorkPeer-to-Peer Transactional ReplicationLog Reader AgentDistributionAgentSydneyLog Reader AgentDistributionAgentLondonLog Reader AgentDistributionAgentNew YorkHTTP ReplicationSubscriberFirewallIISPublisherhttps:/Repl.AdventureWXML over HTTP/HTTPSBinary over TCP/IPLesson:Configuring ReplicationHow 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:Creating 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=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