Back with another quick tip to copy databases from one sql instance to another using dbatools one-line command script:
Copy-DbaDatabase -Source SQLSERVER01 -Destination SQLSERVER02 -Database STAGE_DB_Name -BackupRestore -SharedPath \\NetworkPath\SQLBackup\SQLSERVER01 -NewName PROD_DB_Name
-Source: Name of the source SQL server
-Destination: Name of the destination SQL server where you are going to restore the source DB
-BackupRestore: Will use a backup and restore methodology to copy over the database
-SharedPath: This network path should be accessible to both source and destination servers
-NewName: Use this if you want to restore the database with a different name from source
Database Blog 