Home » RDBMS Server » Backup & Recovery » how to get increment data from oracle to sqlserver2005?
how to get increment data from oracle to sqlserver2005? [message #230098] Tue, 10 April 2007 20:47 Go to next message
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

Re: how to get increment data from oracle to sqlserver2005? [message #231066 is a reply to message #230098] Fri, 13 April 2007 22:07 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Try rownum
Be careful, ddl statements require a full backup after execution otherwise you can not restore.

[Updated on: Fri, 13 April 2007 22:08]

Report message to a moderator

Previous Topic: Recover datafile
Next Topic: issue about imp command
Goto Forum:
  


Current Time: Thu Dec 08 22:30:48 CST 2016

Total time taken to generate the page: 0.05794 seconds