Monday, April 8, 2013

[SQL Server Data Warehousing] Data replicated from a Table to a Table across database


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

Search This Blog