Re: Data Transfer or Views from SQL Server to Oracle
Hello Stephane, Thanks for the reply.. yes the volume is not too big.. but even then it will be substantial amount of data transferred only from SQL Server to Oracle. I was not willing to write an application, but seems from the reply there is no other way.. at present.. (I tried from Oracle to Access just to test).. and was able to create views using ODBC.. If it was Windows (SQL Server) to Windows (Oracle) ODBC would have been the best way communicate... I believe.. Anyway.. will put VB / Java to work. Nikunj - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 01:23 AM Nikunj Gupta wrote: Hello, SQL Server in on Windows 2000 Box. Oracle 8.1.7 is on Unix. Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle) I am initially not planning to dump the data from SQL Server (if possible) and then run loader etc.. I am still not on 9i... else maybe would could have tried to read external file directly after dump. Thanks for any help or hint in this. Nikunj Nikunj, You have various options, coming at different prices. I *think* that Oracle provides a gateway to Sybase/SQL Server; the reverse is also true. Some 3rd party products offer (so to speak) various replication capabilities between Oracle and SQL Server. Sybase's own Replication Server is a good product, which may help you achieve snapshot-like replication. If you feel like doing it yourself, perhaps you can combine the new Net8 APIs and Open Server and build your own bridge. Otherwise the object option, through views mapping PL/SQL tables, can provide an interesting solution if you handle volumes which can hold in memory (fully or incrementally). I have used this to do about the same you want to do with data from an iPlanet LDAP server (I have written a paper with Robert Goral to explain the basics of the technique, it has been published on the Online Edition of Oracle Magazine, search their archives). Lots of solutions indeed,which depend on how much you are ready to fork, volumes, and what you are ready to code. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Transfer or Views from SQL Server to Oracle
Nikunj Gupta wrote: Hello, SQL Server in on Windows 2000 Box. Oracle 8.1.7 is on Unix. Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle) I am initially not planning to dump the data from SQL Server (if possible) and then run loader etc.. I am still not on 9i... else maybe would could have tried to read external file directly after dump. Thanks for any help or hint in this. Nikunj Nikunj, You have various options, coming at different prices. I *think* that Oracle provides a gateway to Sybase/SQL Server; the reverse is also true. Some 3rd party products offer (so to speak) various replication capabilities between Oracle and SQL Server. Sybase's own Replication Server is a good product, which may help you achieve snapshot-like replication. If you feel like doing it yourself, perhaps you can combine the new Net8 APIs and Open Server and build your own bridge. Otherwise the object option, through views mapping PL/SQL tables, can provide an interesting solution if you handle volumes which can hold in memory (fully or incrementally). I have used this to do about the same you want to do with data from an iPlanet LDAP server (I have written a paper with Robert Goral to explain the basics of the technique, it has been published on the Online Edition of Oracle Magazine, search their archives). Lots of solutions indeed,which depend on how much you are ready to fork, volumes, and what you are ready to code. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Transfer or Views from SQL Server to Oracle
2 Options: 1. Use MS Data Transport Service (DTS) and schedule transfer task 2. Write a Java program that will connect to both databases and transfer the data. Raman. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 12:48 PM Hello, SQL Server in on Windows 2000 Box. Oracle 8.1.7 is on Unix. Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle) I am initially not planning to dump the data from SQL Server (if possible) and then run loader etc.. I am still not on 9i... else maybe would could have tried to read external file directly after dump. Thanks for any help or hint in this. Nikunj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Raman Pujani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Transfer or Views from SQL Server to Oracle
Nikunj, You can try something I did a long time ago, in Oracle 7.3; but it's also applicable now. Create an ODBC datasource on the machine where the SQL Server resides to pint to the Oracle database. For the initial load, I suppose you can create a table in SQL Server as select * from table_in_oracle. For the changes, put a trigger in each of the Oracle tables to capture the changes and write to a change_log table, similar to the replication related snapshot log table. Create a view that joins the main table and it's log table to show only the changed rows. From SQL Server side, simply read record-by-record from this view through the ODBC link and insert/update/delete as necessary. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 2:18 AM Hello, SQL Server in on Windows 2000 Box. Oracle 8.1.7 is on Unix. Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle) I am initially not planning to dump the data from SQL Server (if possible) and then run loader etc.. I am still not on 9i... else maybe would could have tried to read external file directly after dump. Thanks for any help or hint in this. Nikunj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data Transfer or Views from SQL Server to Oracle
Hello, SQL Server in on Windows 2000 Box. Oracle 8.1.7 is on Unix. Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle) I am initially not planning to dump the data from SQL Server (if possible) and then run loader etc.. I am still not on 9i... else maybe would could have tried to read external file directly after dump. Thanks for any help or hint in this. Nikunj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).