[CLUE-Tech] OT: SQL Server dump-to-text

[David Willson]

Chris and Dave were right.  There is no option to script the data along
with the DDL.

On Tue, 2001-12-25 at 10:12, David Willson wrote:
> I think there's an option to script the data, too.  I'll check tomorrow at
> work.
> 
> -----Original Message-----
> From: clue-tech-admin at clue.denver.co.us
> [mailto:clue-tech-admin at clue.denver.co.us]On Behalf Of Dave Anselmi
> Sent: Sunday, 23 December, 2001 11:53
> To: clue-tech at clue.denver.co.us
> Subject: Re: [CLUE-Tech] OT: SQL Server dump-to-text
> 
> 
> "Chris K. Chew" wrote:
> 
> > Well yes, and no.
> >
> > To clarify, I found that SQL Server is able to dump the database to a
> > records-only sql text file.  The file will contain no information about
> the
> > table structures, however.  I was hoping that ms would remain faithful to
> > the SQL standard and give me a genuine sql dump of the database including
> > CREATE TABLE statements.  I searched both the Internet and every related
> > book in the local computer bookstore, but couldn't find anything telling
> me
> > that it can do it, much less how to do it.  I like to know how, if it is
> > indeed possible.
> 
> Look in the SQL Server books on-line, in the howto section (enterprise
> manager,
> and databases):
> 
> <quote>
> To generate a script
> 
> Expand a server group; then expand a server.
> Expand Databases, right-click the database to script, point to All Tasks,
> and
> then click Generate SQL Scripts....
> On the General tab, select the database objects to script. By default, all
> objects in the database are scripted.
> On the Formatting tab, select from the script formatting options:
> </quote>
> 
> And so on...
> 
> Seems that this is just what you are looking for.  Of course the script may
> be
> transact-sql and may require massaging to work with another db.  And you
> already
> know how to dump the data itself.
> 
> Dave
> 
> 
> _______________________________________________
> CLUE-Tech mailing list
> CLUE-Tech at clue.denver.co.us
> http://clue.denver.co.us/mailman/listinfo/clue-tech
> 
> _______________________________________________
> CLUE-Tech mailing list
> CLUE-Tech at clue.denver.co.us
> http://clue.denver.co.us/mailman/listinfo/clue-tech