Moving data between SQL servers

• sc-w

  Hall of Fame

  Points: 3667

  More actions

  April 1, 2011 at 8:46 am

  #142455

  Hi

  I have access to two MS SQL servers with replicated databases on each and I need to copy data from database A on SQL Server A over to database B on SQL Server B.

  These database servers are in different locations but I have connections to them both. What is the simplest option to use here?

  Thanks for any advice.

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  April 2, 2011 at 6:12 pm

  #1306795

  There are many ways, but I think more information would be useful. Are your replicated databases A nd B publishers or subscribers ?

  Are you wanting to copy a few tables ? or subsets of data ? ......... etc .....