October 26, 2008 at 12:59 pm
hello
For Transfering data from one database to another database automatically
i use (DBS) and a job ,
but there is a problem:
the problem is : in every transfer all of the records in the source table
transfer to the destination table not only the new records
and this is obviously that i want only the new records....
regards
October 26, 2008 at 1:42 pm
please don't TRIPLE post, choose one and delete the other two.
make that quadruple
---------------------------------------------------------------------
October 26, 2008 at 6:45 pm
george sibbald (10/26/2008)
please don't TRIPLE post, choose one and delete the other two.make that quadruple
I think you meant QUINTUPLE :w00t:
We're going to run out of "tuples" soon.
October 27, 2008 at 11:02 am
Hi
Between your source and destination use Transform Data task, instead of selecting source from table/View use from query.
write query to find out only new data from your source. If you are using flag or datetime column write query like
SELECT a,b,c
FROM table
WHERE c = 'N'
or
SELECT a,b,c
FROM table
WHERE c > getdate()-1
Regards,
Dhaval
October 28, 2008 at 5:52 am
So I have same problem, because, same datas will come in to the server later
for example :
I download date from One server To other server every 6 am,
then I create select like this:
select * from table where event_date between Now()-1 and now()
and this query I scheduled on 6 am..
But some datas comes to server later but with correct date
example datas comes at 7 am but in the event_date is 5 am.
October 28, 2008 at 11:47 am
Transactional replication might be a better solution to keep tables in 2 databases in sync.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply