Re: Snapshot of ODBC Database

> > Hello,
> >
> > is it possible to make a snapshot of a ODBC Database?
> > If not... is there any 3rd party tool to do such things efficient?
>
> I'm not completely sure what you mean by an ODBC database-- ODBC is a
> protocol to allow a client to communicate with a database.
>
> If the database you'd like to take a snapshot of has an ODBC driver
> available, and the database provider doesn't ship a nice snapshot tool
> like Oracle does, you could make a quick & dirty tool yourself simply
 by
> calling SQLTables & SQLColums to get the tables & columns in the
> database, doing your own select * from <table_name> queries, etc.
 Note
> that this is probably only appropriate for very primitive 'databases',
> i.e. Excel, that have little data & no metadata.

The ODBC data-source is a host-database with some 100.000nds of rows. I heared something about a "gateway" to connect to such datasources. ...but we only have a ODBC Driver to connect zu this host. We want to replicate to our oracle instace to get a better reporting performance.

--
CU JM
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 = Write me @ JohannM_at_writeme.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


Sent via Deja.com http://www.deja.com/
Before you buy.