Export from Oracle to SQLServer!

Aquatarkus

I have a linq script that connects to an Oracle db and returns my data (using ordinary sql!). I then want to pump that data into a sql server staging table? All from the same script?

Alternatively, is it possible to double click my linq file so that it runs and exports the data to csv?????

Aquatarkus

Got the second part . . . . .

lprun -format=csv C:\MyPath\MyLinqFile.linq > MyData.csv

JoeAlbahari

There's no out-of-the-box solution for this.

You could do this:

string csv = Util.Run ("MyLinqFile.linq", QueryResultFormat.Csv).AsString();

and then parse the CSV with a library such as CsvHelper.

NetMage

This is another example of when having multiple connections for a script could be really useful.