The method I used was as per below, which worked.
- Export Data-tier Application (Advanced -> Unchecked Large tables)
- Import Data-tier Application into destination server
- Used SQL Package to export the large tables individually.
- SqlPackage.exe /Action:Extract /SourceDatabaseName:DBNAME /SourceServerName:SOURCE_SERVER /SourceUser:USER /SourcePassword:PASSWORD /TargetFile:F:\TABLE_NAME.dacpac /p:IgnoreExtendedProperties=True /p:ExtractAllTableData=FALSE /p:TableData=TABLE_NAME
- Used SQL Package to import the large table into the destination server
- SqlPackage.exe /a:publish /p:DropIndexesNotInSource=False /p:IgnoreDefaultSchema=True /sf:F:\TABLE_NAME.dacpac /tcs:"Data Source=SourceServerName:DEST_SERVER ;Initial Catalog=DEST_DB;User ID=UN;Password=PASSWORD;"
This worked on a database of approximately 850GB.