August 23, 2011 at 4:36 am
Hi everyone,
I have a database named 'TileRWK' in USA . There is a server at China. The China people should retrieve the data from USA TileRWK database whenever required. Both databases are SQL SERVER 2008 R2 Enterprise Edition. Is there any possible way to retrieve the data when required from USA databases.
For example, a product is produced and send it to customers, when it came for servicing to China, they should retrieve the product details from USA server. Is there any mechanism to perform this task.. Or I should use some tools? What are the tools available?
Thanks In Advance
Sai Prabhu
August 23, 2011 at 6:33 am
I'm not sure I understand the question.
Are you saying that you want to transmit a record, or records, to the other server, but only when a certain action is taken on the first server? I would build that into the procedure that does the action on the first server. You could look at linked servers. Triggers are also a possibility, again through linked servers. You could have two calls from the application. You might look into an extended transaction manager such as BizTalk to put the data into both locations. In short, you have a lot of options. It's unclear to me which might be better based on the question.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply