sql2005培训资料09

Module9:SQLServer2005ReplicationOverviewOverviewofReplicationEnhancementsNewTypesofReplicationConfiguringReplicationLesson:OverviewofReplicationEnhancementsUserInterfaceEnhancementsReplicationManagementPerformanceandScalabilityReplicationMonitorOtherEnhancementsUserInterfaceEnhancementsReplicationwizards40%fewerpagesImproveddefaultvaluesandauto-detectionLessbranchingNewSubscriptionWizardReplacesthePushSubscriptionWizardandPullSubscriptionWizardAllowsyoutodefinemultiplesubscriptionswithdifferentpropertiesatthesametimeReplicationManagementInitializingasubscriberBackupandrestoreCopyingadatabaseDynamicsnapshotsResumingsnapshottransfersReplicatingDDLstatementsAllowinganonymoussubscriptionsforallpublicationsPerformanceandScalabilityPrecomputedpartitionsUpdatestouniquekeysTransactionalparallelism—independentagentoptionusedbydefaultDownloadonlyarticles—toreducechangetrackingmetadataReducedcontentiononreportingsubscribersUsesnapshotisolationlevelUsesnapshotsReplicationMonitorIndependentfromSQLServerManagementStudioPassivemonitoringDefineacceptableperformancefiguresMinimizemonitoringimpactMergereplicationArticlelevelstatisticsUploadanddownloadstatisticsTransactionalreplication—real-timemonitoringwithtracertokensOtherEnhancementsMergereplicationconcurrencyenhancements—guaranteeddeliveryoflogicalrecordsProgrammingchanges—releaseofRMOReplicationofmoretypesofobjects.NETUDTsAssembliesLesson:NewTypesofReplicationHeterogeneousReplicationPeer-to-PeerTransactionalReplicationHTTPReplicationHeterogeneousReplicationUseOraclev8andlaterdatabasesasthepublisherinareplicationsystemSnapshotreplication—noimpactonOracledatabaseTransactionalreplicationTriggersandtrackingtablesaddedtoOracledatabaseLogReaderAgenttransferschangestoSQLServerDistributorandDistributionAgenttransferschangestosubscribersPotentialissuesbecauseof:DifferencesbetweenSQLServerandOracleUseofOracletoolsLogReaderAgentDistributionAgentNewYorkPeer-to-PeerTransactionalReplicationLogReaderAgentDistributionAgentSydneyLogReaderAgentDistributionAgentLondonLogReaderAgentDistributionAgentNewYorkHTTPReplicationSubscriberFirewallIISPublisher:ConfiguringReplicationHowtoConfigureReplicationUsingSQLServerManagementStudioHowtoConfigureReplicationUsingRMOHowtoConfigureReplicationUsingSQLServerManagementStudioCreatingapublication—NewPublicationWizardCreatingasubscription—NewSubscriptionWizardSynchronizingasubscriptionPractice:CreatingaPublicationUsingSQLServerManagementStudioInthispractice,youwillseehowto:StarttheNewPublicationWizardConfigureapublicationHowtoConfigureReplicationUsingRMOImportsMicrosoft.SqlServer.Management.CommonImportsMicrosoft.SqlServer.ReplicationDimsubConAsServerConnectionsubCon=NewServerConnection(MySubscriber)subCon.Connect()1342ReferencetheSMOandRMOlibrariesMicrosoft.SqlServer.ConnectionInfoMicrosoft.SqlServer.ReplicationImporttheSMOandRMOnamespacesConnecttothereplicationsserver(s)PerformreplicationtasksCreatepublicationsCreatesubscriptionsPractice:CreatingaSubscriptionUsingRMOInthispractice,youwillseehowtocreateasubscriptionusingRMOCourseEvaluation