Duplicating tables from one DB to another...?

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

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Roddy Pratt Mon, 09 Oct 2006 12:28

#392

Author: 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

Re: Duplicating tables from one DB to another...?

#395

Author: Mark Guerrieri
Date: Fri, 13 Oct 2006 03:51

21 lines
1489 bytes

Go to MySQL.com - they have a migration tool to do just that...

Mark

<Roddy Pratt> wrote in message news:452a4072$1@newsgroups.borland.com...
>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
>
>
>
>
>
>

Re: Duplicating tables from one DB to another...?

#397

Author: Roddy Pratt
Date: Sat, 14 Oct 2006 14:35

8 lines
948 bytes

Thanks. I need to do a daily sync rather than just a one-off migration,
but it's a good place to start.

I'll give that a try....

 - Roddy

--

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads