title: Copy table from Oracle DB to MS sql db
body: <p>I am trying to copy a table from an oracle database to a microsft sql database. I used this link as <a href="http://docs.oracle.com/cd/F49540_01/DOC/server.815/a66736/ch63.htm" rel="nofollow">my guide</a> and am using Visual Studio 2012. I keep getting <code>ORA-00900</code>: invalid SQL statement. 
  Any help will be appreciated.</p>
  
  <pre><code> void populateData()
      {
          OracleConnection conn = new OracleConnection(WebPhoneConnString());
          conn.Open();
                  OracleCommand command = new OracleCommand();
                  command.Connection = conn;
                  command.CommandText = "SqlBulkCopy from name/password@SID- to name/password@dataSource- replace ALL_WEB_PHONE_VIEW_N using SELECT * FROM ALLWEBPHN_N_MV";
  
                  DataTable DT = null;
                  OracleDataAdapter adap = new OracleDataAdapter(command);
                  adap.Fill(DT);
  
  
      }
  </code></pre>