0

The question is easy: is there a commant to backup an entire SqlServer database to a .sql file?

I developed a web application and now I need a button that permits to download a .sql file with all the data on the server.

Thanks a lot!

user3471528
  • 3,013
  • 6
  • 36
  • 60
  • I would suggest regular backup. Please read this MSDN entry: https://msdn.microsoft.com/en-us/library/ms186865.aspx. Do you really need all data in *.sql file in text format? – Paweł Dyl Oct 03 '16 at 12:13
  • 2
    Possible duplicate with [How can I get a SQL dump of a SQL Server 2008 database?](http://stackoverflow.com/questions/1391110/how-can-i-get-a-sql-dump-of-a-sql-server-2008-database) – Mincong Huang Oct 03 '16 at 12:14
  • are you using a mysql ? – chirag satapara Oct 03 '16 at 12:15
  • No, OP wants *with all the data on the server*, and script generator produce code to create/alter objects. – gofr1 Oct 03 '16 at 12:16
  • The question is easy, the answer is also easy. `N O` – Squirrel Oct 03 '16 at 13:28
  • There is no such tool inside SQL Server. But you could use this one [SQL Server Dump](http://sqlserverdump.codeplex.com/) – gofr1 Oct 03 '16 at 14:43
  • Thank you for the answers guys. Maybe I should create the dump manually..table for table.. not so funny. I will give a chance to the tool suggested by @gofr1 – user3471528 Oct 03 '16 at 15:09

0 Answers0