Click here to Skip to main content
15,888,218 members
Home / Discussions / C#
   

C#

 
AnswerRe: User Authenticattion Pin
_Amy17-Jul-12 20:53
professional_Amy17-Jul-12 20:53 
AnswerRe: User Authenticattion Pin
Eddy Vluggen18-Jul-12 1:11
professionalEddy Vluggen18-Jul-12 1:11 
QuestionCreating Minidumps After Error Pin
Richard Andrew x6417-Jul-12 9:57
professionalRichard Andrew x6417-Jul-12 9:57 
AnswerRe: Creating Minidumps After Error Pin
Eddy Vluggen17-Jul-12 11:19
professionalEddy Vluggen17-Jul-12 11:19 
GeneralRe: Creating Minidumps After Error Pin
Richard Andrew x6417-Jul-12 12:29
professionalRichard Andrew x6417-Jul-12 12:29 
Questioninsert data from Oracle to MS SQL Pin
Ubun2OS17-Jul-12 5:57
Ubun2OS17-Jul-12 5:57 
AnswerRe: insert data from Oracle to MS SQL PinPopular
Pete O'Hanlon17-Jul-12 6:09
mvePete O'Hanlon17-Jul-12 6:09 
GeneralRe: insert data from Oracle to MS SQL Pin
PIEBALDconsult17-Jul-12 6:41
mvePIEBALDconsult17-Jul-12 6:41 
Of course. Currently I'm doing some of that with SSIS, but my personal preference is to use ADO.net.

0) Don't use the classes in System.Data.OracleClient[^]

1) If using ADO.net, use the classes in Oracle Data Provider for .NET[^]

2) If using SSIS, use the components in the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services[^] (Microsoft turned us onto this.)

3) I understand you could also link the servers and just use an INSERT/SELECT statement, but I haven't tried that.



Edit: I see you said SQL 2000, but I hope the above would work anyway.
GeneralRe: insert data from Oracle to MS SQL Pin
Pete O'Hanlon17-Jul-12 8:07
mvePete O'Hanlon17-Jul-12 8:07 
GeneralRe: insert data from Oracle to MS SQL Pin
PIEBALDconsult17-Jul-12 9:27
mvePIEBALDconsult17-Jul-12 9:27 
QuestionCreating subobjects within an object? Pin
Goalie3517-Jul-12 5:43
Goalie3517-Jul-12 5:43 
AnswerRe: Creating subobjects within an object? Pin
Luc Pattyn17-Jul-12 6:40
sitebuilderLuc Pattyn17-Jul-12 6:40 
GeneralRe: Creating subobjects within an object? Pin
BobJanova18-Jul-12 4:38
BobJanova18-Jul-12 4:38 
AnswerRe: Creating subobjects within an object? Pin
Luc Pattyn18-Jul-12 5:22
sitebuilderLuc Pattyn18-Jul-12 5:22 
AnswerRe: Creating subobjects within an object? Pin
TheGreatAndPowerfulOz9-Aug-12 4:26
TheGreatAndPowerfulOz9-Aug-12 4:26 
QuestionCompare Images "before and after" Pin
ToBick16-Jul-12 22:03
ToBick16-Jul-12 22:03 
AnswerRe: Compare Images "before and after" Pin
Eddy Vluggen16-Jul-12 23:13
professionalEddy Vluggen16-Jul-12 23:13 
GeneralRe: Compare Images "before and after" Pin
ToBick17-Jul-12 4:47
ToBick17-Jul-12 4:47 
GeneralRe: Compare Images "before and after" Pin
Eddy Vluggen17-Jul-12 4:53
professionalEddy Vluggen17-Jul-12 4:53 
GeneralRe: Compare Images "before and after" Pin
ToBick17-Jul-12 6:57
ToBick17-Jul-12 6:57 
AnswerRe: Compare Images "before and after" Pin
Eddy Vluggen17-Jul-12 7:52
professionalEddy Vluggen17-Jul-12 7:52 
GeneralRe: Compare Images "before and after" Pin
Pete O'Hanlon17-Jul-12 8:23
mvePete O'Hanlon17-Jul-12 8:23 
AnswerRe: Compare Images "before and after" Pin
Abhinav S16-Jul-12 23:15
Abhinav S16-Jul-12 23:15 
QuestionReturning Instance Issue - Object Reference Not Set Pin
AmbiguousName16-Jul-12 22:00
AmbiguousName16-Jul-12 22:00 
AnswerRe: Returning Instance Issue - Object Reference Not Set Pin
Pete O'Hanlon16-Jul-12 22:16
mvePete O'Hanlon16-Jul-12 22:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.