To import/export between Staging and Production server, use the SQL Server Import and Export Wizard Tool.

Use “SQL Server Native client 11.0”

Use query to import data to a temporary table and then insert into the destination table from the temporary table.

30 million records = 10 minutes to import data from source table to temp table, 40 minutes to import data from temp table to destination table.

Example Query

SELECT * FROM tbTable01 WITH (NOLOCK) WHERE biId >= 585222052 AND biId < 648296481
Last modified: June 7, 2021

Author

Comments

Write a Reply or Comment