Database creation script command line automation
Posted on 2008-10-14
I'm able to script a database (click on db, tasks, generate scripts, etc) no problem. What I need to be able to do is script the database (and all objects) automatically on a schedule to a file. I tried to run profiler while I run this via the gui but I wasn't able to see anything useful to see what it's actually doing. Does anybody know a clever way to make SQL kick out a db script from commnad line?