Re: exporting data from one db to another.. using Microsoft Providers.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

sahridhayan,

ADO.NET 1.1 is not a good tool to ferry large amounts of data between
databases. By using a dataset/data-adapter based approach you would incur
the overhead of a huge dataset, and have to execute one query per row. Not
to mention hierarchical data will be a royal pain.

You are better off using an ODBC Linked table through Access, and perform
this operation via interop.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/





"sahridhayan" <sahridhayan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8BAB5041-C4CB-40D3-AE67-2759104C88E4@xxxxxxxxxxxxxxxx
> Hi,
> Can some one please post a sample or site where I can get code for
> transfering data from a database (Oracle) and put it in another
(Access).(or
> from access to odbc oracle..) The data can be SELECTed with filters and
> modifications for reporting purposes.
> It will be great if the sample could show I could use dataset as a
temporary
> storage and use it to push data into multiple databases, either into new
> tables or append tables in databases.
> thanks,
> sahridhayan
>
> PS: There was a post with an example something like below.. will this work
> perfectly fine for large..inserts, this idea is very close to what I wish
to
> do. But I am open to any other procedre:
> =============================================================
>
> Dim cmdCopy As OleDbCommand
>
> cmdCopy = New OleDbCommand("SELECT * INTO [admin_document_new] FROM
> [Provider={MSDAORA.1\};User ID=admin;Data
> Source=src;Password=***].[document]", myLocalConnection)
>
> nRows = cmdCopy.ExecuteNonQuery()
>
> =============================================================


.

Relevant Pages

  • Re: Need your help [arguments for open source databases]
    ... >> I would like to have your opinions about open source databases versus ... >> in the universe of relational databases. ... The main difference between PostgreSQL and Oracle is manageability. ...
    (RedHat)
  • US-PA: Newtown - Junior to Mid-Level Oracle DBA
    ... Inc. is seeking an experienced junior to mid-level Oracle DBA to support multiple highly available transactional and data warehouse databases underpinning a 24x7 global web services application. ... Position responsibilities consist of both operational and application support primarily in a Red Hat Linux environment. ...
    (comp.databases.oracle.marketplace)
  • US-PA: Philadelphia Area - Junior to Mid-Level Oracle DBA (FT Permanent)
    ... Inc. is seeking an experienced junior to mid-level Oracle DBA to support multiple highly available transactional and data warehouse databases underpinning a 24x7 global web services application. ... Position responsibilities consist of both operational and application support primarily in a Red Hat Linux environment. ...
    (comp.databases.oracle.marketplace)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)
  • Re: Weird listbox issue (Gupta(SqlWindows), Oracle)
    ... MVk - Monika V. kycka schreef: ... Client has 2 Oracle 10g databases - test and real. ... But application retrievs only first number value leaving string empty. ... And instead of testing all kind of modifications to your code, I suggest you try to find the difference in the databases. ...
    (comp.databases.oracle.misc)