MSSQL Expr Mgmt Studio scripting

[mechInferno]

I am using the management studio to generate a complete script that will have everything that is needed to transfer the database to another computer. I have created a sql script that creates all objects such as: Tables, view, procedures and so on. But, I am trying to find out how to include all the insert statements to populate the 7 or 8 tables in a small database.

If there is anyone who can help, it would be most appreciated. Anythingelse needed let me know.

Kevin

 

[mrdenny]

SQL doesn't include a way to do that. It willb e much easier to simply backup the database and then restore the database to the second machines SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mechInferno]

I figured as much

thanks for the reply

Kevin