Re: Problem importing data from Interbase using DTS

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Anders K. Jacobsen [DK] (none_at_at.all)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 20:57:28 +0100

> I am using the Gemini Firebird / Interbase ODBC Driver for exactly what
> you are trying to do. We're slowly converting all our clients from
> Interbase to SQL Server. I use this driver for a DTS package which pulls
> about 80 tables from Interbase source into our SQL Server target database.
> However, I use an individual Transform Data task for each table. It's a
> nightmare to maintain as we evolve the database structure but it runs
> really nicely, with multiple TD tasks executing in parallel.

We try to create views on the IB database wich match our new tablestructure
seems quite maintainable not sure though. Anyway. I have already tried with
the Gemini ODBC driver...same results. It´s real strange. Because everything
else works.

Relevant Pages

  • Re: Problem importing data from Interbase using DTS
    ... > I am using the Gemini Firebird / Interbase ODBC Driver for exactly what ... > about 80 tables from Interbase source into our SQL Server target database. ...
    (microsoft.public.sqlserver.dts)
  • A way to extend the Enterprise Library to work with other DB providers
    ... I copied and renamed the source files for working with a SQL Server database. ... Next I used the Enterprise Library Configuration tool to produce the app.config and dataConfiguration.config files with the correct parameters to connect to my Interbase database. ... public override DBCommandWrapper GetStoredProcCommandWrapper(string storedProcedureName) ... public override DBCommandWrapper GetStoredProcCommandWrapper ...
    (microsoft.public.dotnet.general)
  • Re: DataAdapters, DataSets, DataTables
    ... ODBC driver that came with InterBase has a problem with them. ... >> It sounds like it's related to the database end of things. ... >>> In regard to the Tables.Add lines, I was attempting to specify the names ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: The Contrarians Development Language
    ... I NEVER had to do ANYTHING to maintain my Interbase ... And for being a small/medium-sized company solution is ... Borland would wrap it up as "Business Database Developer Kït" at a good ...
    (borland.public.delphi.non-technical)
  • Re: Show all Tables in Database and Choose with "TabSheet"
    ... Changes appear on database when you post them. ... "Interbase" tab in IDE and that have prefix "TIB..." ... > I have a web site, (A Knowledge Base, like Microsoft's, that I have ... > So I did it basically quick, Which I am a Great Visual Designer for ...
    (borland.public.delphi.database.ado)