How to get my local database intimated?
-
Hi, Can any one suggest me a way to get my local database intimated whenever there is an insert/update occurring in my Remote server. Regards, Jagadeesh
-
Hi, Can any one suggest me a way to get my local database intimated whenever there is an insert/update occurring in my Remote server. Regards, Jagadeesh
A little more detail please. What do you mean by "local database"? You have a central database which you want to replicate changes to satellite databases on your webserver?
only two letters away from being an asset
-
A little more detail please. What do you mean by "local database"? You have a central database which you want to replicate changes to satellite databases on your webserver?
only two letters away from being an asset
Hi, Thank you for replying. I want to give more details about my question. In my question “local database” means my SQL Server database in my desktop machine. I know my remote server can no way communicate with my local machine ;) Condition: Local DB must be updates soon after the remote server is updated. (Max. 5 mins. time) What I am planning to do: On Remote server: Whenever there is an insert in the database after inserting I will be writing the same insert statement in a text file. If there is another insert I want to simply append it to the text file. On My Windows Machine: I want to develop a windows application that will be accessing the text file every 3-5 minutes, Updates the local database in my machine and process it locally. Problem: Expecting 5-8 inserts in database per day my solution may not be the best choice. Plz let me know any other alternatives. Regards, Jagadeesh
-
Hi, Thank you for replying. I want to give more details about my question. In my question “local database” means my SQL Server database in my desktop machine. I know my remote server can no way communicate with my local machine ;) Condition: Local DB must be updates soon after the remote server is updated. (Max. 5 mins. time) What I am planning to do: On Remote server: Whenever there is an insert in the database after inserting I will be writing the same insert statement in a text file. If there is another insert I want to simply append it to the text file. On My Windows Machine: I want to develop a windows application that will be accessing the text file every 3-5 minutes, Updates the local database in my machine and process it locally. Problem: Expecting 5-8 inserts in database per day my solution may not be the best choice. Plz let me know any other alternatives. Regards, Jagadeesh
Merge replication Database mirroring SQL Notification Services SQL Service Broker MSMQ Writing to a file and polling it is the least desirable solution and very amateur.
only two letters away from being an asset