| how to get increment data from oracle to sqlserver2005? [message #230098] |
Tue, 10 April 2007 20:47  |
kylin
Messages: 1
Registered: April 2007
Location: china
|
Junior Member |
|
|
my english is pool,thanks for your write back.
i try to implement it by using logminer.my step:(the oracle system open archive log only)
1.import the oracle data by using ssis of sql2005.
2.using logminer to analyse the log.
3.transition the DDL or DML to sql2005 script.
my question is :
the sql script after analyse has rowid, i can not use rowid in sql2005.how to resolve it? or have other way to realize requirement?------after imp all data of oracle once, we can refresh sql2005 data by geting the imcrement data of oracle.
[Updated on: Tue, 10 April 2007 22:12] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
