Solved

Export data from local SQL server to remote sql server

Posted on 2016-07-21
5
109 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 8

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 79

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 8

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 10

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

622 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