Re: Merge replication in 2005... Version conflict?
- From: "Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 Jan 2006 11:30:40 -0600
Just change the database compatibility level within the database properties.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3B87E513-4C0E-4294-B45D-273485DDD94F@xxxxxxxxxxxxxxxx
> OK... So here's what I figured out.
>
> In Object Explorer, I see my subscription server as version 9.0.1399, but
> the publication server is still marked 8.0.194.
>
> How do I upgrade the publication server to 9.0.1399?
>
> Do I still need to drop the old merge replication? How do I go about that?
>
> Thanks for the help.... still new to this 2005 thing.
>
> "Hilary Cotter" wrote:
>
>> see this command? delete it,
>>
>> - it works then - publication_compatibility_level = N'80RTM',
>>
>> unless your subscriber really is SQL 2000 RTM. I would also advise you to
>> drop the existing subscription database and recreate it.
>>
>>
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:38EC9C88-370F-49D2-9257-D434E8BC6C30@xxxxxxxxxxxxxxxx
>> > They are both Running Windows 2000 server.
>> >
>> > Here is the script:
>> >
>> > -- Enabling the replication database
>> > use master
>> > exec sp_replicationdboption @dbname = N'twistpos', @optname = N'merge
>> > publish', @value = N'true'
>> > GO
>> >
>> > -- Adding the merge publication
>> > use [twistpos]
>> > exec sp_addmergepublication @publication = N'AccGC', @description =
>> > N'Merge
>> > publication of database ''twistpos'' from Publisher ''SERVER''.',
>> > @sync_mode
>> > = N'native', @retention = 14, @allow_push = N'true', @allow_pull =
>> > N'true',
>> > @allow_anonymous = N'true', @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', @centralized_conflicts =
>> > N'true', @dynamic_filters = N'false', @conflict_retention = 14,
>> > @keep_partition_changes = N'true', @allow_synctoalternate = N'false',
>> > @max_concurrent_merge = 0, @max_concurrent_dynamic_snapshots = 0
>> > GO
>> >
>> >
>> > exec sp_addpublication_snapshot @publication = N'AccGC',
>> > @frequency_type =
>> > 4, @frequency_interval = 14, @frequency_relative_interval = 1,
>> > @frequency_recurrence_factor = 0, @frequency_subday = 1,
>> > @frequency_subday_interval = 5, @active_start_time_of_day = 500,
>> > @active_end_time_of_day = 235959, @active_start_date = 0,
>> > @active_end_date
>> > =
>> > 0, @snapshot_job_name = N'SERVER-twistpos-AccGC-6'
>> > exec sp_grant_publication_access @publication = N'AccGC', @login =
>> > N'BUILTIN\Administrators'
>> > GO
>> > exec sp_grant_publication_access @publication = N'AccGC', @login =
>> > N'distributor_admin'
>> > GO
>> > exec sp_grant_publication_access @publication = N'AccGC', @login =
>> > N'DOMAIN\Administrator'
>> > GO
>> > exec sp_grant_publication_access @publication = N'AccGC', @login =
>> > N'sa'
>> > GO
>> >
>> > -- Adding the merge articles
>> > use [twistpos]
>> > exec sp_addmergearticle @publication = N'AccGC', @article =
>> > N'GiftCards',
>> > @source_owner = N'dbo', @source_object = N'GiftCards', @type =
>> > N'table',
>> > @description = N'', @creation_script = N'', @pre_creation_cmd =
>> > N'drop',
>> > @schema_option = 0x0000000000004FF1, @auto_identity_range = N'true',
>> > @pub_identity_range = 100000, @identity_range = 100000, @threshold =
>> > 90,
>> > @destination_owner = N'dbo', @column_tracking = N'false',
>> > @subset_filterclause = N'', @vertical_partition = N'false',
>> > @verify_resolver_signature = 1, @allow_interactive_resolver = N'false',
>> > @fast_multicol_updateproc = N'true', @check_permissions = 0
>> > GO
>> > use [twistpos]
>> > exec sp_addmergearticle @publication = N'AccGC', @article = N'Account',
>> > @source_owner = N'dbo', @source_object = N'Account', @type = N'table',
>> > @description = N'', @creation_script = N'', @pre_creation_cmd =
>> > N'drop',
>> > @schema_option = 0x0000000000006FF1, @auto_identity_range = N'false',
>> > @destination_owner = N'dbo', @column_tracking = N'false',
>> > @subset_filterclause = N'', @vertical_partition = N'false',
>> > @verify_resolver_signature = 1, @allow_interactive_resolver = N'false',
>> > @fast_multicol_updateproc = N'true', @check_permissions = 0
>> > GO
>> >
>> > "Hilary Cotter" wrote:
>> >
>> >> what are the respective OSs? Could you post your publication script
>> >> here?
>> >>
>> >> --
>> >> Hilary Cotter
>> >> Looking for a SQL Server replication book?
>> >> http://www.nwsu.com/0974973602.html
>> >>
>> >> Looking for a FAQ on Indexing Services/SQL FTS
>> >> http://www.indexserverfaq.com
>> >>
>> >> "Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:CA2A8A38-E07F-4C16-9C05-F58FA92D61F2@xxxxxxxxxxxxxxxx
>> >> >I recently Upgraded both of my servers to SQL Server 2005 Standard.
>> >> >
>> >> > Upon trying to set up Merge replication between the 2, I get this
>> >> > error:
>> >> >
>> >> > For merge publications, the version of the Subscriber must not
>> >> > exceed
>> >> > the
>> >> > version of the Publisher. (New Subscription Wizard)
>> >> >
>> >> > They both have 2005 installed and updated (9.00.1399.00)
>> >> > They both have the latest MDAC and .net versions
>> >> >
>> >> > What could be causing this error?
>> >> >
>> >> > Thanks!
>> >>
>> >>
>> >>
>>
>>
>>
.
- Follow-Ups:
- References:
- Re: Merge replication in 2005... Version conflict?
- From: Hilary Cotter
- Re: Merge replication in 2005... Version conflict?
- From: Ben
- Re: Merge replication in 2005... Version conflict?
- From: Hilary Cotter
- Re: Merge replication in 2005... Version conflict?
- From: Ben
- Re: Merge replication in 2005... Version conflict?
- Prev by Date: Slow synchs
- Next by Date: Re: Merge replication subscription error with proxy
- Previous by thread: Re: Merge replication in 2005... Version conflict?
- Next by thread: Re: Merge replication in 2005... Version conflict?
- Index(es):
Relevant Pages
|
