I thought you could just select all tables to generate scripts for by default. Have you tried the DTS and meta data services in Enterprise manager ?
-----Original Message----- From: Ben Lowndes [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 12: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]
