What is Generate Script?
This is a process in which we can generate the script of the existing database. And can use easily on other client system without loosing any Data.
Why it is different from import&export?
By using Generate Script we can export whole database as well as data and script but in import & export only we can extract the skeleton of the Database.It's a easiest way to copy database from one system to another.
Here Are the steps to Generate Script of the database.
Step-1.
Right click on the database in sql and choose Task > Generate Script.
This is a process in which we can generate the script of the existing database. And can use easily on other client system without loosing any Data.
Why it is different from import&export?
By using Generate Script we can export whole database as well as data and script but in import & export only we can extract the skeleton of the Database.It's a easiest way to copy database from one system to another.
Here Are the steps to Generate Script of the database.
Step-1.
Right click on the database in sql and choose Task > Generate Script.
