Right click on the database in Enterprise Manager. Choose All Tasks > Generate SQL Script.
All the options you might want should be there. Spike Stephen Milligan Team Macromedia - ColdFusion Co-author 'Reality Macromedia ColdFusion MX: Intranets and Content Management' http://spikefu.blogspot.com > -----Original Message----- > From: Ben Lowndes [mailto:[EMAIL PROTECTED]] > Sent: 29 November 2002 13:55 > To: CF-Dev > Subject: [ cf-dev ] SQL db creation > > > Hello, > > I'm running MS SQL2000 and I'd like to reverse engineer the > creation of a database. I can use SQL query analyzer to > script the creation of tables and sp's - although only one at > a time - is there anyway to get it to script everything? > > What I'd also like to do is script the inserts of the initial > values - aside from writing them all myself is there any tool > which will script the inserts based on what's already in the table. > > Yes it's Friday. Yes, I'm being lazy! > > Thanks, > Ben > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
