There is a COPY objects and Data option in DTS, be careful though, you can easily overwrite data , and schema.
Justin > -----Original Message----- > From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] > Sent: 29 November 2002 14:16 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL db creation > > > You'll need to use DTS for this I think.. > > Justin > > > -----Original Message----- > > From: Ben Lowndes [mailto:[EMAIL PROTECTED]] > > Sent: 29 November 2002 14:14 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] SQL db creation > > > > > > Aha! Got it. But I can't see where to script the inserts of records > > already in the table. > > > > -----Original Message----- > > >From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > > Sent: 29 November 2002 13:07 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] SQL db creation > > > > see I knew I wasn't mad :-) > > > > -----Original Message----- > > >From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] > > Sent: 29 November 2002 13:07 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] SQL db creation > > > > > > You can. right click DB in enterprise manager, click show all, select > > all > > the options objects you want (indexes and constraint in different tab) > > > > Justin > > > > > -----Original Message----- > > > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > > > Sent: 29 November 2002 12:49 > > > To: [EMAIL PROTECTED] > > > Subject: RE: [ cf-dev ] SQL db creation > > > > > > > > > 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] > > > > > > > > > > > > > > > > > > -- > > ** 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] > > > > > > > > -- > > ** 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] > > > > -- ** 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]
