Exporting MSSQL database to .SQL file including Data

I have a MSSQL database which i am managing with MS SQL Server Management Studio 2005. Can someone explain me how I can export a database into a .SQL file including the INSERT statements for the data?

I've managed to do it before but I forgot how I did it,

Thanks.
inghfsAsked:
Who is Participating?
 
Daniel WilsonConnect With a Mentor Commented:
I've seen a utility for MySQL that does this ...

In MS SQL Server, scripting the schema out is simple -- from your question I think you've already figured that out.

To get the data, I recommend BPC.

Of course ... if transferring the entire DB is what you want to do, a backup file is actually preferable.
0
All Courses

From novice to tech pro — start learning today.