Exporting SQL Database

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
mustish1Asked:
Who is Participating?
 
Mohammed KhawajaConnect With a Mentor Manager - Infrastructure:  Information TechnologyCommented:
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
 
mankowitzConnect With a Mentor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What you want to export? Only data? Data and users? Data, users and schema? ....
0
 
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Above only will export data.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.