🚀 go-pugleaf

sorry for the delay, I haven't looked my messages for a while.

In short, I can't do bulk transfer of data because the structure of fields
in the new database tables may have changed (ie. table1 in db1 may have 5
fields, but table1 in db2 may have had an extra field added or a field
deleted but all remaining fields and their data is still retained and
carried across to db2).

We also use Access and MySQL, MySQL is very tolerant and is a lot more
powerful than Access but I'm trying to find something that is common accross
both db types.

Using SELECT INTO misses out on most of the field details, fields of type
Double may transfer across as type Integer or they may lose their ability
for 'allowing zero length inputs' therefore currupting to application when
using the 'new' database.

Thanks for the suggestions, I'm open to anything to assist, but I think I've
forced myself into a corner and am forced to take a long time to transfer
the data across.

"Palmetzhofer Dietmar" <xxremovethisxx_dietmar.palmetzhofer@boku.ac.at>
wrote in message news:40027be5@newsgroups.borland.com...
> OK, now I saw it. You are using Access.
> Have you tried using the "SELECT ... INTO"-statement. With this statement
> you can import a whole Table into a new DB.
> Greetings,
> Didi
>
> "Daniel Stevenson" <d.stevenson@ocreage.com.au> schrieb im Newsbeitrag
> news:400222b2@newsgroups.borland.com...
> > I'm currently looking into alternate (and hopefully faster) ways of
moving
> > data from one database to another where the field names are the same in
> each
> > table and in some situations where some fields are not present within
the
> > new database.
> >
> > The original database has tables that are related to one another (ie.
are
> in
> > master/detail relationship) and therefore data integrity needs to be
> > maintained
> >
> > I currently move one record across to the new database at a time, then
> check
> > all other tables for records that are related to the master record and
> copy
> > those across before incrementing the master record, therefore keeping
all
> > the records in their correct relationship.
> > I'm finding this method very slow especially with a database holding
over
> > 50,000 records.
> >
> > I was wondering if there was a bulk method of copying data or an SQL
> method
> > that might be faster.
> >
> > I'm currently using BCB6 with ADO and an Access database.
> >
> > Thanks
> >
> >
>
>