cloneing?

I have a merge replication that is really fouled up. I need to get things
back in order. Right now I have three offices working on the database
locally(no replication going on) At the end of the day I want to get all of
the new data back to the publisher so we can create a new snapshot. I was
told by the software vendor of the interface of the database to clone
without hostnames or supporting records. I am kinda at a loss as to what
that means. I see that I can export the data to another server and choose to
append the data, is that what he meant? Any help would be very much
appreciated.
Curt
I suggest you contact the vendor and ask him exactly what he means. Say you
did a search on BOL one clone, cloning and supporting records and came up
with no results.
If you do a reinitialization you will be prompted to upload the changes from
the subscribers before reinitializing. Perhaps this is what the vendor
meant.
I suggest before you even do this you go through the conflicts table(s)
using the conflict viewer and resolve any conflicts.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Curt Shaffer" <curt@.chilitech.net> wrote in message
news:ch4k8c01hif@.enews3.newsguy.com...
> I have a merge replication that is really fouled up. I need to get things
> back in order. Right now I have three offices working on the database
> locally(no replication going on) At the end of the day I want to get all
of
> the new data back to the publisher so we can create a new snapshot. I was
> told by the software vendor of the interface of the database to clone
> without hostnames or supporting records. I am kinda at a loss as to what
> that means. I see that I can export the data to another server and choose
to
> append the data, is that what he meant? Any help would be very much
> appreciated.
> Curt
>

Client/Server Connection

Hi ;

I m trying to create Merge Replication. I was able to create the
replication on the same machine, however my aim is to use client
machine and do all the neessary work on the client machine and then
synchronize to the server. Thus, I have installed client version of SQL
2000, I connected to the database server, the thing is when I go off
line I lose connection. Is there any way to create the subscription in
to the client machine as an off line user then synchronize it ?Or DO I
have create my shopshot on the client machine?
If someone can help me I would really appreciate

Regards
AsI think the problem is with how you are connecting to the server.
Instead of using the network name when you register the server, use
<local> or '.' Your subscription must be created on the server.

client side triggers?

in merge replication using sql server 2005 and sql server compact, is it possible to have triggers (or business logic) for any changes on the client side? how does a client app know an insert/update/delete has been made? also, if the article is set to download-only, can the client app also be nofied of any changes?

thanks,

bryan

Yes you can set your triggers to be FOR REPLICATION

That way they will fire when an insert,update or delete comes through replication.

Applications usually do not get notified of changes in the database by the database system. This would be possible using the CLR however normally it is the application that queries the database to see if changes have occured.

Martin

Client Agent Error: integrity violation

Hello:

I tried to do the merge replication between SQL 2000 database and the SQL mobile server on PDA with SQL server management studio from SQL 2005 and I have already successfully synchronized my PDA with one small SQL server database file. However when I tried to synchronized my PDA with another larger SQL server database file, I got the error on PDA as following: “The row operation cannot be reapplied due to an integrity violation. Check the publication filter. [Table = AuditCriterion, operation = Insert, RowGuid = {1ee9321d-f00d-410c-8d5b-08d4220d2627}]”. I have keep checking the size of sdf file during synchronization, I found after the size of the sdf file stop increasing for about 20 mintues, then I got the error above. Morever, AuditCriterion table have a foreign key with another table AuditElement and I have not used publication filter at this stage.

Please help thanks.

Eddie

If AuditCriterion has as a foreign key with AuditElement have you included both tables in the publication?

If the table is missing the insert will fail because SQL Server 2000 cannot find the required primary key.

Thanks

Nabila Lacey