SolvedPrivate

Exporting SQL Database

Posted on 2014-09-08
4
37 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 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 46

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

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

In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now