Transferring just data from one database to another

sqlbulkcopy sql-server

Question

I'm unsure whether this is the appropriate forum for my issue or not. If it is, please let me know in a comment or relocate the question.

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

Despite not having the same data, the two databases share the same schema. I'm attempting to transfer data across databases.

I am unable to recover from a snapshot [that corrupts the database's security settings]. The import data wizard is attempting to transfer over schema data as well, thus I am unable to utilize it.

1
1
1/14/2011 9:30:36 PM

Accepted Answer

One possibility is SQL Data Compare with Redgate.

4
1/14/2011 9:37:09 PM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow