[dba-SQLServer] Manually recreate database structure

Arthur Fuller fuller.artful at gmail.com
Sat Jul 23 09:25:27 CDT 2011


I could be wrong, and perhaps you already found the thing to which I am
about to refer, but in SSMS if you click on the database rather than any
given table, and then choose All Tasks and then Script, it comes out in the
right order, respecting your FKs. I'll check that in a minute but I think
that is the case.

A.

P.S.
Since when do you work on small DBs? I always thought of you as the 60M-rows
man. There could be a sequel to The Social Network here, starring oh I don't
know, maybe Christopher Walken as JWC, duelling with tables 700 columns wide
and unleashing his SSHDs upon his enemies, and delivering the requirements
OTAOB (on time and on budget). I'll call Spielberg in the morning; nah,
Christopher Nolan is the man to approach. Speaking of whom, have you seen
either Memento or Inception? This is one brilliant man.

A.

On Sat, Jul 23, 2011 at 9:09 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> Well maybe a couple of billion.  I didn't really count them.  ;)
>
> I am now trying to populate the tables with the data from the source db.
>  What a PITA.
>
> This is a small database so I will just keep on at it until I get it.
>
>
>



More information about the dba-SQLServer mailing list