Open Microsoft SQL Management Studio on the Source server.

Log in to your SQL server.

Expand the server and as well as Databases.

Right click on the name of your database and go to Tasks > Generate Scripts.

Click Next.

• This reply was modified 4 years, 6 months ago by Amighost.