Dump database to sql???

[code frog 0]

Anybody know how to dump a database to SQL? (Yup, all tables, procedures, etc...)

I only read CP for the articles. Code-frog System Architects, Inc.

[kageorge]

Hi, Take the enterprice manager and just select what all the objects you want to script and then COPY and take the query analiser or any editor and PASTE it..

[Rob Graham]

If you are using SQL Server, select the database from the tree in left pane of Entrprise manager. Right click, select "All Tasks"->"Generate SQL Script". The resulting dialog will allow you to select whatever you want to script, and will generate scripts for all the schema. To get data in the tables, you will need to use somthing else, like BCP, or roll your own. Absolute faith corrupts as absolutely as absolute power Eric Hoffer All that is necessary for the triumph of evil is that good men do nothing. Edmund Burke -- modified at 17:41 Friday 3rd March, 2006