How to generate insert sql script from sqlserver2005?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
15 anos atrás
Sqlserver2005 can generate ddl script for all tables.
I want to know how do the devlop team create the sample data as insert sql script?
15 anos atrás
I thing they do it themself.
15 anos atrás
Actually I am familiar with Quest's TOAD for Oracle which allows you to generate insert scripts.
Hope the SQL Server allows it as well.

But actually it is not needed.
SQL Server support Database Backup actions.

right click on your database and choose 'Backup' to save the database as .bak file.
right click on a database and choose 'Restore' to restore the database from the file.

Hope i helped!!!
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.