[dba-SQLServer] Generate Scripts from a Database

Asger Blond ab-mi at post3.tele.dk
Thu Feb 5 18:47:44 CST 2009


Well, I noticed that this option doesn't exist previous to 2008. Lucky you
are using that.
But curious: why don't you just make a backup and restore, eventually to a
different db name? By fare more efficient.

Asger
-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Arthur
Fuller
Sendt: 6. februar 2009 01:30
Til: Discussion concerning MS SQL Server
Emne: Re: [dba-SQLServer] Generate Scripts from a Database

Thanks, Asger! I knew I'd seen it in there somewhere!

Arthur

On Thu, Feb 5, 2009 at 7:15 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> On the wizard page "Choose Script Options" scroll to the section
> "Table/View
> Options" and set "Scrip Data" to True.
> This is SQL Server 2008 - don't remember if it's the same in 2005.
>
> Asger
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com






More information about the dba-SQLServer mailing list