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

x
?
SolvedPrivate

Exporting SQL Database

Posted on 2014-09-08
4
Medium Priority
?
45 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
  • 2
4 Comments
 
LVL 24

Assisted Solution

by:mankowitz
mankowitz earned 1000 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 1000 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 52

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

886 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