Moving large tables between environments

Hello readers! Couple of days ago I had to move large table (~43 mln rows) from production environment to a dev environment. Below is a table structure as follows: CREATE TABLE [mmm].[Music Band]( [BandID] [int] IDENTITY(1,1) NOT NULL, [BandTypeID] [tinyint] NOT NULL, [BandName] [nvarchar](255) NOT NULL, [IsAvailable] [bit] NOT NULL, [IsRemoved] [tinyint] NOT NULL, [CreatedDataSourceTypeID]…

0