One thing to say about Red Gate .. wow !! Love it, will save days of banging head against keyboard.
Thanks again Neil !! Jenny -----Original Message----- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 15 August 2006 19:44 To: CF-Talk Subject: RE: OT: MS SQL 2000 Looks perfect, downloaded and trying it now, thanks Neil. Thanks all for the replies. I looked at using the DTS in SQL 2000, but wasn't overly impressed. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 15 August 2006 18:08 To: CF-Talk Subject: Re: OT: MS SQL 2000 Go download a trial of Red Gate bundle (or Apex SQL). Not free, but solid. "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Jenny Gavin-Wear To: CF-Talk Sent: Tue Aug 15 17:55:24 2006 Subject: OT: MS SQL 2000 Does anyone know of a good util (or if it can be done in SQL 2000 as i can't see how) to import data from one database into another and allowing fields to be mapped? (Something free would be good!) Thanks, Jenny -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.10.10/418 - Release Date: 14/08/2006 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4