• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 46
  • Last Modified:

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
0
mustish1
Asked:
mustish1
  • 2
2 Solutions
 
mankowitzCommented:
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
 
Mohammed KhawajaManager - 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
 
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

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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now