How to copy database from one server to another Microsoft SQL Server

> Open SQL server management studio

> Open the remote server

> Right Click on database and click on Task and click on Copy database.

>Enter source and destination server and database name.

> If it show error than 

Try below method

> Right click on database and click on task.

> Click on Generate script

and follow the below steps of URL

> After that run the command in window + run SQLCMD -d <database-name> -i filename.sql

reference:-https://www.stellarinfo.com/article/restore-sql-server-database-backup-to-older-version-of-sql-server.php

https://stackoverflow.com/questions/17918770/cannot-execute-script-insufficient-memory-to-continue-the-execution-of-the-prog

or if the script is not generating by generate script than you can use data only or schema only(type of data to script) or it is still not generating than it is encrypted.