Uuuh, DTS copies them for you one at a time. I'm telling you DTS will do the trick but if you are not willing to have a look at it and investigate then go ahead and waste your time doing it manually.
> 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 leave-cfaussie- [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ ________________________________ Taco Fleur - E-commerce Development Manager Shelco Searches & Services An Authorised ASIC Information Broker www.shelco.com.au Ph: + 61 7 3236 2605 --- 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/
