February 10, 2004 at 2:21 am
I have data stored in a oracle rdb DB and I want it ported to a SQL DB so that at any time the SQL data will reflect what happening in the oracel RDB DB.
February 10, 2004 at 5:14 pm
February 10, 2004 at 11:02 pm
Thanks for the reply. I want to use the replication feature of SQL server 2000 to house data from an oracle RDB(ver 6.1 - previously DEC RDB) DB - so i want the oracle DB to be replicated to SQL. Can this be done? If not, how otherwise can one achieve replicating data in other datasources to SQL Server 2000.
February 11, 2004 at 7:42 am
Hi,
I want to replicate the data from oracle 9.2.0.1 database to sql server 2000? How can it be done?
Thanks in advance.
February 11, 2004 at 4:32 pm
GA,
If your requirement is to Replicate an ORACLE Database to a SQL Server Database then doesn't this have to be done from the ORACLE side? Surely ORACLE like most serious RDBMS Systems has a Replication feature!
If ORACLE does Have replication then for peets sake whay are you asking this question? Your mission is to configure the ORACLE Server to replicate a Database to a SQL Server!
SQL Server does have the ability to replicate to other datasources however I cannot speak for ORACLE or any other RDBMS.
February 11, 2004 at 11:03 pm
MrSQL,
February 11, 2004 at 11:03 pm
MrSQL,
February 11, 2004 at 11:16 pm
MrSql , sorry about the other two - very generous with the return key. The DB(RDB v6.1 a digital product now taken over by oracle so therefore not a true oracle DB) I want to replicate does not have a replication feature, so how I see it is that the publication must be populated from RDB via one of the oledb providers, subscriptions can then map this publication. What means are there to keep this publication up-to-date at all times. I'm very new to SQL Server 2000 so excuse me if my inexperience is showing. Has anyone done this before? Can you have a publication in SQL Server that is populated from an external datasource? If so, how is this done?
February 12, 2004 at 4:54 pm
If RDB v6.1 does not have a replication feature then you can't do it! I can't believe how stupid some companys are to have such crap RDBMS such as RDB v6.1! I've never heard of it! There are 3 serious players in the RDBMS arena! They are SQL Server, Oracle and DB2. The rest are CRAP!
Now.....Having said all that, your best bet is to try doing this using DTS. Have a go with DTS, I know you can achieve this via DTS. However, if you want the data to be real time like replication offers then DTS is no good to you! So failing all this, then it's up to you to convince management to get rid of that CRAP RDBMS and migrate it to SQL Server!
February 15, 2004 at 5:37 pm
I have not tried to replicate to Oracle, might be worth a post in the newsgroups to get some MS help. I know there is a least one 3rd party product that does cross db platform replication.
August 16, 2005 at 1:08 am
Rdb crap??? You better do your homework. Before there was Sqlserver or Oracle there was Rdb. Many features youre using today with sqlserver or oracle are designed by (digital) Oracle rdbms.
michel
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply