Backup - Restore, Import - Export, Separation - Addition; You can go up to another SQL Server database Copy on a machine to another, which is the most simpler.