I am new to DBA role. I have requirement below. I have a database environment named SystemApp deployed on Development DB Server. In production server, the database with same name exists which is more updated with latest table definitions & other DB changes. I need to replicate all these changes to our development database. I am doing the following tasks in the order in which it is listed. Kindly look into whether I am doing the correct way. Please correct if I am doing wrong way or something more needs to be added to this list. Thanks.
First I will take the DB backup of the database SystemApp deployed on Development DB Server.
Take the scripts of DB & DB objects of the database SystemApp deployed on Production DB Server using Tasks >> Generate Scripts option.
DROP the database SystemApp deployed on Development DB Server.
Run the database scripts of Production DB in Development DB Server.
Will this work ? Kindly guide me on this.