There is one more thing to keep in consideration: total cost.

If i can implement Roy's solution, my customer is going to save about 5200 in SQL Server Licensing (that is,...

This sounds cool.

I will have to have to study WCF.

So you are telling me to write an agent, that connects to any table of the DB, and, when it is...

I can't do that.

I did for a program of mine, i designed the DB, and added to any table a timestamp field and a UID field: and I can keep...

Hi Roy,

thanks for your advice. But one thing i do not understand: how do i synchronize record deletion?

I can easily add a record to a DB where it is missing,...

Thanks to everybody

You are SO supportive, ans so quick ... 🙂

Thank you khrisna

Krishna (2/11/2009)

---

You really need more information on this:

The type of data and quantity of data to be replicated

and one thing that differs from most of them is does...

Thanks Jim, it sounds good to me.

Because as i was reading the MSDN documentation, they suggest a transational approach. But i felt that merge is what i need. And i...

Thank you Roy, i know i have a lot of work to do.

Roy Ernest (2/11/2009)

---

You really have lots of work to do on this. Your main issue is that you...

Thanks Perry.

I know the public DNS server has no knowledge of my LAN, actually, i wrote it, and i removed the note as i re-read, because my post was very...

Yes Paul, i believe it is a DNS issue.

I can ping my DNS server, but the LAN i used for my tests is not the target one.

I had to test...

I have found it.

The server name is not transalted to it's IP address.

If i replace in the connection string the server name with the IP (for instance, instead of MYSEVER\SQLEXPRESSm...