Scott, So if I have 2 tables with constraints / relationships for the ID that I want to change to a new value, needs to be dropped. Would this then change the ID in the other table to match the new value?
Regards Andrew Scott Analyst Programmer CMS Transport Systems Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9699 7988 - Fax: 03 9699 7976 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 28 June 2005 4:25 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Strange request for a SQL tool Drop all your constraints, then re-add them after Importing your data. >>> [EMAIL PROTECTED] 06/28/05 4:10 pm >>> Taco, Not that simple, I have tried to use the DTS method and never can get it to work. I have multiple tables that have constraints and relationships that DTS seems to not be working with, maybe it's the way I am trying it. I just can't seem to copy the data over using DTS, I'll put it down to me not understanding DTS properly I guess. Any thoughts. Regards Andrew Scott Analyst Programmer CMS Transport Systems Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9699 7988 - Fax: 03 9699 7976 --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
