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 |
|
travis13
Starting Member
1 Post |
 Posted - 2002-10-11 : 16:12:09
|
I need to import daily data from an Informix DB into a SQL2k DB. I am just getting started with SQL and can't figure out the best way to import only the new data and ignore the rest. I have managed to make a copy of the current data from Informix, using DTS, now I just need to import all of the data that was created yesterday - everyday.Suggestions?  Thanks,t |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-11 : 17:25:14
|
| Hey, this is the wonderful world that I'm involved in right now. Transactional replication is what you want... had it been between 2 MSSQL servers. Great help that is hey?You'll need to make a couple considerations... How many records are you moving? How long is the DTS transfer of all rows? Will rows be added to the SQL server side and expected to be moved back to the informix DB?The easiest way would be simply to reload it every day and if the table is small, takes next to no time and resources to copy over to the SQL2k server and is only updated from the informix side... Use full loads.I'm working from IDMS moving it to SQL2k server. What I ended up having to do was create 2 behind the scenes tables. Kinda ugly and complicated but it works. It's taken me 3 monthes to write the coding nessacary to load, test, and develope transactional for the 20+ tables here. Hope you don't have to do something simular.-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-11 : 17:28:10
|
| Hmm, I missed a bit there... Will rows only be added? You mentioned moving only those that were created yesterday. If thats true and you have a create datetime on the record, you can always just filter by that date column. However if records are being updated and deleted you won't be able to do this (how do you know when to delete a column on the sql server side?-----------------------SQL isn't just a hobby, It's an addiction |
|
|
|
|
|
|
Daily Import from Informix DB