Can I use multiple API's to write to the same SQL Server database simultaneously?

Posted on 2008-11-06
Last Modified: 2010-03-19
I am a bookseller and I use an API to gather data on books (title, price, etc.) from, a division of EBay. Although EBay has given me permission to make 1.5 million requests per day, the API is only capable of processing 15-20,000 requests a day. I have talked to EBay tech support and they are telling me the call I am using is the only one available for my purposes and there really is no way to increase the speed. However, they did tell me I can run multiple instances of the same API providing my "database and hardware can support it". Right now the API will get data from one book at a time and write the data to a SQL Server database. My question is would I be able to run multiple intances and write to the same database simultaneously? If not, would I be able to write to multiple databases simultaneously and then combine the data later?
Question by:bpfsr
    LVL 142

    Accepted Solution

    > and write to the same database simultaneously?
    yes, that is perfectly possible.

    Author Comment

    Is there anything special I need to do or do I just run the API's? One of the reason I ask is because when if I start the API and I have SQL Server Management Studio open, the API won't run and I get an error message along the lines of "database is not available". That is what made me think maybe you can only have one "stream" open to a database at a time...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now