SQL Bulk Copy Timeout

Question

Afternoon

I am trying to copy data from Oracle DB to SQL DB, I have setup the script to connect to Oracle and retrieve the data but when I use the bul copy command I keep on getting timeout error, done alot searching and tried few suggestion but not works, here is my code what did I do wrong.

Thanks

$sqlconn = "server='SPO2018';database=SPFSQLData;trusted_connection=true";
$sqlbc = new-object system.data.sqlclient.Sqlbulkcopy($sqlconn);
$scon = New-Object System.Data.SqlClient.SqlConnection($sqlconn);
$sqlbc.DestinationTableName="dbo.SCHEMAOBJPR";
$cmd.Connection = $scon;
$cmd.CommandTimeout = 0;
$sqlbc.WriteToServer($dtbl);

Answer 1

Hi @Eddie Piater ,

You can refer to the PowerShell script in this link.
If it doesn't work, please try this way: https://learn.microsoft.com/en-us/sql/ssma/oracle/migrating-oracle-data-into-sql-server-oracletosql?view=sql-server-ver15

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.