Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2006-08-01 : 16:08:43
|
| Hi all, How can i set up replication from SQL to Oracle!!!also if possible to schedule DTS that will transfer data from SQL 2000 to Oracle!! Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-04 : 04:08:20
|
| From an Oracle perspective, you can make the SQL Server database appear as if it is an Oracle database by using a product called Heterogeneous Services. This let's you connect the Oracle database to SQL Server through an ODBC driver. You can then use triggers in the Oracle database to push the data to the SQL Server database when the data changes in Oracle. This way, data is replicated instantly!Another method is to use database triggers to populate a local table with the underlying table's changes. For instance, let's assume I have an EMP table. Then I can create a EMP_CHANGES table. Also create a trigger on the EMP table that populates EMP_CHANGES with all of the changes that occurred to EMP. Now have the other database query this table on a regular basis (5 minutes?) and only query the EMP_CHANGES table. This greatly reduces the burden on the EMP table!Using DTS to transfer data to ORACLE from SQL should not be a problem. Right click the DTS Package, select "Schedule Package..."Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Replicatoin or DTS to Oracle from SQL 2000