SQL Server bulk insert for large data set

  1. Check if your database in Full or Simple recovery mode:

    SELECT recovery_model_desc
    FROM sys.databases
    WHERE name="MyDataBase";

  2. If database is SIMPLE recovery mode you can create a staging table right there. If it is in Full mode then better create Staging table in separate database with Simple model.
  3. Use any BulkInsert operation/tool (for instance BCP, as already suggested)
  4. Insert only those data from your staging table, which do not exist in your target table. (hope you know how to do it)

Browse More Popular Posts

Leave a Comment