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 |
|
bigdan
Starting Member
1 Post |
 Posted - 2009-03-05 : 14:18:29
|
| I’m am very new and need help creating a data warehouse with SQL server 2000. I plan on doing an initial import of all required tables currently housed in our Oracle database with the built in import wizard, and then I’d like to schedule a job to pull only the new records from the Oracle database nightly. If a record is added to a table in Oracle it should be added to the associated SQL server table. If a record is dropped from a table in Oracle then the record should “NOT” be dropped from the associated SQL server table. The largest table contains over 10 million entries so whatever is done needs to be efficient. What would be the best way import the new rows? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2009-03-09 : 18:37:24
|
| To be efficient, you'll need to find some way of identifying new or updated rows in your Oracle DB. This may be as easy as looking at record timestamps but you'll need to be sure that they are reliable. The other options are:- run a linked query between both databases to identify changes (not recommended...)- load the Oracle data into a staging table in SQL and query between the 'live' and 'staging' version to work out the differences. |
 |
|
|
|
|
|
Need help creating a data warehouse