Thanks SSC-Enthusiastic

Now i have the solution to do that by using the Bulk Copy.But now i have another issue that I have table ID Autonumber so...

Thanks SSC-Enthusiastic,

I tell you the whole requirement with example .

I have 2 DataBases DataBase1 and DataBase2 and Both have same structure.

DataBase1...

Thanks Deepak,

As you said its works fine.But their is some problem in it.when i Restore the DataBase with (No Recovery) then the DataBase is shown Restoring...state.

My requirement...