Indeed, for some reason though, this can ho badly wrong on larger DBs - not all the time, but I have seen it happen on way top many occasions.
"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: Jim Wright To: CF-Talk Sent: Tue Aug 15 18:23:06 2006 Subject: Re: OT: MS SQL 2000 On 8/15/06, Jenny Gavin-Wear <[EMAIL PROTECTED]> wrote: > 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!) > If you use the DTS Import/Export wizard in 2000 Enterprise Manager (right click on your database and go to All Tasks/Export Data), when you get to the part where you choose which tables to export, there will be a "Transform" button on the right. Click on that and it will allow you to do the mappings. (and don't choose the option to copy objects between SQL Servers in a previous step). -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:249883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4