I need urgent help how to synchronize web & windows database. Please help!!!

[Yajjoj]

I have a task that i have to synchronize/update both my web(asp.net & SQL 2005) and windows application databases(VB.net & SQL 2005). My scenario is my web app. and windows app. both accept reservations. I want any reservation happen to my web or windows app will reflect to both databases(online & local) at the same time. Please help me. :omg: Thanks.

al hajjaj

[Steven J Jowett]

I would look at using SQL Server replication or if that is not possible, writing INSERT, UPDATE and DELETE triggers for each of the tables that need syncronising. Better still why not use the same database for both apps?

Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.

[Johan Hakkesteegt]

Like Steven said, best is to use a single database for both. In fact, it is useless to build a separate windows form. Just make a separate section in your web app with login for administrators / employees, and build the form there. Using xml could be an alternative approach. Handle web reservations as orders, and have your web app send the necessary information for the reservation in an xml file. Vice versa, you can send data about existing reservations / open capacity in xml files to your web server. Obviously this approach would not nearly be as real-time, so you would have to figure out a rule about how to handle double reservations. For example an approval queue.

My advice is free, and you may get what you paid for.

modified on Wednesday, June 10, 2009 6:32 AM

[Baran M]

Single database will do and write a webservice which handles database layer and business logic layer. Webservice can be called from web and windows applcation. So even if you change the presentation layer (web or windows) you can do that.:)

[Yajjoj]

:thumbsup::thumbsup:yes , it's the best idea :^) but i don't know where to start. :-O

al hajjaj