Copy Data between two databases
There are 2 good options that you can think of implementing based on your comfort level :


Incremental Loads - using SSIS


Pros:


You can schedule SSIS package as and when required.
You can do it for selected tables.
Depending on the frequency of data transfer, the data to be transferred would be less.

Cons:


Would require a bit of learning if you are new to SSIS.


Backup Restore (sample script .. change it as per your needs) :


Pros :


You get a copy of your database as per your schedule.

Cons:


Entire database has to be restored. Requires more disk space.




Your application should use 3 part (dbname.schema.tableName).

Also, make sure that Instant file initialization is enabled to cutdown the restore time.