| Title: | DB Integrator Public Conference |
| Notice: | Database Integration - today! Kit/Doc info see note 36 |
| Moderator: | BROKE::ABUGOV |
| Created: | Mon Sep 21 1992 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1171 |
| Total number of notes: | 5187 |
Hi, We have a customer who is using an Oracle database under Digital Unix for data entry, and a SQL Server database for analysis. They manually (via flat files) transfer the Oracle data to the SQL Server database. Is this transfer process something that DBI could automate? Thanks for any ideas, Glenn
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1058.1 | We can help in this environment. | BROKE::ABUGOV | Wed May 15 1996 22:28 | 15 | |
Hi Glenn,
It depends what you mean by automate. You could use the Gateway to PC
Data and the Gateway to Oracle and do a insert into (select from ...)
kind of deal. If this needs to be a UNIX solution then you can't use
Data Distributor, which could automate the copy process (you schedule
it, tell it what to do, and it runs).
If you want to skip the flat file creation then the gateways will help.
Hope this helps,
Dan
| |||||
| 1058.2 | ORAREP::OTOOA::oton07.oto.dec.com::Anderson | Silence | Thu May 16 1996 11:03 | 11 | |
Hi Dan, I think the idea is to have the Unix/Oracle data changes reflected in the NT/SQL Server database, either on a nightly basis, or perhaps as soon as the changes are made, using a direct Oracle to SQL Server transfer. I have yet to talk to the customer directly, and will let you know as soon as I understand the exact requirements. Thanks Glenn | |||||