sql2005培訓(xùn)資料09ppt課件

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