Is there a way to script out a INSERT statement to select all data on a table on A server, and insert in same table on server B?


Something like:
----------------------------

Insert Into ServerB:10.10.1.1:5432.table.b

Select *
From ServerA:10.10.1.2:54000.tablea