Backup script of entire schema
485251Mar 23 2010 — edited Mar 23 2010Hi all,
What is the best way to script a schema/user and all their objects and permissions?
I've created a new application which uses a single schema in the db, there's no data to worry
about and all I really want to do is have a script(s) that would allow me to re-create on a
different server in the event of a problem.
I know I can script tables/view/procedures etc individually but am looking for a
"script all" button if such a thing exists.
Regards
Dave