I have a data warehouse which isn't huge only about 16Gb in a Microsoft SQL Server Standard Edition 2014 database. However, now that it forms part of our production system I don't like developing on it because it can affect our end users.
Therefore what I would like to do is automate a nightly process to:
- Backup the structure of warehouse1
- Restore the structure to a warehouse2 on the same server
So in effect I end up with a mirror of warehouse1 database structure in Warehouse2 database. I can then use this database for development.
As all of the data is retrieved from other locations I don't want to back the data up I just want to do the structure.
Does this seem like the most appropriate method of achieving what I want to do or is there an alternative? If this does sound right would you be able to suggest how I would go about achieving this?
Thanks in advance,