Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Replication or DTS to Oracle from SQL 2000 / 2005
- Thread starter parsql
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
When setting up the replication it should prompt you to select the type of destination server. Instead of SQL select hetrogenios (probably spelled wrong).
You can also schedule a DTS transfer between the two with no problem. Setup the package just like you would to SQL but using the Oracle drives and settings for the destination object. Then schedule it.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
You can also schedule a DTS transfer between the two with no problem. Setup the package just like you would to SQL but using the Oracle drives and settings for the destination object. Then schedule it.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Question
