Export from Oracle to SQLServer!

Aquatarkus · July 2017

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 · July 2017

Got the second part . . . . .

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

JoeAlbahari · July 2017

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 · July 2017

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

Export from Oracle to SQLServer!

Comments