Export data from local SQL server to remote sql server
Posted on 2016-07-21
I have 9 tables in a local SQL 2014 instance running from my Win 10 computer. My goal is to move the data out to a remote server also configured as 2014.
NO matter what I do I cannot 'export' data from the local SQL Server instance. I can set the local and the remote reference windows, but when it comes times to execute I get a message that the 'source name is not found'.
I read about using the copy database wizard but I don't see it anywhere under the Database node.