Wednesday, March 28, 2012

Merge Replication with Interactive Resolver

1) Can you use the Default Interactive Resolver with SQL Express and Merge
Replication ?
2) Has anyone successfully done this?
My setup is Windows XP Laptop with SQL Express, Windows Server 2003 with SQL
Server 2005 Standard. I have setup Merge Replication between the two
computers where conflict resolution is automatic.
However, whenever I try to implement Interactive Resolution I get the
following message on the laptop:
"Microsoft SQL Server 2005 (SystemPortfolioystem
Portfolio(PublicHealth1\SQLEXPRESS)): The merge process failed to get
correct information about the Interactive Resolver component from the
registry. Verify that the registry exists and that the path is correct."
Thanks in Advance!
Jeremy
Worked in SQL 2000, broken in SQL 2005.
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
"Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
news:FCE3D3A5-C3F9-4954-9870-546330D29F43@.microsoft.com...
> 1) Can you use the Default Interactive Resolver with SQL Express and Merge
> Replication ?
> 2) Has anyone successfully done this?
> My setup is Windows XP Laptop with SQL Express, Windows Server 2003 with
> SQL
> Server 2005 Standard. I have setup Merge Replication between the two
> computers where conflict resolution is automatic.
> However, whenever I try to implement Interactive Resolution I get the
> following message on the laptop:
> "Microsoft SQL Server 2005 (SystemPortfolioystem
> Portfolio(PublicHealth1\SQLEXPRESS)): The merge process failed to get
> correct information about the Interactive Resolver component from the
> registry. Verify that the registry exists and that the path is correct."
> Thanks in Advance!
> Jeremy
>
|||Do you know if there are plans to fix it in a future version/service pack?
Thanks,
Jeremy
"Hilary Cotter" wrote:

> Worked in SQL 2000, broken in SQL 2005.
> --
> 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
> "Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
> news:FCE3D3A5-C3F9-4954-9870-546330D29F43@.microsoft.com...
>
>
|||I don't have a clue. I'll ping Microsoft on it. You might want to try to do
the same.
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
"Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
news:0615B2B3-12B9-421B-A747-029180B2D42D@.microsoft.com...[vbcol=seagreen]
> Do you know if there are plans to fix it in a future version/service pack?
> Thanks,
> Jeremy
> "Hilary Cotter" wrote:
|||Also, are they any workarounds for SQL 2005.
Thanks again,
Jeremy
"Hilary Cotter" wrote:

> Worked in SQL 2000, broken in SQL 2005.
> --
> 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
> "Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
> news:FCE3D3A5-C3F9-4954-9870-546330D29F43@.microsoft.com...
>
>
|||I'll put a bug in their ear. Also, I see you have written an entire book on
SQL Server Replication so while I have an expert to ask, are you using any
workarounds for interactive conflict resolution between SQL Express and SQL
Server 2005?
It seems like a huge feature to be missing.
Thanks for your feedback!!!
Jeremy
"Hilary Cotter" wrote:

> I don't have a clue. I'll ping Microsoft on it. You might want to try to do
> the same.
> --
> 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
> "Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
> news:0615B2B3-12B9-421B-A747-029180B2D42D@.microsoft.com...
>
>
|||I'm carrying on an email conversation with the replication PM right now.
I'll keep you posted.
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
"Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
news:554B8D85-3B44-4B4D-AB5D-CD25764741CC@.microsoft.com...[vbcol=seagreen]
> I'll put a bug in their ear. Also, I see you have written an entire book
> on
> SQL Server Replication so while I have an expert to ask, are you using any
> workarounds for interactive conflict resolution between SQL Express and
> SQL
> Server 2005?
> It seems like a huge feature to be missing.
> Thanks for your feedback!!!
> Jeremy
> "Hilary Cotter" wrote:
|||Thanks, that's fantastic as I don't have very much influence with Microsoft
but will notify them anyway I can that this feature no longer works in SQL
2005.
Thanks again,
Jeremy
"Hilary Cotter" wrote:

> I'm carrying on an email conversation with the replication PM right now.
> I'll keep you posted.
> --
> 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
> "Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
> news:554B8D85-3B44-4B4D-AB5D-CD25764741CC@.microsoft.com...
>
>
|||Hilary,
I have opened a case with the Microsoft SQL Integration Support department.
I forwarded detailed instructions to duplicate the error. I'll let you know
what I hear as well.
Thanks,
Jeremy
"Hilary Cotter" wrote:

> I'm carrying on an email conversation with the replication PM right now.
> I'll keep you posted.
> --
> 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
> "Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
> news:554B8D85-3B44-4B4D-AB5D-CD25764741CC@.microsoft.com...
>
>
|||The team on my end is look at it as well.
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
"Jeremy Scrime" <JeremyScrime@.discussions.microsoft.com> wrote in message
news:BBC0DA3D-6F50-4DD0-91A4-7F70EF4D8EE9@.microsoft.com...[vbcol=seagreen]
> Hilary,
> I have opened a case with the Microsoft SQL Integration Support
> department.
> I forwarded detailed instructions to duplicate the error. I'll let you
> know
> what I hear as well.
> Thanks,
> Jeremy
>
> "Hilary Cotter" wrote:

No comments:

Post a Comment