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

I am a bookseller and I use an API to gather data on books (title, price, etc.) from Half.com, 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 Half.com 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?
bpfsrAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
> and write to the same database simultaneously?
yes, that is perfectly possible.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bpfsrAuthor Commented:
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...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.