Viewing 8 posts - 1 through 8 (of 8 total)
Someone did this with an SSIS script.
Bear in mind this was from 2013, so the API may have changed since then.
June 2, 2016 at 8:24 am
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...
May 25, 2016 at 9:17 am
Just out of curiosity, what was the end result? Did management stick with SQL Server or switch to Oracle?
February 5, 2015 at 6:16 pm
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...
January 26, 2015 at 11:51 am
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...
January 8, 2015 at 7:40 pm
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...
January 8, 2015 at 1:59 pm
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,...
December 20, 2014 at 9:30 am
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...
December 20, 2014 at 9:03 am