I need to find a way to create the schema and data from the tables in the database as sql scripts. The purpose of the scripts is to be able to recreate the database from the scripts.
Do you know of any tools to accomplish this?
One thought on “How to script the data stored in a SQL SERVER database table?”
Comments are closed.
Yes there is a good tool in SQL Server Management Studio. You need to open management studio and right click on your database. Scroll down to task and click on generate scripts.
Then follow the wizard. In the Wizard when you reach Set Script options click on the advanced button and set the types of data to script as schema and data.