SQL Server - retrieve data from multiple web databases

Asked By jayanthi venkat on 31-Jan-12 09:50 PM
Hi friends, am doing my final yr project "record matching over query results from multiple web databases" with the front end .Net and with the back end SQL Server .  So i need to know, how to retrieve data from multiple web databases (eg. google, yahoo etc). Am waiting for your reply to do my project further.

Thank You!!!
Robbe Morris replied to jayanthi venkat on 31-Jan-12 10:03 PM
What is a web database?
Venkat K replied to jayanthi venkat on 31-Jan-12 10:03 PM

Yes, if you have two databases you will need two connection strings.

Your data access code (in any of the four data access models:  http://www.lhotka.net/cslanet/faq/DataFaq.ashx) will then open connections to both databases as necessary to get and update the data in your object model.

If you need transactional protection, you must use EnterpriseServices transactions, and that will use the DTC. If you have two databases, you must use distributed 2-phase transactions.

Amit Choudhary replied to jayanthi venkat on 31-Jan-12 11:03 PM
Accessing Yahoo or google DBs is not that easy , even they won't allow you to do so as you wish.
you must seek their approval and see in what form they are giving data to you , it might be a web-service they are giving to you so you can fetch your desired data.

Hope it will help you..
Suchit shah replied to jayanthi venkat on 01-Feb-12 12:02 AM
As you said you want to retrive the data from multiple webdatabase like google,yahoo that want be possible. say example you have one application and you have hosted and then after someone else want to access your database then would you allowed..

Anyone else application database access that want be possible but if you want to use their feature like to implement google map, import gmail,yahoo mail contact then you can use their API to implement it

otherwise access on other database not possible
kalpana aparnathi replied to jayanthi venkat on 01-Feb-12 03:40 AM
hi,

Try this

select * from a.dbo.master

union all

select * from b.dbo.master