Copying just the data from one Database to another

sqlbulkcopy sql-server

Question

I'm not sure if this is the site for this question or not [if so put in the comment or vote to move it]

How can I copy only the data from one database to another within the same server on SQL Server 2005?

The two databases have the same schema but not the same data. I'm trying to get the data from one database to another.

I am not able to restore from a snapshot [that screws over the security settings on the database]. I'm not able to use the import data wizard, because that is trying to copy over schema data as well.

Accepted Answer

redgate SQL Data Compare is one option.



Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why