please help me,my project.........

[Ahmed Gaser]

Dear friends: My team has the following task to complete.A solution that consists of 3 projects : 1-Win app that connected to a local DB server(SQL server) . 1-Web app that connected to a remotre server(SQL server). 1-Mobile app for that connected to tha same remote server of the web app. The Details: 1-The win app deals with a DB(Local DB SQL server) for updating ,retriving,inserting and deleting. 2-The web & the mobile app deal with a DB(Remote DB SQL server) for tha same purpose.(updating ,retriving,inserting and deleting) The Goal: 1-The Win app will connect one time per day to update the Remote SQL server with the new data from the Local SQL server. 2-The Web and mobile app connected to the Remote SQL server will update ,retrieve ,delete and insert records in it. The Questions: 1-If I can use Asp.net web services ,How can I use it? 2-How can i make daily transaction to update the Remote SQL server with the new data at the Local SQL server?? 3-How can i make daily transaction to update the Local SQL server with the new data at Remote SQL server ?? 4-How can i manage the DB Transactions ? 5-how can i use the same methods(code) for dealing with the DB ,for the win app , the web app and the mobile app? 5-What is the best way to complete this solution? Thanks for reading to this line. I hope you can help me. thanks again. Best Regards Ahmed Gaser FCSIS IS Dept.