I am wondering what are preferred methods to copy a new (Development) database into a new environment. The database will be empty, so essentially I am copying only the schema of this database and not the data.
1) SSMS (Backup/Restore). I do not use this one because it will copy test data into Production.
2) SSMS (Generate Scripts)
3) Writing T-SQL myself
4) RedGate (or other 3rd party tools out there)
Does anyone have preferences or biases?
For myself, I use most (4): I create a new empty database using SSMS, then populate the schema of new database using RedGate.
Perhaps, it makes no difference. But I would like to know from the more experienced DBAs what their opinions are. Thank you.