Export from Oracle to SQLServer!

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?????

Comments

  • Got the second part . . . . .

    lprun -format=csv C:\MyPath\MyLinqFile.linq > MyData.csv
  • 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.
  • This is another example of when having multiple connections for a script could be really useful.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!