No, not being funny just lazy.... I've got a db full of junk test data as well as the initial basic data. I though it'd be nice if I could script everything and then just rip out of the script the junk data. I also thought it'd be good to be able to do a search and replace on the basic data in the script as the requirements change.
I think I'll go with using DTS to make a copy, remove all the junk data from that and save it as a "template database" Friday, Friday, Friday! -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 14:26 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SQL db creation Not being funny, but is there a reason why you can't just take a back up of the database and install that on another server? Or are you using the SQL to move to a different DBMS altogether? ----- Original Message ----- From: "Ben Lowndes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 29, 2002 2:14 PM 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]
