By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,377 Members | 1,354 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,377 IT Pros & Developers. It's quick & easy.

Need Help in data Merging.

nirmalsingh
100+
P: 218
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.
May 8 '08 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
If all the transactions are through the application why not use two connection strings and apply the transactions on both the servers.
May 8 '08 #2

ck9663
Expert 2.5K+
P: 2,878
Start from here

-- CK
May 8 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.