Member Avatar for abelLazm

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
  • 130 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by abelLazm

Recommended Answers

All 3 Replies

Member Avatar for debasisdas

You need to copy only the table data rather than entire table.

Please read more here.

Member Avatar for gulbano

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.

Member Avatar for abelLazm

Thanks Gulbano it really worked for me :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.