copy tables and contents of database
If this is not needed to perform on each and every day but sometimes, I suggest the following procedure: 


Open the source server in Management Studio. Right click the database. Choose "Tasks" and "Generate Scripts". In the wizard choose either "entire database" or "specific objects" (and choose your tables).
Click Next.
Click Advanced.
At the property "Check for existence" choose "TRUE".
At the property "Types of data to script" choose "SCHEMA AND DATA".
At the property "Script Drop and Create" choose "Script Drop and Create" (this (re-)creates the (all|selected) tables with the current structure).
Click OK.
Decide if you want a file created or just the script opened in a new window.
Click OK / OK.
Run the script in your destination server and you are done.