Board index ORACLE

Oracle DB to MS Sql Server DB Replication question...via Sql Server Views??

Oracle DB to MS Sql Server DB Replication question...via Sql Server Views??

Post by doemo » Thu, 14 Aug 2008 07:18:25


Hi,

I'm not sure if this is even possible, but I've been asked to look
into replication from Oracle to Sql Server. He's the situation:
We have access to a remote Oracle database, but only read access (not
allowed to configure or change the db).
We own a Sql Server database with Views that use a link server to
query the Oracle database.

With this setup, is it possible to replicate the Oracle database? Can
we do a replication from the Sql Server with the Views into another
Sql Server database, and if we can, will it be able to only pull the
delta for subsequent replications?

Any tips and hints would be helpful. Pleeease!

Thanx,

Doemon
 
 
 
Top

1. Replication of SQL Server 2000 db to SQL Server 2005 Express

2. Moving SQL Server installation (dbs, logins, replication, jobs, DTS etc) to new server

I need to move an entire SQL Server installation (databases, logins,
replication, jobs, DTS etc) to a new physical server.

What method requires the least manual intervention? Ideally I would like to
not have to reenter user passwords, and the replication to pick up with the
remote SQL Servers where it left off etc.

If I restored master, distribution, msdb and all user databases to the new
server, would that recreate the entire state of the SQL Server installation?
Would I also need to rename the new server with the old server's name?

3. SQL 2005 updating data in SQL 2000 DB via linked server returns error

4. Differences between MS Access and DBs like SQL Server, Oracle, etc...

5. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45289432402)

6. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45289457603)

7. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45288832411)

8. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45288857608)

9. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45289157609)

10. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45289732403)

11. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45289432402)

12. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45289132410)

13. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45288544869)

14. US-TX-Houston: VB/SQL Developer, Transact SQL, Server DB, MS Certified; C-P (45289457603)

All times are UTC
Board index