I have two databases one is having master kind of tables and other will have transaction data. I should create a new database with a structure of an existing database to my clients. Here is the scenario..
If the particular db will comes under transaction type then structure of an existing db should copy If the particular db will comes under master type then structure of an existing db along with data should copy
i.e Transaction--> Only Schema
I tried with Generate script, Is there any way to automate this process instead of manually generating script for both schema and Schema+Data for every copy of a new db.