Need Help in data Merging.

[nirmalsingh]

Hai all, i am using a windows application with sql server 2000, i am developing the same application in web also in which i am using sql server 2005.
now my question is.
when i save , modify or delete a data in web(sql server 2005) it should affect sql server 2000 also (simultaneously ) and vice versa. someone says something like replication is solution. but i dont have any idea about that. plz guide me to do this successfully.
thanx in advance
with cheers
Nirmal.

[debasisdas]

If all the transactions are through the application why not use two connection strings and apply the transactions on both the servers.

[ck9663]

Start from here

-- CK