I have had similar projects. I did it manually, as I figured I would probably spend the 4-6 hours anyaways researching and trialing.
One way I did it was export everything, combine it up in MS Access (only 'cause I'm familiar with it and it's easy to play with the Autonumbers), create a datasource from the new .mdb and then manually insert the Access data into SQL. Other than that, I typically just T-SQL it. Take a few hours for a few hundred tables. Or you can pour over Google and lists for a few hours. ;) Chad who is thinking about learning JavaScript this weekend, inspired by 4-Non Blonds On 6/28/05, andrews <[EMAIL PROTECTED]> wrote: > 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/ > --- 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/
