[dba-SQLServer] Script a Database to

Why would it do it into subversion any way other than one file?
You can add all of them at one time to the repository from your local copy.

I believe there is an option to script the logins or users.

Jobs would be one at a time.

I write a view for each table that gives me the insert script for the 
data for each table.

Permissions can be scripted at the same time as the object from Mgt Studio.

Robert

At 12:00 PM 9/23/2008, you wrote:
>Date: Tue, 23 Sep 2008 13:54:46 -0300
>From: "Arthur Fuller" <fuller.artful at gmail.com>
>Subject: [dba-SQLServer] Script a Database to
>To: "Discussion concerning MS SQL Server"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID:
>         <29f585dd0809230954t5eb0274esc205555b01fee06e at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
>Several questions in one message here....
>
>Is there a way to script all objects in a database all at once, or must it
>be one at a time? For a db with a few hundred tables and let's say 4 sprocs
>per table and a bunch of UDFs etc., this could get tedious very quickly. (I
>am using SQL 2005 on this project.) I want to version everything and stick
>it all into Subversion, but one by one, this is going to take Days of
>uninterruped excitement! Sheesh.
>
>How does one script the logins and permissions and jobs? I know how to do
>them individually but it appears it cannot be done en masse. Or maybe I'm
>missing something.
>
>The final question is, does one have to go to a third party to generate a
>script that will do all the inserts necessary to populate some or all the
>tables? I have used dbScripter in the past for this, but I left my copy on
>my computer in Canada.
>
>TIA,
>Arthur