title: Azure SQL Server is it possible read from secondary node[readonly] and write to ReadWrite
body: <p>I have admin account,</p>
  <p>I need a query to run everyday.
  This query is heavy and cannot run on production server.
  &quot;selecting&quot; is takes 30 mins.
  So I need to use azure readonly secondary node.
  When It runs on secondary node It doesnt lock production server.</p>
  <p>after the select, output needs to be inserted to a table.
  Table is in prod but just stored for reports.
  This is not risky.</p>
  <p>I can do that in C# with 2 connection strings, but I want to do it in SQL server.
  Is it possible to select from [secondary node] and write to production server ?</p>