We are trying to achieve the following but I'm unable to find any documentation:
We have a database with many 150+ tables where clients input data daily, if the devs run queries on the DB, the DB performance gets really bad and clients struggle to finish their job.
We would like to create another server where only dev will be accessing but the issue is to duplicate our current database (I believe with backup) and create a sort of script that will fill up the new database every time (or once per day) the data that is missing from the db that the clients are using.
Do you have any suggestion?
The source db is MS SQL 2018 r2 on server 2008, the destination will be brand new.
Thank you for your help