Duplicating tables from one DB to another...?

Article View: borland.public.cppbuilder.database.ado

Article #392

Back to borland.public.cppbuilder.database.ado Previous Next

#392

From: Roddy Pratt
Date: Mon, 09 Oct 2006 12:28

10 lines
1101 bytes

I have a 'local' ODBC-accesible database created by a third-party
program.

I want to replicate the tables from this onto a remote MySQL database.

Is there a simple way of doing this (maybe a 3rd party tool/component),
or do I have to write Delphi code to iterate through all the tables,
records and fields explicitly?

 - Roddy

Technical Details

Message-ID: <452a4072$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,99dafef11586e1bf,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Roddy Pratt" <>
Subject: Duplicating tables from one DB to another...?
Newsgroups: borland.public.cppbuilder.database.ado
User-Agent: XanaNews/1.18.1.3
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 82.70.221.38
Message-ID: <452a4072$1@newsgroups.borland.com>
Date: 9 Oct 2006 05:28:34 -0700
X-Trace: newsgroups.borland.com 1160396914 82.70.221.38 (9 Oct 2006 05:28:34 -0700)
Lines: 16
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail