I am trying to get all the records from one table into another table but these tables (which are identical) are on separate servers.
Any help would be appreciated.
|show 2 more comments|
If your goal is just a one time transfer, the quickest method would be to use SQL Server Import and Export Wizard (Right click on the database - Tasks - Export Data)
And here is SQL Server Management Studio Express (64-bit) if you don't have one already.
Assuming you meant
You can use OPENROWSET
You may rule it out though because of whatever constraint you have that's stopping you from using a linked server.
If that's the case you'll need to use an ETL tool like SSIS or write a process in a client tool that does it without