Hey Everyone,

Back when I was using Sql Server 2005, I had the Database Publishing Wizard installed, and then I would use shortcuts so I could effectivly script my entire database and data to a .sql with a double click of a shortcut.

"C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\SqlPubWiz.exe" script -C "Server=SERVER;Database=DB;Trusted_Connection=True;" DB.sql -f
Now with Sql Server 2008, this is integrated, and I was wondering if there is any script I can execute to generate the script.

I could then add this to a shortcut and execute using osql.exe to generate my script...

anyone know of a way to do this? Or of any API that I can use to do this. Happy to write a quick app to do so.