Duplicating a Table wth ADO

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

Article #2005

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

#2005

From: Daniel Stevenson
Date: Thu, 11 Dec 2003 04:02

16 lines
1587 bytes

I'm trying to work out the best method for duplicating a table within one
database to another database so that all the fields are the same, the
indexes are the same, etc.

I have been using SQL CREATE TABLE but I can't seem to determine the indexes
from the existing ADOTable in order to complete the SQL call properly.

I have heard about using the OpenSchema but can't seem to find the
information I'm after (or I can't interpret what I have been seeing).

I am currently using an Access Database but I will also need to use the
function within other databases (eg MySQL).

Can anyone help?

Much appreciated.

Technical Details

Message-ID: <3fd7ec3d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!news-out.visi.com!petbe.visi.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,e62fa7bff80f5ea8,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-12-10 20:09:26 PST
From: "Daniel Stevenson" <d.stevenson@ocreage.com.au>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Duplicating a Table wth ADO
Date: Thu, 11 Dec 2003 15:02:03 +1100
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 202.174.228.150
Message-ID: <3fd7ec3d$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1071115325 202.174.228.150 (10 Dec 2003 20:02:05 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!news-out.visi.com!petbe.visi.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail