0

Hi,

I have a table on two different database servers on server-1 it contains almost 2090 records and on server-2 it is empty i want to copy all the records from server-1 to server-2 both the database servers are identical but on different location and have no relation with each other

Please help Thanks

3
Contributors
3
Replies
6
Views
6 Years
Discussion Span
Last Post by abelLazm
1

SQL Server Management Studio's "Import Data" task (right-click on the DB name, then tasks) will do most of this for you. Run it from the database you want to copy the data into.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.