Ahhh yes! I believe I can install the Developer Edition so I can restore the backup and then I can use SSIS, Generate Scripts or some other transfer mechanism much...

The database is too large to restore to SQL Server 2016 Express Edition. The maximum database size is 10GB. I would need Enterprise or Standard.

Well, an SSIS may be possible but I feel like that might take a very long time being as though the DB is 175GB. After scripting and compressing, the file...

Thank you all for the quick replies.

Using SSIS would be great but the SQL Server Instances are not on the same network. The front end application is designed...