sql server data warehouse: how i can make script Database with Data? -- sql server data warehouse

how i can make script Database with Data?

Tark Siala
6/14/2006 3:57:40 PM

sql server data warehouse: hi
i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise +
SP4.
i have database contains Tables, and i want make script to build Tables on
other Database,
but i need this script include Data in Tables too, i can make that ? and
how?

thanks
--
Tarek M. Siala

Re: how i can make script Database with Data?

Andrea Montanari
6/14/2006 6:12:42 PM

hi,
[quoted text, click to view]

you can have a look at a free prj of mine, at the link following my sign.,
DbaMgr2k, which include an "INSERT INTO" script generation feature at table
level...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply