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 |
|
Mark8080
Starting Member
5 Posts |
 Posted - 2008-12-04 : 21:47:47
|
| I want to pull the data from Oracle database table and insert into DB2 database table, at regular interval of 20 minutes.What is the best way to do this? How to get from last interval raw accessed to all data of Oracle database?Thanks,Mark |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2008-12-04 : 23:09:01
|
| This is a SQL Server forum - are you planning to use SQL Server DTS to move your data between Oracle and DB2? If not you should check out an Oracle forum, you'll get more info therehttp://forums.oracle.com/forums/main.jspa?categoryID=84 |
 |
|
|
Mark8080
Starting Member
5 Posts |
Posted - 2008-12-05 : 10:58:03
|
| How I could be able to get from Oracel.TABLE_B to SqlServer.TABLE_A ?Both TABLE_B and TABLE_A are same. I want to keep TABLE_A same as TABLE_B at regular interval. |
|
|
|
|
|
|
database in sync at regular interval