How to generate script/stored procedure to copy data from one database to another

I had to restore may database to 1 day erlier, so My database is missing data from a day before, and this databse has been used by users since the restoration.

How do I generate scri开发者_运维知识库pt/stored procedure to copy just the missing data from the backup database into my current database.

There are PK and FK relationships that need to be considering. I'm using SQL server 2005

Thanks for your help.

Aein

If there are many tables, this will be a chore to write. I would suggest using a data comparison tool such as Red-Gate's Data Compare. The amount of time you will spending writing a synchronization script will cost much more than simply buying a tool that will do it for you. (No, I do not work for Red-Gate).