Data from one database to another

[FGorilla]

Hi

Hopefully someone can advise as to the best way to do this. I am new to VB.NET so am trying to get to grips with the best method for doing things.

What I need to do is run a series of SQL queries on an Oracle database and then send the results of these to an SQL server database.

I have written a similar application in Access but am struggling to find the best solution when it comes to .NET.

I will try to explain in pseudo code:

1. Interrogate Oracle to retrieve parameters used in queries (inluding key ID)
2. Loop through table containing SQL queries to execute on Oracle database and replace parameters as required.
3. Execute each SQL statement in turn against Oracle and send results to SQL server with key ID to identify request.

Where I'm unsure of is do I read the result to a dataset before I send it to SQL server and how would I go about sending this dataset to SQL? Would I need to step through each row in each table and build an SQL statement on the fly?

Any help or pointers would be much appreciated. I'm sure it's probably been answered before but I couldn't find any posts on the subject.

Thanks
Chris

 

[FGorilla]

I have managed to find a solution which is what I've used. I was missing the little AcceptChangesDuringFill

Copying data from one database to another