need urgent help how to synchronize web & windows database. Please help
-
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. WTF Thanks.
al hajjaj
-
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. WTF Thanks.
al hajjaj
brine_fury wrote:
I want any reservation happen to my web or windows app will reflect to both databases(online & local) at the same time.
That's not possible. How the server database can communicate with your local one? Why don't your windows application connect to online database, pull all missing records and update the local database?
brine_fury wrote:
WTF
Navaneeth How to use google | Ask smart questions
-
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. WTF Thanks.
al hajjaj
You dont actually need two databases. Write a web service(data access layer) which talks to a single database. Use this web wervice in both web and windows to perform the actions.
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
-
You dont actually need two databases. Write a web service(data access layer) which talks to a single database. Use this web wervice in both web and windows to perform the actions.
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
Yup. I am agree with your view.
cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net
-
Yup. I am agree with your view.
cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net
-
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. WTF Thanks.
al hajjaj
Web service is an ultimate solution but if you think this way is not possible you can move just the reservations table on web service and you can synchronize other tables at a specific time. On this way you have enough time to convert all your database to web service. Good luck!