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