up vote 2 down vote favorite
1
share [g+] share [fb]

Possible Duplicate:
Dump Microsoft SQL Server database to an SQL script

Is there any way to export a Microsoft SQL Server database to an sql script?

I'm looking for something which behaves similarly to mysqldump, taking a database name, and producing a single script which will recreate all the tables, stored procedures, reinsert all the data etc.

I've seen http://vyaskn.tripod.com/code.htm#inserts, but I ideally want something to recreate everything (not just the data) which works in a single step to produce the final script.

Thanks in advance

link|improve this question
feedback

closed as exact duplicate by Ben Pilbrow, Iain♦, sysadmin1138♦ Feb 20 '11 at 17:46

This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.

1 Answer

up vote 0 down vote accepted

this is a duplicate: Dump Microsoft SQL Server database to an SQL script

link|improve this answer
feedback

Not the answer you're looking for? Browse other questions tagged or ask your own question.