>I have tested bcp to replicate the image of a table. Basically, this serves for bulk insert. So, once I have everything exported to a .dat file, I can then import it into another SQL Server database on an image of that table. That works. If I try it on the same database, having 61 records, I will end up with 61 additional records once I import it. But, this is not what I want. I need to have a clean way to replicate a table from one database to another. I need to preserve the primary keys as is. Is bcp able to do that?

BCP has -E flag that prevents SQL Server from supplying new identity values.