|
Home > Archive > MS SQL Server Tools > February 2006 > SQL 2005 generate multiple script files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2005 generate multiple script files
|
|
| John F. 2006-02-25, 9:45 am |
| Does anyone know how to generate multiple script files like was possible in
SQL2000? The only option I can find is to gen one huge long file, or to
clipboard or query window (still one file) - the doc says its possible but I
dont see it in the Mgmt Studio - thanks.
--------- from the doc
Script to file
Generate the script to a .sql file, either as Unicode or ANSI text. Click
the browse button (…) to specify a name and location for the file.
Script to clipboard
Save the script to the Clipboard.
Script to Query Editor
Generate the script to a Query Editor window. If no editor window is open, a
new editor window is opened as the target for the script.
--
John F.
| |
| Sue Hoegemeier 2006-02-25, 9:45 am |
| You can't in SQL 2005. Check this article and scripting
utility:
http://weblogs.sqlteam.com/billg/ar...11/22/8414.aspx
-Sue
On Thu, 23 Feb 2006 06:49:28 -0800, "John F."
<juantana@newsgroups.microsoft.com> wrote:
>Does anyone know how to generate multiple script files like was possible in
>SQL2000? The only option I can find is to gen one huge long file, or to
>clipboard or query window (still one file) - the doc says its possible but I
>dont see it in the Mgmt Studio - thanks.
>--------- from the doc
>Script to file
>Generate the script to a .sql file, either as Unicode or ANSI text. Click
>the browse button (…) to specify a name and location for the file.
>
>Script to clipboard
>Save the script to the Clipboard.
>
>Script to Query Editor
>Generate the script to a Query Editor window. If no editor window is open, a
>new editor window is opened as the target for the script.
|
|
|
|
|