989 lines
149 KiB
Transact-SQL
989 lines
149 KiB
Transact-SQL
-- Enabling the replication database
|
|
use master
|
|
exec sp_replicationdboption @dbname = N'SL2007', @optname = N'publish', @value = N'true'
|
|
GO
|
|
|
|
-- Adding the snapshot publication
|
|
use [SL2007]
|
|
exec sp_addpublication @publication = N'sl2007', @description = N'Snapshot publication of database ''SL2007'' from Publisher ''sqlmi-bagspezlisteprd-sqlinstance.75ff9425ac13.database.windows.net''.', @sync_method = N'native', @retention = 0, @allow_push = N'true', @allow_pull = N'true', @allow_anonymous = N'false', @enabled_for_internet = N'false', @snapshot_in_defaultfolder = N'true', @compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous', @allow_subscription_copy = N'false', @add_to_active_directory = N'false', @repl_freq = N'snapshot', @status = N'active', @independent_agent = N'true', @immediate_sync = N'false', @allow_sync_tran = N'false', @autogen_sync_procs = N'false', @allow_queued_tran = N'false', @allow_dts = N'false', @replicate_ddl = 1
|
|
GO
|
|
|
|
|
|
exec sp_addpublication_snapshot @publication = N'sl2007', @frequency_type = 4, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, @frequency_subday = 1, @frequency_subday_interval = 1, @active_start_time_of_day = 213000, @active_end_time_of_day = 235959, @active_start_date = 0, @active_end_date = 0, @job_login = null, @job_password = null, @publisher_security_mode = 0, @publisher_login = N'sql-repl_agent', @publisher_password = null
|
|
exec sp_grant_publication_access @publication = N'sl2007', @login = N'sa'
|
|
GO
|
|
exec sp_grant_publication_access @publication = N'sl2007', @login = N'sql-repl_agent'
|
|
GO
|
|
exec sp_grant_publication_access @publication = N'sl2007', @login = N'Sec-SQL-RL_DBAOps'
|
|
GO
|
|
exec sp_grant_publication_access @publication = N'sl2007', @login = N'distributor_admin'
|
|
GO
|
|
exec sp_grant_publication_access @publication = N'sl2007', @login = N'superuser'
|
|
GO
|
|
|
|
-- Adding the snapshot articles
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'ATCDESCR', @source_owner = N'dbo', @source_object = N'ATCDESCR', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'ATCDESCR', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'CDATC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'CHARACTERISTIC_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'CHARACTERISTIC_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'CHARACTERISTIC_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'CHARACTERISTIC_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'CHARACTERISTIC_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'CHARACTERISTIC_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ATCDESCR', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'ATCDESCR', @view_name = N'syncobj_0x3442354642373135', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'COM_CHAIN', @source_owner = N'dbo', @source_object = N'COM_CHAIN', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'COM_CHAIN', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'Gamme', @source_owner = N'dbo', @source_object = N'Gamme', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'Gamme', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'GENERICBASEDATA_FROM_ARTIKEL_SUPERSET', @source_owner = N'dbo', @source_object = N'GENERICBASEDATA_FROM_ARTIKEL_SUPERSET', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'GENERICBASEDATA_FROM_ARTIKEL_SUPERSET', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'GENERICBASEDATA_FROM_ARTIKEL_SUPERSET_eme7w006', @source_owner = N'dbo', @source_object = N'GENERICBASEDATA_FROM_ARTIKEL_SUPERSET_eme7w006', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'GENERICBASEDATA_FROM_ARTIKEL_SUPERSET_eme7w006', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'IMSData', @source_owner = N'dbo', @source_object = N'IMSData', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'IMSData', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'IMSData_Add', @source_owner = N'dbo', @source_object = N'IMSData_Add', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'IMSData_Add', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'IMSData_Archiv', @source_owner = N'dbo', @source_object = N'IMSData_Archiv', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'IMSData_Archiv', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'IMSData_ExcelImport', @source_owner = N'dbo', @source_object = N'IMSData_ExcelImport', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'IMSData_ExcelImport', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'ITDESCR', @source_owner = N'dbo', @source_object = N'ITDESCR', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'ITDESCR', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'CDIT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'ITCOMMENT_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'ITCOMMENT_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'ITCOMMENT_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'UeberpruefungseinheitCode', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITDESCR', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'ITDESCR', @view_name = N'syncobj_0x3533433046324531', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'ITLIMIT', @source_owner = N'dbo', @source_object = N'ITLIMIT', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'ITLIMIT', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'CDITLIMITNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'CDIT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'LIMITNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'DATEVALID_FROM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'DATEVALID_THRU', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'ITLIMIT', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'ITLIMIT', @view_name = N'syncobj_0x3144383039433430', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'LIMITATION', @source_owner = N'dbo', @source_object = N'LIMITATION', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'LIMITATION', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'LIMITNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'LimitationChangeType_FK', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'CDLIMIT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'LIMITTYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'LIMITNIVEAU', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'LIMITVALUE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LIMITATION', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'LIMITATION', @view_name = N'syncobj_0x4243323946304234', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'LIMITATION_HISTORY', @source_owner = N'dbo', @source_object = N'LIMITATION_HISTORY', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'LIMITATION_HISTORY', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'LimitationChangeType', @source_owner = N'dbo', @source_object = N'LimitationChangeType', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'LimitationChangeType', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'LimitationChangeType_PK', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'Code', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'Sort', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'Descr_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'Descr_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'DbStatus', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'DbInsDatim', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'DbInsUser', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'DbUpdDatim', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'DbUpdUser', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'LimitationChangeType', @column = N'Time_Stamp', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'LimitationChangeType', @view_name = N'syncobj_0x3835443739354632', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'LOASPEZ', @source_owner = N'dbo', @source_object = N'LOASPEZ', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'LOASPEZ', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'NATION', @source_owner = N'dbo', @source_object = N'NATION', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'NATION', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'NATION', @column = N'CDNATION', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'NATION', @column = N'DESCR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'NATION', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'NATION', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'NATION', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'NATION', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'NATION', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'NATION', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'NATION', @view_name = N'syncobj_0x4642424439353143', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'ORG_GEN_UMSATZ', @source_owner = N'dbo', @source_object = N'ORG_GEN_UMSATZ', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'ORG_GEN_UMSATZ', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'OrgGenManualGrenzwert', @source_owner = N'dbo', @source_object = N'OrgGenManualGrenzwert', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'OrgGenManualGrenzwert', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'ORIGINAL_FREIKAUF', @source_owner = N'dbo', @source_object = N'ORIGINAL_FREIKAUF', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'ORIGINAL_FREIKAUF', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'OriginalGenericMapping', @source_owner = N'dbo', @source_object = N'OriginalGenericMapping', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'OriginalGenericMapping', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACK', @source_owner = N'dbo', @source_object = N'PACK', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PACK', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'VertriebsanteilGruppeId', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'PACKNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_DE_OLD', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_FR_OLD', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_IT_OLD', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'Descr_DE_Full', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'Descr_FR_Full', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'SWISSMEDIC_CAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'SWISSMEDICNR8', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'FLAGNARC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'FLAGMODAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'BAGDOSSIERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'LIFECYCLE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'GTIN', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'SIZEPACK', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'PREV_GTINCODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'SWISSMEDICNR8_PARALLELIMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACK', @view_name = N'syncobj_0x3443354346353932', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACK_IGNORE', @source_owner = N'dbo', @source_object = N'PACK_IGNORE', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PACK_IGNORE', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'SWISSMEDIC_CAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'SWISSMEDICNR8', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'FLAGNARC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'FLAGMODAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'BAGDOSSIERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'LIFECYCLE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_IGNORE', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACK_IGNORE', @view_name = N'syncobj_0x3444333441454230', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACK_LIMPTS', @source_owner = N'dbo', @source_object = N'PACK_LIMPTS', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PACK_LIMPTS', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'PACK_LIMPTSNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'LIMPOINTS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'LIMPACKS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'DATEVALID_FROM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'DATEVALID_THRU', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_LIMPTS', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACK_LIMPTS', @view_name = N'syncobj_0x3141343444364633', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACK_MUTATION', @source_owner = N'dbo', @source_object = N'PACK_MUTATION', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PACK_MUTATION', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'PACKNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'SWISSMEDIC_CAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'SWISSMEDICNR8', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'FLAGNARC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'FLAGMODAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'BAGDOSSIERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'LIFECYCLE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_MUTATION', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACK_MUTATION', @view_name = N'syncobj_0x3437444637373230', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACK_NEW', @source_owner = N'dbo', @source_object = N'PACK_NEW', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PACK_NEW', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'SWISSMEDIC_CAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'SWISSMEDICNR8', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'FLAGNARC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'FLAGMODAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'LIFECYCLE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACK_NEW', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACK_NEW', @view_name = N'syncobj_0x3338453542303934', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACKPARTNER', @source_owner = N'dbo', @source_object = N'PACKPARTNER', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PACKPARTNER', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'PACKPARTNERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'PARTNERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'PARTNERTYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACKPARTNER', @view_name = N'syncobj_0x3136344137444339', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @source_owner = N'dbo', @source_object = N'PACKPARTNER_IGNORE', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PACKPARTNER_IGNORE', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'PACKPARTNERIGNORENO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'PARTNERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACKPARTNER_IGNORE', @view_name = N'syncobj_0x4632313944344433', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @source_owner = N'dbo', @source_object = N'PACKPARTNER_MUTATION', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PACKPARTNER_MUTATION', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'PACKPARTNERMUTATIONNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'PARTNERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'PARTNERTYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACKPARTNER_MUTATION', @view_name = N'syncobj_0x3238453635323145', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PACKPRICE', @source_owner = N'dbo', @source_object = N'PACKPRICE', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PACKPRICE', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'PRICENO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'CDPRICETYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DATEVALID_FROM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'PRICE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DIVISION', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DIVPRICEINCVAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DIVISIONDESCR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'CDPRICECHANGETYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PACKPRICE', @column = N'PRICEMODEL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PACKPRICE', @view_name = N'syncobj_0x3936343139303733', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PARTNER', @source_owner = N'dbo', @source_object = N'PARTNER', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PARTNER', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'PARTNERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'PARTNERNRALT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'PARTNERNO_EMEDIAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'PT_NUMBER_ODB', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'DESCR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'NAME', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'ADDNAME', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'STREET', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'PLZ', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'PLACE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'CDNATION', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'KANTON', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'EAN', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'VATNR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'EMAIL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'INTERNET', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'CONTACT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'PHONE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'FAXNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PARTNER', @view_name = N'syncobj_0x3235443632334231', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PARTNER_IGNORE', @source_owner = N'dbo', @source_object = N'PARTNER_IGNORE', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PARTNER_IGNORE', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'PARTNERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'PARTNERNO_EMEDIAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'COMPANYNAME', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'ADDNAME', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_IGNORE', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PARTNER_IGNORE', @view_name = N'syncobj_0x4233433038344634', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PARTNER_MUTATION', @source_owner = N'dbo', @source_object = N'PARTNER_MUTATION', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PARTNER_MUTATION', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'PARTNERNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'PARTNERNO_EMEDIAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'COMPANYNAME_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'ADDNAME_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'COMPANYNAME', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'ADDNAME', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PARTNER_MUTATION', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PARTNER_MUTATION', @view_name = N'syncobj_0x3331334232364439', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PIMPORT', @source_owner = N'dbo', @source_object = N'PIMPORT', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PIMPORT', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PreiseNeu', @source_owner = N'dbo', @source_object = N'PreiseNeu', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PreiseNeu', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPARATION', @source_owner = N'dbo', @source_object = N'PREPARATION', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PREPARATION', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'PREPARNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'NAME_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'NAME_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'NAME_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'NAME_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'NAME_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'NAME_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'CDATC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'SWISSMEDICNR5', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'ITLIMVALID', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'CDORGGEN', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'FLAGSB20', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'CDNATION', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'COMMENT_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'COMMENT_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'COMMENT_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'PREPNAME', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'PREPNAMENO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'PREPNAMENO_BOOK', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'LOASPEZ', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'COM_FlagAPV', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'REVIEW_AFTER_PATENT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'PRICE_CUT_AFTER_MONTHS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION', @column = N'BWS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPARATION', @view_name = N'syncobj_0x4238383646453533', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @source_owner = N'dbo', @source_object = N'PREPARATION_IGNORE', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PREPARATION_IGNORE', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'NAME_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'NAME_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'NAME_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'NAME_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'NAME_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'NAME_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'CDATC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'SWISSMEDICNR5', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'ITLIMVALID', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'CDORGGEN', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'FLAGSB20', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'CDNATION', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'COMMENT_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'COMMENT_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'COMMENT_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @column = N'FLAGGGSL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPARATION_IGNORE', @view_name = N'syncobj_0x4331343344383234', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @source_owner = N'dbo', @source_object = N'PREPARATION_MUTATION', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PREPARATION_MUTATION', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'PREPARNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'NAME_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'NAME_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'NAME_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'CDATC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'SWISSMEDICNR5', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'ITLIMVALID', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'CDORGGEN', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'FLAGSB20', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'CDNATION', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @column = N'FLAGGGSL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPARATION_MUTATION', @view_name = N'syncobj_0x4343383131364338', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPARATION_NAME', @source_owner = N'dbo', @source_object = N'PREPARATION_NAME', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PREPARATION_NAME', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPARATION_NAME_BOOK', @source_owner = N'dbo', @source_object = N'PREPARATION_NAME_BOOK', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PREPARATION_NAME_BOOK', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPARATION_NEW', @source_owner = N'dbo', @source_object = N'PREPARATION_NEW', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PREPARATION_NEW', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'NAME_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'NAME_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'NAME_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'DESCR_DE_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'DESCR_FR_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'DESCR_IT_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'CDATC', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'SWISSMEDICNR5', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATION_NEW', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPARATION_NEW', @view_name = N'syncobj_0x4546434130373545', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPARATIONTASK', @source_owner = N'dbo', @source_object = N'PREPARATIONTASK', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PREPARATIONTASK', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'PREPARATIONTASKNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DESCR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'COMPLETED', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DUE_DATE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DUE_USERID', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DUE_GROUPNAME', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPARATIONTASK', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPARATIONTASK', @view_name = N'syncobj_0x3143333446383042', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PrepGenGroup', @source_owner = N'dbo', @source_object = N'PrepGenGroup', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PrepGenGroup', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPIT', @source_owner = N'dbo', @source_object = N'PREPIT', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PREPIT', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'PREPITNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'CDIT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPIT', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPIT', @view_name = N'syncobj_0x3343433138443844', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPPACKLIMIT', @source_owner = N'dbo', @source_object = N'PREPPACKLIMIT', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PREPPACKLIMIT', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'PREPLIMITNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'LIMITNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'DATEVALID_FROM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'DATEVALID_THRU', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'PM_LIST_INDICATIONS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPPACKLIMIT', @view_name = N'syncobj_0x3133464233424135', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @source_owner = N'dbo', @source_object = N'PREPPACKLIMIT_GGML', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PREPPACKLIMIT_GGML', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'PREPLIMITNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'LIMITNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'DATEVALID_FROM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'DATEVALID_THRU', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPPACKLIMIT_GGML', @view_name = N'syncobj_0x3446433146464146', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPPACKSTATUS', @source_owner = N'dbo', @source_object = N'PREPPACKSTATUS', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PREPPACKSTATUS', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'PREPPACKSTATUSNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'DATEINTEGRAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'DATEVALID_FROM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'DATEVALID_THRU', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'CDSTATUSTYPESL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'FLAGAPD', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPPACKSTATUS', @view_name = N'syncobj_0x3941344242303246', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @source_owner = N'dbo', @source_object = N'PREPPACKSTATUS_GGML', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PREPPACKSTATUS_GGML', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'PREPPACKSTATUSNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'PHARMACODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'DATEINTEGRAT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'DATEVALID_FROM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'DATEVALID_THRU', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'CDSTATUSTYPEGGML', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'FLAGAPD', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPPACKSTATUS_GGML', @view_name = N'syncobj_0x3337323730353843', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PREPSUB', @source_owner = N'dbo', @source_object = N'PREPSUB', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PREPSUB', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'PREPSUBNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'PRODUCT_COMMERCIAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'CH_NUMBER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'CDWHK', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'LNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'QUANTITY', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'QUANTITY_UNIT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PREPSUB', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PREPSUB', @view_name = N'syncobj_0x3035433130303231', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PRICECHANGETYPE', @source_owner = N'dbo', @source_object = N'PRICECHANGETYPE', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PRICECHANGETYPE', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'CDPRICECHANGETYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICECHANGETYPE', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PRICECHANGETYPE', @view_name = N'syncobj_0x4144383742434437', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PRICETYPE', @source_owner = N'dbo', @source_object = N'PRICETYPE', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PRICETYPE', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'CDPRICETYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PRICETYPE', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PRICETYPE', @view_name = N'syncobj_0x4634393535334545', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PUBLICATION', @source_owner = N'dbo', @source_object = N'PUBLICATION', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'PUBLICATION', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'PUBLICATIONNO', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'DATEVALID_FROM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'CDPUBLICATIONSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'BagBulletinFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'BagBulletinTextFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'ITCodesFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'GenericsFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'GenericListDiffSBFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'GeburtsGebrechenMedikamentListFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'PreparationsFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'PublicationsToExcelFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'DeletedPackagesFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'HistoryFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'GeburtsGebrechenSpezListFileName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION', @column = N'BagBulletinExcelName', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PUBLICATION', @view_name = N'syncobj_0x3237434132454245', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @source_owner = N'dbo', @source_object = N'PUBLICATION_STATUS', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PUBLICATION_STATUS', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @column = N'CDPUBLICATIONSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @column = N'DESCR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'PUBLICATION_STATUS', @view_name = N'syncobj_0x3639393646363832', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'PublicationRun', @source_owner = N'dbo', @source_object = N'PublicationRun', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'PublicationRun', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'RECIDKORR', @source_owner = N'dbo', @source_object = N'RECIDKORR', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'RECIDKORR', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'SL_AUFNSTRCH', @source_owner = N'dbo', @source_object = N'SL_AUFNSTRCH', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'SL_AUFNSTRCH', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @source_owner = N'dbo', @source_object = N'STATUSTYPE_GGML', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'STATUSTYPE_GGML', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @column = N'CDSTATUSTYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @column = N'DESCR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'STATUSTYPE_GGML', @view_name = N'syncobj_0x3642453637313930', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'STATUSTYPE_SL', @source_owner = N'dbo', @source_object = N'STATUSTYPE_SL', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'STATUSTYPE_SL', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'CDSTATUSTYPE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'DESCR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'STATUSTYPE_SL', @column = N'ACTIVE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'STATUSTYPE_SL', @view_name = N'syncobj_0x4530354230463542', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'SUBSTANCE', @source_owner = N'dbo', @source_object = N'SUBSTANCE', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'SUBSTANCE', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'SUBSTANCE', @column = N'CH_NUMBER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'SUBSTANCE', @column = N'DESCR_LA_ORIGINAL', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'SUBSTANCE', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'SUBSTANCE', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'SUBSTANCE', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'SUBSTANCE', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'SUBSTANCE', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'SUBSTANCE', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'SUBSTANCE', @view_name = N'syncobj_0x4536344132384239', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'TEMP_BIG_APV', @source_owner = N'dbo', @source_object = N'TEMP_BIG_APV', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'TEMP_BIG_APV', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'temp_Modal_Formstaerke', @source_owner = N'dbo', @source_object = N'temp_Modal_Formstaerke', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'temp_Modal_Formstaerke', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'TempAPV20131101', @source_owner = N'dbo', @source_object = N'TempAPV20131101', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'TempAPV20131101', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'TempImport', @source_owner = N'dbo', @source_object = N'TempImport', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'TempImport', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'TempUmsatz3J', @source_owner = N'dbo', @source_object = N'TempUmsatz3J', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'TempUmsatz3J', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'TempUmsatzGamme', @source_owner = N'dbo', @source_object = N'TempUmsatzGamme', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'TempUmsatzGamme', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'test_repl', @source_owner = N'dbo', @source_object = N'test_repl', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'test_repl', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'TMP_ArtikelVerknuepfungen', @source_owner = N'dbo', @source_object = N'TMP_ArtikelVerknuepfungen', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'TMP_ArtikelVerknuepfungen', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'TMP_VertriebsanteilGruppe', @source_owner = N'dbo', @source_object = N'TMP_VertriebsanteilGruppe', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'TMP_VertriebsanteilGruppe', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'Ueberpruefungseinheit', @source_owner = N'dbo', @source_object = N'Ueberpruefungseinheit', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'Ueberpruefungseinheit', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'VARIA', @source_owner = N'dbo', @source_object = N'VARIA', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'VARIA', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'true', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
|
|
-- Adding the article's partition column(s)
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'PHARMAGRUPPENCODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'IT_CODE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'DESCR_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'DESCR_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'DESCR_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'SIZEPACK_DE', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'SIZEPACK_FR', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'SIZEPACK_IT', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'PRICE_WITH_MWST_2.5', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'PRICE_WITH_MWST_2.6', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'PRICE_WITH_MWST_26_Correct', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'LIMITATION', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'TableNr', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'Sort', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'DBSTATUS', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'DBINSDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'DBINSUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'DBUPDDATIM', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'DBUPDUSER', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
exec sp_articlecolumn @publication = N'sl2007', @article = N'VARIA', @column = N'TIME_STAMP', @operation = N'add', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
|
|
-- Adding the article synchronization object
|
|
exec sp_articleview @publication = N'sl2007', @article = N'VARIA', @view_name = N'syncobj_0x4531363137364133', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'VERLIST', @source_owner = N'dbo', @source_object = N'VERLIST', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'none', @destination_table = N'VERLIST', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
use [SL2007]
|
|
exec sp_addarticle @publication = N'sl2007', @article = N'VertriebsanteilGruppe', @source_owner = N'dbo', @source_object = N'VertriebsanteilGruppe', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509D, @identityrangemanagementoption = N'manual', @destination_table = N'VertriebsanteilGruppe', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'SQL', @del_cmd = N'SQL', @upd_cmd = N'SQL'
|
|
GO
|
|
|
|
-- Adding the snapshot subscriptions
|
|
use [SL2007]
|
|
exec sp_addsubscription @publication = N'sl2007', @subscriber = N'SWMDATASQLPRD01', @destination_db = N'SL2007', @subscription_type = N'Pull', @sync_type = N'automatic', @article = N'all', @update_mode = N'read only', @subscriber_type = 0
|
|
GO
|
|
|