Solved

Export data from local SQL server to remote sql server

Posted on 2016-07-21
5
63 Views
Last Modified: 2016-08-30
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
Comment
Question by:SchoolTeacher54
5 Comments
 
LVL 7

Accepted Solution

by:
Dung Dinh earned 500 total points
ID: 41724015
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
 
LVL 77

Expert Comment

by:arnold
ID: 41724071
Backup/restore if your external SQL yet does not have it. ...

What access do you have on the remote SQL?
0
 
LVL 7

Expert Comment

by:Dung Dinh
ID: 41724077
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
 
LVL 8

Expert Comment

by:Jason clark
ID: 41724537
0
 

Author Comment

by:SchoolTeacher54
ID: 41724911
Indeed, Backup and restore worked the best. I'm using Express which does not include the COPY DATABASE WIZARD.

Thank you!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question