Syntax Error

Copy Azure SQL Database to SQL Server - Incorrect Syntax Error

Copying databases from PROD back to TEST/STAGE and then further back down to a developer box is a normal routine.  It helps in debugging issues found in Production, and is a healthy task to do from time to time regardless.

Microsoft Documentation team has done an absolute phenomenal job with their details on how to copy from Azure SQL to SQL Server or visa versa.