Synchronizing different locations in sql server 2005

[i i i]

Thanks in advance I have to implement one project in which i have SQL SERVER 2005 database and i have total 4 locations which are having a very high speed internet connection. Now all of these locations wants real time information that if one transactions is done on one location then it will show or update the other location also that lets suppose that now we have stock of item A remaining 10. What i need to know is what is the best way to implement this through linked Server/ cubes or Xml etc while my front end application is using ODBC connection

[Adam Maras]

I believe what you're looking for is known as replication[^].

Adam Maras | Software Developer Microsoft Certified Professional Developer

[i i i]

Thanks for posting but what do you think i should do it using sql server replication

[Mycroft Holmes]

I suggest you hire a good consultant, replication is not for dummies, it is an area fraught with peril for the beginner. I have been using SQL Server since it was Sybase and I would not attempt this without a expert support. Replication is the way to go so start researching and testing (not on the production servers). I predict it will take you at least 2+ months to get a good handle on replication.

Never underestimate the power of human stupidity RAH

[i i i]

thanks for the post well man i am doing this for almost more then 7 years but still in search for better solution any how thanks for nice post

[Jerry Hammond]

softdev_sup wrote:

well man i am doing this for almost more then 7 years but still in search for better solution

:wtf:

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

[Ashfield]

softdev_sup wrote:

well man i am doing this for almost more then 7 years but still in search for better solution

Then that maybe suggests that replication is the best solution - after all, thats what it was designed to do, keep databases syncronised.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP