We will need to routinely import only changed data from an Oracle data base into a SQL database.
So we need an agent that will
1) Compare data in both databases (From disparate tables)
2) Import only that which is changes or new.
I am new to SQL server administration and am looking for a best practice method that we can be run on a weekly basis.
I am open to using third party software solutions, but would prefer a native MS SQL 2000 solution.
Can someone point me in the right direction?
Thanks.How much data are we talking about?
Check out this
http://weblogs.sqlteam.com/brettk/archive/2004/04/23/1281.aspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment