There is a database named DB_PROD_20 in our production server. In that DB, there is a table with the following directory:
I need to extract that table with the schema and the data from the PROD server to DEV server. This is what I planned to do :
setting up a PS script to copy the backup file from Data warehouse
create a sql agent job to restore to DEV
create another job to execute a SP to clean up the data after the restore
Should I create an entire new DB or create a another table under a different database name per our requirement in our DEV server?