• SQL Server doesn't come with very good tools to do this....

    If the database(s) is not too large you could script out the DB structure (generate SQL script, including the create DB statements...under Options) and then make a backup of the source DB. Then, burn a copy of the resulting .bak file onto some media and then move to your destination....Restore the backup to the empty DB framework generated from your script.

     

     


    ciao ciao