Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

Export data from local SQL server to remote sql server

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.

Advice?
0
SchoolTeacher54
Asked:
SchoolTeacher54
1 Solution
 
Dung DinhDBA and Business Intelligence DeveloperCommented:
If it is the first time you want to transfer data from local instance, you can use BACKUP/ RESTORE. This method is simplest way I think about.

If you can connect to SQL local instance from remote server, you can use Import feature
Then Right-click on database --> Task --> Import Data

If you can connect to SQL local instance form remote server.
Then Right-click on database --> Task --> Export Data -> Export csv files.
Copy to remote server and use Import feature.
0
 
arnoldCommented:
Backup/restore if your external SQL yet does not have it. ...

What access do you have on the remote SQL?
0
 
Dung DinhDBA and Business Intelligence DeveloperCommented:
Corrected my comment
If you can connect to SQL local instance from remote server.
Then Right-click on database --> Task --> Export Data -> Export csv files.
Copy to remote server and use Import feature.

Should be:
If you can not connect to SQL local instance from remote server.
Then Right-click on database --> Task --> Export Data -> Export csv files.
Copy those files to remote server and use Import feature.
0
 
Jason clarkDBA FreelancerCommented:
0
 
SchoolTeacher54Author Commented:
Indeed, Backup and restore worked the best. I'm using Express which does not include the COPY DATABASE WIZARD.

Thank you!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now