Subject Re: [firebird-tools] Duplicating tables and metadata from laptop to Server
Author Jonathan Neve
Dear Tony,


> I am looking for a simple FB tool to be able to dupicate
> databases/tables and associated metadata from a laptop through to a
> server. The databses/progs are created/developed on my laptop but then
> I need to be able to duplicate, especially new tables, across a
> network onto the server, perhaps with associated data in the tables.
> Have had a brief look at some of the 'Replicators' and the 'Data
> Pumps' but they appear to function (at least as a first look) only
> between databases on the same server or same PC.

I don't know of any tool that can both synchronize meta-data and data
over the network. It may exist, but I don't think I've ever seen such a
beast.

CopyCat does of course work over a network, but it is only a replicator,
and therefore, doesn't synchronize the meta-data. The same goes for most
(if not all) replicators. On the other hand, I know of at least one tool
(by CleverComponents) for synchronizing meta-data, but, IIRC, it doesn't
synchronize data, i.e. it's not a replicator at all...

CopyCat does have the advantage of being a component set rather than a
ready-made tool, which means that it's a lot more extensible, so perhaps
you could perform meta-data synchronization yourself while using CopyCat
as a backbone for replication. Or else perhaps it could be combined with
the components from CleverComponents.

I'm not sure exactly what your options are, as I've not looked into this
in depth, but perhaps this will at least give you something to consider.

--
Best regards,
Jonathan Neve
_______________
CopyTiger - advanced database replicator for Interbase/Firebird!
Web : http://www.microtec.fr/copycat/ct
_______________________________________
CopyCat - database replication components for Delphi/C++Builder!
Web : http://www.microtec.fr/copycat/cc