copy table data from remote sql server to local sql server
Posted on 2008-10-26
I need to move some updated table data from a table on a remote sql server to my local development instance of sql server.
Both the remote sql server and my local version are running Sql Server Management Studio Express 2005.
I'm not able to register the remote server locally because of an issue with the firewall and VPN connection. Our network admins are working on that issue.
So, in the meantime, I need to copy some table data from the remote sql server to my local sql server.
Is BCP the best way to accomplish this?
Export using BCP on the remote server to a comma delimited file, truncate the table on my local dev environment and import using BCP?