[DB-SIG] I wonder if there are module, class to perform table copy ?

[M.-A. Lemburg]

On 2007-08-01 16:49, KLEIN Stéphane wrote:
> Hello,
> 
> I wonder if there are module,class to perform table copy ? Coping table 
> structure and/or table data from one database to other or same.

Copying data is usually easy: just do a SELECT * and use the result set
as input for the INSERT.

Copying table structures is hard, since the database interfaces often
don't provide enough information to do exact replicates of the schema.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Aug 01 2007)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611