Автоматизированная система для работы поликлиники
Отчет по практике - Компьютеры, программирование
Другие отчеты по практике по предмету Компьютеры, программирование
»ючения главной базы данных репликации транзакций с обновляемыми подписками используем следующий скрипт:
- Включение базы данных репликации_replicationdboption
@dbname = Nkp_bd,
@optname = Npublish,
@value= Ntrue
-Добавим агента чтения журнала в базу данных.[kp_bd].sys.sp_addlogreader_agent
@job_login = null,
@job_password = null,
@publisher_security_mode = 1
-Добавим агента чтения очереди для указанного распространителя:[kp_bd].sys.sp_addqreader_agent
@job_login = null,
@job_password = null, @frompublisher = 1
- Добавление публикации транзакций[kp_bd]_addpublication
@publication = Npub1,
@description = NПубликациятранзакций с обновляемыми подписками базы данных "kp_bd" от издателя "REDWHITE-ПК\MSSQLSERVERSERJ1".,
@sync_method = Nconcurrent,
@retention = 0,
@allow_push = Ntrue,
@allow_pull = Ntrue,
@allow_anonymous = Ntrue, @enabled_for_internet = Nfalse,
@snapshot_in_defaultfolder = Ntrue, @compress_snapshot = Nfalse,
@ftp_port = 21,
@ftp_login = Nanonymous, @allow_subscription_copy = Nfalse,
@add_to_active_directory = Nfalse, @repl_freq = Ncontinuous,
@status = Nactive,
@independent_agent = Ntrue,
@immediate_sync = Ntrue,
@allow_sync_tran = Ntrue, @autogen_sync_procs = Ntrue,
@allow_queued_tran = Ntrue,
@allow_dts = Nfalse,
@conflict_policy = Npub wins,
@centralized_conflicts = Ntrue, @conflict_retention = 14,
@queue_type = Nsql,
@replicate_ddl = 1, @allow_initialize_from_backup = Nfalse,
@enabled_for_p2p = Nfalse, @enabled_for_het_sub = Nfalse
-Создатим агента моментальных снимков для публикации._addpublication_snapshot
@publication = Npub1,
@frequency_type = 1, @frequency_interval = 0,
@frequency_relative_interval = 0, @frequency_recurrence_factor = 0,
@frequency_subday = 0, @frequency_subday_interval = 0,
@active_start_time_of_day = 0, @active_end_time_of_day = 235959,
@active_start_date = 0,
@active_end_date = 0,
@job_login = null,
@job_password = null,
@publisher_security_mode = 1
-Добавим в список доступа публикации имя входа._grant_publication_access
@publication = Npub1,
@login = Nsa_grant_publication_access
@publication = Npub1,
@login = NNT AUTHORITY\система_grant_publication_access
@publication = Npub1,
@login = Nredwhite-ПК\redwhite_grant_publication_access
@publication = Npub1,
@login = NNT SERVICE\MSSQL$MSSQLSERVERSERJ1_grant_publication_access
@publication = Npub1,
@login = NNT SERVICE\SQLAgent$MSSQLSERVERSERJ1_grant_publication_access
@publication = Npub1,
@login = Ndistributor_admin
- Добавление транзакционных статей для всех таблиц[kp_bd]_addarticle
@publication = Npub1,
@article = Nврач,
@source_owner= Ndbo,
@source_object = Nврач,
@type = Nlogbased,
@description = N, @creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nnone, @destination_table = Nврач,
@destination_owner = Ndbo,
@status = 24, @vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboврач], @del_cmd = NVCALL [dbo].[sp_MSdel_dboврач],
@upd_cmd = NVCALL [dbo].[sp_MSupd_dboврач][kp_bd]_addarticle
@publication = Npub1,
@article = Nдень_недели, @source_owner = Ndbo,
@source_object = Nдень_недели,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop, @schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nauto,
@pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80,
@destination_table = Nдень_недели,
@destination_owner = Ndbo,
@status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboдень_недели], @del_cmd = NVCALL [dbo].[sp_MSdel_dboдень_недели], @upd_cmd = NVCALL [dbo].[sp_MSupd_dboдень_недели][kp_bd]_addarticle
@publication = Npub1,
@article = Nкабинет, @source_owner = Ndbo,
@source_object = Nкабинет,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop, @schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nnone,
@destination_table = Nкабинет,
@destination_owner = Ndbo, @status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboкабинет],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboкабинет], @upd_cmd = NVCALL [dbo].[sp_MSupd_dboкабинет][kp_bd]_addarticle
@publication = Npub1,
@article = Nлекарство, @source_owner = Ndbo,
@source_object = Nлекарство,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop, @schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nauto,
@pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80,
@destination_table = Nлекарство,
@destination_owner = Ndbo, @status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboлекарство],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboлекарство], @upd_cmd = NVCALL [dbo].[sp_MSupd_dboлекарство][kp_bd]_addarticle @publication = Npub1,
@article = Nличное_дело_врача, @source_owner = Ndbo, @source_object = Nличное_дело_врача,
@type = Nlogbased,
@description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption= Nauto,
@pub_identity_range = 10000,
@identity_range = 1000, @threshold = 80,
@destination_table = Nличное_дело_врача,
@destination_owner = Ndbo,
@status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboличное_дело_врача],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboличное_дело_врача],
@upd_cmd = NVCALL [dbo].[sp_MSupd_dboличное_дело_врача][kp_bd]_addarticle
@publication = Npub1,
@article = Nмодератор, @source_owner = Ndbo,
@source_object = Nмодератор,
@type = Nlogbased, @description = N,
@creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption =Nnone,
@destination_table = Nмодератор,
@destination_owner = Ndbo, @status = 24,
@vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboмодератор],
@del_cmd = NVCALL [dbo].[sp_MSdel_dboмодератор], @upd_cmd = NVCALL [dbo].[sp_MSupd_dboмодератор][kp_bd]_addarticle
@publication = Npub1,
@article = Nнаправление_на_анализ,
@source_owner = Ndbo, @source_object = Nнаправление_на_анализ,
@type = Nlogbased,
@description = N, @creation_script = N,
@pre_creation_cmd = Ndrop,
@schema_option = 0x0000000008035CDF,
@identityrangemanagementoption = Nauto, @pub_identity_range = 10000,
@identity_range = 1000,
@threshold = 80,
@destination_table = Nнаправление_на_анализ,
@destination_owner = Ndbo, @status = 24, @vertical_partition = Nfalse,
@ins_cmd = NCALL [dbo].[sp_MSins_dboнаправление_на_анализ],
<