Recently I've been involved in an upgrade project migrating databases from 2000 into 2005; the database then replicates to another company into a 2008 Database. The processes involved extract data from an Oracle database into the 2005 Database
and then transferring the data to the 2008 Database. a Stored procedeure is then fired on both Servers to integrate the extracted/migrated data into the existing data.
The problem is that now we are getting duplicate data in the 2008 database; essentially the Stored Procedure is supposed to delete existing data if it has been migrated and then replace it with the existing data but it appears as though this isn't happening.
Is anybody aware of any issues surrounding 2008 R2 that could explain this?
Please click "Mark As Answer" if my post helped. Tony C.
View Complete Post