[dba-SQLServer] Generate Scripts from a Database

For some reason, my attempts to run the AdventureWorks.msi always error out
almost immediately. So I unzipped the Adventureworks_All_databases.zip and
it's filled with csv files, hundreds of them. I've tried it yet. There are
no sequence instructions in there. I don't know whether it matters which
order you run them in. I have never imported from a csv before but I imagine
that  it's straightforward once the database utself has been created. But of
course you are right. I would much prefer to restore from a backup of the
AdventureWorks databases. I'd prefer to get around the problem with the MSI
file even more!

Arthur

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

> 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
>