upload1000ToDB.php

<?php
$dbh = new \PDO('oci:dbname=' . "(DESCRIPTION =(ADDRESS = (PROTOCOL= TCP)(Host= host)(Port= port))(CONNECT_DATA = (SID = host)))" . ';charset=UTF8', $db_user, $db_psw);
$stmt = $dbh->prepare('Select * from user.tbl_api_beeline where PASSPORT is NOT NULL and ROWNUM <= 10000');
$stmt->execute();
$rows = $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

$data = array_chunk($rows, 1000);

/*echo "<pre>";
var_dump($data);
echo "</pre>";*/

$dsn = "sqlsrv:Server=server,port;Database=bd";
$conn = new PDO($dsn, "user", "pass");
$sql = "INSERT INTO [dlr001].[dbo].[tbl_api_beeline2](SECOND_NAME, FIRST_NAME ,MIDDLE_NAME, SUBS_KEY, PASSPORT, time_status)VALUES";

foreach ($data as $rows) {
    foreach ($rows as $row){
        $surname = $row['SECOUND_NAME'];
        $name = $row['FIRST_NAME'];
        $fathername = $row['MIDDLE_NAME'];
        $subsKey = $row['SUBS_KEY'];
        $passport = $row['PASSPORT'];
        $date = new DateTime("NOW");
        $datetime = $date->format('Y-m-d H:i:s.v');
        $sql2 = $sql2 . "('$surname','$name','$fathername','$subsKey','$passport', '$datetime'),";
    }
    $sql2 = substr($sql2, 0, -1);
    $sql_result = $sql . $sql2;
    $getResults_sql  = $conn->prepare($sql_result);
    $getResults_sql->execute();
    $sql2 = '';
    $sql_result ='';
}
?>