Re: SQL Server Management Studio - one file per object

You can script multiple objects to a single file by highlighting multiple
objects on the Summary Page (F7). We do not currently support scripting
each object to a separate file, however we have heard this request and we
will try to do something about it in the near future.

This has been filed on our Microsoft Connect customer portal:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125633

You can track the progress of it throughout the product lifecycle.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server
http://blogs.msdn.com/sqlrem/


"jlccd@xxxxxxxxxxxxxxxxx" <jdamukaitis@xxxxxxxxxxx> wrote in message
news:uKXzIlTmGHA.3736@xxxxxxxxxxxxxxxxxxxxxxx
Using SQL Server Enterprise Manager objects could be selected, stored
procedures, tables, triggers... and scripted to individual files.

We are in the process of migrating to SQL Server 2005 and we are all
getting familiar with Management Studio. Typically all the objects were
scripted to individual files which were then added to source control.

How can we accomplish the same task in Management Studio.




SQL Server Management Studio (2005) - script objects: ne file per object




.

Relevant Pages

  • Datenbank via Script erzeugen - Berechtigungen?
    ... SQL Server Management Studio verwende. ... Wenn ich das Script aber aus dem Programm starte geht es nicht. ... per Script zu erzeugen. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Can I script out SQL Server jobs programmatically?
    ... Management Studio does, by watching it in profiler as you script a job... ... In SQL Server Managment Studio, ...
    (microsoft.public.sqlserver.server)
  • Re: Extract DDL, without using Mgmt Studio: How To
    ... highlight the tablewith Management Studio, right click, and script ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • Re: Script SQL 2005 database to individual files?
    ... This was trivially done in SQL 2000 with Enterprise ... but when I try in SQL 2005 through Management Studio my only ... Script to file ... I am using SQL Server 2005 Developer (which is Microsoft SQL ...
    (comp.databases.ms-sqlserver)
  • Re: describe table
    ... One of the ten commandments at our shop is to SCRIPT EVERYTHING. ... That means we make a TEXT file with an extension of .SQL and put our TABLE create right in there. ... "David Portas" wrote: ... > Enterprise Manager will allow you to script multiple objects to a single ...
    (microsoft.public.sqlserver.server)
Loading