Taco, To copy data from one table to another one at a time is not an option, I require something that will automate this for me. If it was one or 2 tables I wouldn't care and do the damn thing manually.
I need a tool that will copy the data to another database, not copy the ID field but if need be change the ID field that is other tables use as a relationship. And yes that is where the constraints come in, this has bee setup to do this for me. But I need to be able to import this data into the new database renumber the identities and the constraint (via diagrams) should do the work of making the other changes for me. 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 Taco Fleur Sent: Tuesday, 28 June 2005 4:30 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Strange request for a SQL tool You can also disable check constraints with DTS (I believe). If not, then you just need to make sure you run the export in the right order, i.e. the tables with the foreign relationships first. example; Person User Email First insert the Person because the User table relies on a record being present in the Person table etc. etc. --- 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/
