Re: Merge replication in 2005... Version conflict?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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!
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Host Name Change and Replication
    ... the msdb.sysjobs did still contain PDB01 as the server originator and this caused the 14274 error about the MSX. ... I then added accountName user to the Security folder again, reenabled replication, and then made sure each agent was using the accountName and tested the replication. ... Unfortunately on DGP09 and TDB10 in their> subscription folder each had a push subscription pointing to PDB01 which no> longer exsists. ...
    (microsoft.public.sqlserver.server)
  • Re: Is this merge replica model possible?
    ... Download Only) to only the transactions which occurred on the publisher flow ... Looking for a SQL Server replication book? ... > A user subscribes and downloads subscription X. ... > Is this model a total variant from the normal Merge Replica model? ...
    (microsoft.public.sqlserver.replication)
  • Re: sync over the Internet
    ... Looking for a SQL Server replication book? ... how do I connect to Publisher? ... Once this is done they are ready to set up their subscription. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Compact Merge replication no longer works after VS SP1 is
    ... All i had done is installed the Server Tools 3.5 sp1 and re ran the ... subscription, ... case after installing VS 2008 SP1 the merge replication gives the following ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Compact Merge replication no longer works after VS SP1 is
    ... subscription, ... The merge process could not connect to the message file from Subscriber ... Check to ensure that the server is running. ... Initializing SQL Server Reconciler has failed. ...
    (microsoft.public.sqlserver.replication)