Solved

Export data from local SQL server to remote sql server

Posted on 2016-07-21
5
55 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

776 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