Export data dump

I would like to export the database(with table schema and existing data).

My database is a mdf file and i know that SQL Server 2005 Express Edition cannot do this.

I would like to know if there are any FREE tools can export the table schema and existing data to a .sql file. OR SQL Server 2005 can do this?

Thank you

You can actually do with Express if you have Backup and Restore permissions or Detach and Attach permissions or to run a DTS/SSIS package in the server where you need to upload your database. You can download the Express Advanced version which comes with Management Studio so you can use the wizard to move the database, I also have a faq that will help you with all the ways to move a SQL Server database. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/

http://forums.asp.net/thread/1454694.aspx