Recently, we were working on a small project. The requirement was to create an empty copy of an existing database, meaning the new database could contain only database objects without data. The database was smaller and less complicated, so we completed the task using the Transfer SQL Server object task of SQL Server Integration Services. Later, we created a SQL Job to automate the process. You can read more about the Transfer database object task here.
In this article, I am sharing the step-by-step process. For demonstration, I have created a test setup with three virtual machines. The details are