var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL 2008 Script to Script Database
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.
Now with Sql Server 2008, this is integrated, and I was wondering if there is any script I can execute to generate the script.
"C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\SqlPubWiz.exe" script -C "Server=SERVER;Database=DB;Trusted_Connection=True;" DB.sql -f
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.