I am working on a requirement to transfer almost 1 TB of data from a CSV file to SQL server. Which is the fastest way to do this? I am considering bulk copy and came across this link which actually has a power shell script for the same
Are there any other considerations which I am missing? The source DB is a PeopleSoft Oracle database.
Another option I considered was using the SSMA tool for Oracle, copy the entire schema to SQL Server and then query the required data from the database. Is this a better option? Please suggest