0

Possible Duplicate:
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)

I always using xls files to transfer data between two tables. But this way is very horrible. Any alternatives? Note: There is no direct network connection between the servers.

Community
  • 1
  • 1
Neir0
  • 12,849
  • 28
  • 83
  • 139

1 Answers1

3

You should look into SQL Data Compare from RedGate. It will make your life much easier. Per no direct network connection, you can save the comparison in a script, and execute it on the other server.

James Johnson
  • 45,496
  • 8
  • 73
  • 110