Replication : Deleted Records Keep Reapearing

Im currently having problems with merge replication.

Example:

When a customer record is deleted from tbl_customers its removed from the table, then its reappears about 30s - 1min later?

Im presuming the other server is restoring the record though replication.

Any Insight in to this would be most appreciated.

DanielI've found the error but still not to sure why its occuring?

Heres the errors
------

"The row was deleted at 'ENTERPRISE.PMSPS' but could not be deleted at 'VOYAGER.PMSPS'. Invalid object name 'tbl_contacts'."

[Conflict Winner]
The error described above occurred when trying to delete this row. If you ignore this conflict, you should resolve it through other means. Consider logging the details of this conflict, then sending the log entry to your system administrator. The value of the unique ID in column 'rowguid' is '{D2604393-EBB4-4CF7-97BC-562C28B6BD1B}'.

[Conflict Loser]
This row has been deleted. If you choose to ignore the conflict, Microsoft SQL Server will try to reinsert the deleted row, using data from the other server.

I have the option to Keep winning change which will just put the record back in or I can Resubmit the DELETE which just comes back with the same error.

:(

Replication

Dudes,
I have this customer who is interested to replicate a SQL Server 2005
database to a MySQL database, online... For example, you insert a record to
the SQL Server and it automatically inserts it on the MySQL database. Both
has the same schema. They are on a LAN or VPN.
I just need an idea on how you would solve this...
Cheers!
Officially this is not supported on SQL 2005. You can try to add an ole-db
provider to MySQL and create it as a subscriber that way.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Christian Strevel (Intellekt)" <cs@.prodigy.net.mx> wrote in message
news:u9UrgXw7GHA.1012@.TK2MSFTNGP05.phx.gbl...
> Dudes,
> I have this customer who is interested to replicate a SQL Server 2005
> database to a MySQL database, online... For example, you insert a record
> to the SQL Server and it automatically inserts it on the MySQL database.
> Both has the same schema. They are on a LAN or VPN.
> I just need an idea on how you would solve this...
> Cheers!
>

Replication

I have a customer who has Access databases at local sites who wants the data
replicated nightly to MS-SQL Server using broadband connection. I have very
limited knowledge of best practices to accomplish this reliably.

Right now they are using some Java app that exports the Access data then
emails the files as CSV. The emails are then manually taken, copied then
imported. Very cumbersome process and VERY unreliable. There's gotaa be a
better way.

I want to recomend that they contract an expert to set this up but really
can't even say for certian what type of person they should look for at this
point.

Any ideas from a 40,000 foot perspective?

Thanks in advance.

- Ben"Ben" <Sorry@.TooManyViruses.com> wrote in message
news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> I have a customer who has Access databases at local sites who wants the
data
> replicated nightly to MS-SQL Server using broadband connection.

Clarification: They want data stored in Access at many sites replicated to a
centralized MS-SQL Database via broadband connections (Cable, DSL, etc.).

> I have very limited knowledge of best practices to accomplish this
reliably.
> Right now they are using some Java app that exports the Access data then
> emails the files as CSV. The emails are then manually taken, copied then
> imported. Very cumbersome process and VERY unreliable. There's gotaa be
a
> better way.
> I want to recomend that they contract an expert to set this up but really
> can't even say for certian what type of person they should look for at
this
> point.
> Any ideas from a 40,000 foot perspective?
> Thanks in advance.
> - Ben|||"Ben" <Sorry@.TooManyViruses.com> wrote in message
news:1Geic.14066$d7.8263@.twister.rdc-kc.rr.com...
> "Ben" <Sorry@.TooManyViruses.com> wrote in message
> news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> > I have a customer who has Access databases at local sites who wants the
> data
> > replicated nightly to MS-SQL Server using broadband connection.
> Clarification: They want data stored in Access at many sites replicated to
a
> centralized MS-SQL Database via broadband connections (Cable, DSL, etc.).
> > I have very limited knowledge of best practices to accomplish this
> reliably.
> > Right now they are using some Java app that exports the Access data then
> > emails the files as CSV. The emails are then manually taken, copied
then
> > imported. Very cumbersome process and VERY unreliable. There's gotaa
be
> a
> > better way.
> > I want to recomend that they contract an expert to set this up but
really
> > can't even say for certian what type of person they should look for at
> this
> > point.
> > Any ideas from a 40,000 foot perspective?
> > Thanks in advance.
> > - Ben

You might want to post in microsoft.public.sqlserver.replication for more
information, but I believe that Access is only supported as a subscriber
(receives data) not a publisher (sends data).

Alternatives would include setting up linked servers to the Access
databases, and pulling in the data with direct SELECT queries. Or use DTS to
create a generic data transfer package, which is parameterized based on the
Access DB location.

See "sp_addlinkedserver" and "Heterogeneous Subscribers" in Books Online for
more information.

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:4089b32d_2@.news.bluewin.ch...
> "Ben" <Sorry@.TooManyViruses.com> wrote in message
> news:1Geic.14066$d7.8263@.twister.rdc-kc.rr.com...
> > "Ben" <Sorry@.TooManyViruses.com> wrote in message
> > news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> > > I have a customer who has Access databases at local sites who wants
the
> > data
> > > replicated nightly to MS-SQL Server using broadband connection.
> > Clarification: They want data stored in Access at many sites replicated
to
> a
> > centralized MS-SQL Database via broadband connections (Cable, DSL,
etc.).
> > > I have very limited knowledge of best practices to accomplish this
> > reliably.
> > > > Right now they are using some Java app that exports the Access data
then
> > > emails the files as CSV. The emails are then manually taken, copied
> then
> > > imported. Very cumbersome process and VERY unreliable. There's gotaa
> be
> > a
> > > better way.
> > > > I want to recomend that they contract an expert to set this up but
> really
> > > can't even say for certian what type of person they should look for at
> > this
> > > point.
> > > > Any ideas from a 40,000 foot perspective?
> > > > Thanks in advance.
> > > > - Ben
> > > You might want to post in microsoft.public.sqlserver.replication for more
> information, but I believe that Access is only supported as a subscriber
> (receives data) not a publisher (sends data).
> Alternatives would include setting up linked servers to the Access
> databases, and pulling in the data with direct SELECT queries. Or use DTS
to
> create a generic data transfer package, which is parameterized based on
the
> Access DB location.
> See "sp_addlinkedserver" and "Heterogeneous Subscribers" in Books Online
for
> more information.
> Simon

Thanks for the leads.

Replication

I have a customer who has Access databases at local sites who wants the data
replicated nightly to MS-SQL Server using broadband connection. I have very
limited knowledge of best practices to accomplish this reliably.

Right now they are using some Java app that exports the Access data then
emails the files as CSV. The emails are then manually taken, copied then
imported. Very cumbersome process and VERY unreliable. There's gotaa be a
better way.

I want to recomend that they contract an expert to set this up but really
can't even say for certian what type of person they should look for at this
point.

Any ideas from a 40,000 foot perspective?

Thanks in advance.

- Ben"Ben" <Sorry@.TooManyViruses.com> wrote in message
news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> I have a customer who has Access databases at local sites who wants the
data
> replicated nightly to MS-SQL Server using broadband connection.

Clarification: They want data stored in Access at many sites replicated to a
centralized MS-SQL Database via broadband connections (Cable, DSL, etc.).

> I have very limited knowledge of best practices to accomplish this
reliably.
> Right now they are using some Java app that exports the Access data then
> emails the files as CSV. The emails are then manually taken, copied then
> imported. Very cumbersome process and VERY unreliable. There's gotaa be
a
> better way.
> I want to recomend that they contract an expert to set this up but really
> can't even say for certian what type of person they should look for at
this
> point.
> Any ideas from a 40,000 foot perspective?
> Thanks in advance.
> - Ben|||"Ben" <Sorry@.TooManyViruses.com> wrote in message
news:1Geic.14066$d7.8263@.twister.rdc-kc.rr.com...
> "Ben" <Sorry@.TooManyViruses.com> wrote in message
> news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> > I have a customer who has Access databases at local sites who wants the
> data
> > replicated nightly to MS-SQL Server using broadband connection.
> Clarification: They want data stored in Access at many sites replicated to
a
> centralized MS-SQL Database via broadband connections (Cable, DSL, etc.).
> > I have very limited knowledge of best practices to accomplish this
> reliably.
> > Right now they are using some Java app that exports the Access data then
> > emails the files as CSV. The emails are then manually taken, copied
then
> > imported. Very cumbersome process and VERY unreliable. There's gotaa
be
> a
> > better way.
> > I want to recomend that they contract an expert to set this up but
really
> > can't even say for certian what type of person they should look for at
> this
> > point.
> > Any ideas from a 40,000 foot perspective?
> > Thanks in advance.
> > - Ben

You might want to post in microsoft.public.sqlserver.replication for more
information, but I believe that Access is only supported as a subscriber
(receives data) not a publisher (sends data).

Alternatives would include setting up linked servers to the Access
databases, and pulling in the data with direct SELECT queries. Or use DTS to
create a generic data transfer package, which is parameterized based on the
Access DB location.

See "sp_addlinkedserver" and "Heterogeneous Subscribers" in Books Online for
more information.

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:4089b32d_2@.news.bluewin.ch...
> "Ben" <Sorry@.TooManyViruses.com> wrote in message
> news:1Geic.14066$d7.8263@.twister.rdc-kc.rr.com...
> > "Ben" <Sorry@.TooManyViruses.com> wrote in message
> > news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> > > I have a customer who has Access databases at local sites who wants
the
> > data
> > > replicated nightly to MS-SQL Server using broadband connection.
> > Clarification: They want data stored in Access at many sites replicated
to
> a
> > centralized MS-SQL Database via broadband connections (Cable, DSL,
etc.).
> > > I have very limited knowledge of best practices to accomplish this
> > reliably.
> > > > Right now they are using some Java app that exports the Access data
then
> > > emails the files as CSV. The emails are then manually taken, copied
> then
> > > imported. Very cumbersome process and VERY unreliable. There's gotaa
> be
> > a
> > > better way.
> > > > I want to recomend that they contract an expert to set this up but
> really
> > > can't even say for certian what type of person they should look for at
> > this
> > > point.
> > > > Any ideas from a 40,000 foot perspective?
> > > > Thanks in advance.
> > > > - Ben
> > > You might want to post in microsoft.public.sqlserver.replication for more
> information, but I believe that Access is only supported as a subscriber
> (receives data) not a publisher (sends data).
> Alternatives would include setting up linked servers to the Access
> databases, and pulling in the data with direct SELECT queries. Or use DTS
to
> create a generic data transfer package, which is parameterized based on
the
> Access DB location.
> See "sp_addlinkedserver" and "Heterogeneous Subscribers" in Books Online
for
> more information.
> Simon

Thanks for the leads.|||I have more than 7 years of Experience with Replication if you want I can
Help u out in this. Please email me nehapatel75@.yahoo.com