Someone did this with an SSIS script.

http://www.codeproject.com/Articles/679706/Weather-Scraper-to-Get-Weather

Bear in mind this was from 2013, so the API may have changed since then.

If I'm not mistaken, SQL Developer allows you to export the tables via CREATE and INSERT statements. I believe there's also a tool in there that can move data from...

Just out of curiosity, what was the end result? Did management stick with SQL Server or switch to Oracle?

The thing is the people that are most likely to switch are probably the ones that don't contribute as much to the revenue stream. Oracle is able to make lots...

I'm not asking you to break your license agreement. The only purpose of the unsupported message is that if you call Oracle on a problem, they won't offer support until...

Does the error prevent you from continuing? Searching for the error indicated that it was a Yes/No question, not something that would cause it to quit. Post a screenshot if...

TNSNames..... I feel bad for you. There are a couple things to try.

-Make sure tnsping works.

-The tnsnames.ora file needs to go in the network/admin folder. If it's in another location,...

What was set on the security settings for the linked server properties? Some have suggested enabling the "Be made using this security context" option and putting in the other server's...