Need Access 2 SQL datapump

Pierre

Delphi Developer

Need Access 2 SQL datapump

2007-03-03 12:07:26 PM
delphi177
Anyone know of a ROBUST datapump that will help me move structures and
data from a bunch of Access 2000 databases, containing relatively
complex tables, to reasonably standardised SQL CREATE and INSERT INTO
statements?
--
Pierre
Worrigee, NSW,
,-._|\
/ Oz \
\_,--._/
v
Governments are just people, but ungoverned.

Bob D.

Delphi Developer

2007-03-03 12:44:02 PM

Re:Need Access 2 SQL datapump

I was using an old component
www.islamov.com/metadata/index.html
I was very happy.
"Pierre" <XXXX@XXXXX.COM>writes

Quote

Anyone know of a ROBUST datapump that will help me move structures and
data from a bunch of Access 2000 databases, containing relatively complex
tables, to reasonably standardised SQL CREATE and INSERT INTO statements?

--

Pierre
Worrigee, NSW,
,-._|\
/ Oz \
\_,--._/
v

Governments are just people, but ungoverned.

Martijn Tonies

Delphi Developer

2007-03-04 02:34:27 AM

Re:Need Access 2 SQL datapump

Hi,

Quote

Anyone know of a ROBUST datapump that will help me move structures and
data from a bunch of Access 2000 databases, containing relatively
complex tables, to reasonably standardised SQL CREATE and INSERT INTO
statements?
By using the Schema Migrator and DataPump inside Database Workbench,

you could do this.
See www.upscene.com
and
www.upscene.com/documentation/dbw/tools_schemamigrator.htm
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
www.upscene.com
My thoughts:
blog.upscene.com/martijn/
Database development questions? Check the forum!
www.databasedevelopmentforum.com

Pierre

Delphi Developer

2007-03-04 05:50:38 AM

Re:Need Access 2 SQL datapump

Martijn Tonies writes:

Quote

See www.upscene.com
and
www.upscene.com/documentation/dbw/tools_schemamigrator.htm

Hi,

I'd looked at that but couldn't see a reference that MS-Access was
supported, even if only through ADO. Is it supported?
--
Pierre
Worrigee, NSW,
,-._|\
/ Oz \
\_,--._/
v
Governments are just people, but ungoverned.

Martijn Tonies

Delphi Developer

2007-03-05 10:49:25 PM

Re:Need Access 2 SQL datapump

Quote

>
>See www.upscene.com
>and
>www.upscene.com/documentation/dbw/tools_schemamigrator.htm
>
>
Hi,
I'd looked at that but couldn't see a reference that MS-Access was
supported, even if only through ADO. Is it supported?
It supports any ADO or ODBC datasource. Me and several

customers have converted existing MS Access databases
without problems.
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
www.upscene.com
My thoughts:
blog.upscene.com/martijn/
Database development questions? Check the forum!
www.databasedevelopmentforum.com