and check your date, i.e. so it wont break within 7. -----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 13:06 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL2000 - SQL97
i've got access to 7 and 2000, feel free to give me a shout off list in fact have had to backup from 2000 to 7 a few times before, basically created a script to create the database (this works fine 2000>7) and used DTS as phil says, however you really need to know the character set of your 7 database, cause if it doesn't match the character set of the 7 database you are backing up to they still won't work mark -----Original Message----- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 12:53 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL2000 - SQL97 Why not ask nicely for someone to help? I'm sure someone here has access to 2000 and 7, can then open it in 2000, DTS it to 7 and then do a backup or similar... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** > -----Original Message----- > From: Taz [mailto:[EMAIL PROTECTED] > Sent: 12 March 2003 11:11 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] SQL2000 - SQL97 > > > > Back again... > > Why did I put SQL 97? Its 7... duh! > > Anyway, all these lovely suggestions of importing, exporting > and sticking a > couple of nails into it are very well but... well I don't > have a copy of SQL > 2000. Fairly obvious really, otherwise I'd not be asking. And > much as I'd > like to break into my piggy bank that currently has 3 million > in it, that > would just be a dream, so its unlikely. > > Anyway, I've gone back to the client and asked them to export > it as 97 (or > sort out whatever error is forcing it to break)... with any > luck I'll get it > back before next August. > > Yadda yadda yadda > > Taz > (AKA Biscuit Factory) > > > -- > ** 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]
