SolvedPrivate

Exporting SQL Database

Posted on 2014-09-08
4
42 Views
Last Modified: 2016-02-13
Hi guys: Can any one please tell me how to export database from SQL Server 2014 as I have to upload on a different hosting server

Thanks
Encl: SQL Server 2014 Screen Shot
Screenshot.png
0
Comment
Question by:mustish1
[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
  • 2
4 Comments
 
LVL 24

Assisted Solution

by:mankowitz
mankowitz earned 250 total points
ID: 40311199
You can do this fairly easily from within SSMS. Go to  the Object Explorer, right click on the database right-click and pick "Tasks" and then "Generate Scripts".

Here are some other options:
http://msdn.microsoft.com/en-us/library/ms187510.aspx
http://msdn.microsoft.com/en-us/library/ms140052.aspx
0
 
LVL 25

Accepted Solution

by:
Mohammed Khawaja earned 250 total points
ID: 40311224
If you are not able to backup and restore the database then you need to use SQL Server Integration Service (SSIS).  You could export your database to SQL or text and then import it using SSIS.  You could do a search and there are multiple YouTube videos showing you how.
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40311430
What you want to export? Only data? Data and users? Data, users and schema? ....
0
 
LVL 25

Expert Comment

by:Mohammed Khawaja
ID: 40311538
Above only will export data.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

751 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