mercredi 28 janvier 2015

Copy of a database with an existing database with schema and data in sql server


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

Master--> Schema+Data


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.


Please suggest.





Aucun commentaire:

Enregistrer un commentaire