| View previous topic :: View next topic |
| Author |
Message |
Roddy Pratt
Guest
|
 Posted: Mon Oct 09, 2006 5:28 pm Post subject: Duplicating tables from one DB to another...? |
 |
|
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 |
|
| Back to top |
|
 |
Mark Guerrieri
Guest
|
| Posted: Fri Oct 13, 2006 8:10 am Post subject: Re: Duplicating tables from one DB to another...? |
|
|
Go to MySQL.com - they have a migration tool to do just that...
Mark
<Roddy Pratt> wrote in message news:452a4072$1 (AT) newsgroups (DOT) borland.com...
| Quote: | 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
|
|
|
| Back to top |
|
|
Roddy Pratt
Guest
|
| Posted: Sat Oct 14, 2006 7:35 pm Post subject: Re: Duplicating tables from one DB to another...? |
|
|
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
-- |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
