Hi,
We have two database, From First database we have to copy the table values and insert into table which is in Second database. Since there is no way(like modified date etc) in the table we can't find which record is added/modified/removed from the first table.
Presently we have a batch job to truncate all the records in the second table and insert all the records from the First table. I am not convinced with this way because this is a huge table and frequently we end up deleting the records and inserting and we make the sql server busy. Instead i need better way to handle this scenario. Do we have any other better way to handle this.
Thanks in advance.
badri prasad, Software Engineer
.
social.technet.microsoft.com/Forums
No comments:
Post a Comment