Are you looking for an easy way to create scripts that include both the database structure and the data in SQL Server? Whether you want to move your database to another place, make a backup, or share your database with others, having scripts with both the design (schema) and the data is very important.

In this blog, I will show you step-by-step how to create SQL scripts from your SQL Server database. These scripts will include things like tables, keys, rules, and all the data inside the tables. You will learn how to use SQL Server Management Studio (SSMS) tools easily, how to choose the right options to make your scripts, and tips to help you move or copy your database without problems.

Let's Start :  First Open your SQL Server Management Studio 

Select your database as selected in below snippet

Now right click on your Database and choose Task >> Generate Script 

When you clicked on generate script then open a window like below snippet .

Now , If you want to generate entire Database objects like Tables , Views, Procedures etc.

Then choose first radio button or select specific, I need a table schema and data so selecting second option >> and choose one table from below table's list

After selecting table click on next button .

As above snippet there are option , Where your script will open in new window or save it somewhere it is your choice.  As I am selecting open in new window, There is option for Advance >> Click on Advance .

Scroll down in General section you will see a option for "Types of data to script"

Choose Schema and data  and click on ok button >> Now click on next button >> new window will show, again click on next button.

Now your script is generated . and click on finish button.

As you can see in below snippet data and schema are generated in new query window .

🙏 Thank You for Reading!

Thank you for taking the time to read this blog! I hope it helped you understand how to generate scripts with schema and data in SQL Server.

If you have any questions or need help with something, feel free to drop a message in the comments or contact section. I’ll get back to you as soon as possible.

Happy Learning! 😊